In rows 1 thru 50 of Column A the cell will contain a number from 1 to 10. Next to it in Column B is an unrelated unique number. What I would like to do starting in cell D1 is list the cell value of Column B for the corresponding row of the first time a "1" appears in Column A. In cell D2 would be Column B's value for the 2nd occurence of "1" in Column A, cell D3 would have the 3rd occurence, thru cell D5. In cells E1:E5 would be the same idea for "2" in Column A. Cells F1:F5 would be for "3", etc until cells M1:M5 which would be for values in Column B where a "10" was in Column A.
I know I can find a way to do this with Filters, but I'm hoping to find a way with just a straight formula or custom function. Somehow I think I need to learn more about Index and Indirect, but I keep getting confused when I try.
Any help would be greatly appreciated!
I know I can find a way to do this with Filters, but I'm hoping to find a way with just a straight formula or custom function. Somehow I think I need to learn more about Index and Indirect, but I keep getting confused when I try.
Any help would be greatly appreciated!