Hi Scott, welcome to the forum! Paste this ARRAY FORMULA* in D5 and copy TO THE LEFT:
Edited 11:53. Changed SMALL to LARGE. NOTE: Adjust the COLUMNS($D5:D5) clause to point to the cell where you paste the formula. Be sure to get the $ dollar sign right.
Row\Col |
A |
B |
C |
D |
BK |
BL |
BM |
BN |
BO |
BP |
BQ |
BR |
5 |
aa |
bb |
cc |
dd |
|
aa |
bb |
|
cc |
|
dd |
|
*Always press CTRL+SHIFT+ENTER to confirm entry after pasting or editing an ARRAY FORMULA in the Formula Bar.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Bookmarks