When the array is scanned, green or red spots indicate expression of the gene in only one sample, and yellow spots indicate expression of the gene in both samples.

Here’s a simple example explaining how the new SORT array function works. Columns A and B in the screenshot below (cells A3:B17) contain unsorted sales data by state. To sort these data using a ...