Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

Learn how to generate random numbers in Excel using RAND, RANDBETWEEN, and RANDARRAY. Step-by-step guide with practical tips included ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Tools like Ajelix, Promptloop, and Numerous AI specialize in Excel analysis and automation, allowing you to manipulate data using simple, natural language commands.