Okay,
imagine two columns: A9:A10, and H9:H10. All 5 cells have Date values in them, but they could be in any order. In M8:M12 range, I want a list of the Cells: (A9,H10,A10,H9,H11) in order of the date values, but without using VBA.
Can I do this?
Currently I have L8:L12 containing the formula: SMALL(($A$9:$A$10,$H$9:$H$11), ROW(1:1))
which naturally the ROW(1:1) becomes 2:2, 3:3 etc down the line so i get the 1,2,3,4,5th smallest number in the original array. However, MATCH and LOOKUP do not seem to like the same "Array" notation as SMALL will allow. I've been trying to figure out how to get each cell value in sequence but so far no luck.
Any ideas?
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
Bookmarks