Diagnostic daytime multiple sleep latency test (MSLT) is used to diagnose narcolepsy and to measure the degree of daytime sleepiness. It measures how quickly you fall asleep in quiet situations during the day. It also monitors how quickly and how often you enter REM sleep.
Array formulas provide a way by which Excel users can discover such useful information. To explain the power of array formulas I'll use this database. It shows sales by Seller, Product, Region, and Customer, with Quantity and Total Sales, in dollars. I named each column of data with the label shown in row 1.
More Excel array formula examples. And here are a few more examples of Excel array formulas that might be helpful. 1  Look up with multiple criteria-a powerful INDEX / MATCH function that can look up by values in 2 different columns. 2  Get all duplicate values in the lookup range-how to get all instances of the lookup value.