![]() And the IF(C1="","" part at the beginning is to tell the function not to calculate at all if the row above it is empty. The IFERROR piece is used to ignore the potential error from the last step. Then finally we take the 2, 3, 5 from that step and put it in the INDEX function to get the item from column A. So in row 2 we get row 2 from the array, in row 3 we get 3 (second smallest) from the array, in row 4 we get 5 from the array (third smallest), and for all other rows we get an error (SMALL ignores non-numeric values). ![]() Where the 1 increments as we go down the column. Where A1=1, A2=2, A3=3, then the result will be, 1) If you turn it into an array formula by putting a range instead of a single cell and confirm with CSE, like this: Here's a brief rundown of how it works:įirst of all, an array function (the Control-Shift-Enter part) tells a function to handle a range of values instead of 1 value. I think it's better if they gain an understanding, so that they can do more on their own later. ![]() ![]() I appreciate it when someone asks questions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |