Selemat,
you may try to use array formula,
it look like what oeldere's workbook, but array formula may cause the lag.
in A2, paste this
array formula,
it change the table cell that not blank to row number (B5, C5, B6, "",F3 > 5,5,6,"",3) and use SMALL function to sort the row (3,5,5,6,"") and use INDEX to display the name. (Kel, Ash, Ash, Fish,"")
in B2, paste this
array formula,
similar to above but the small(array,
K) is change by repeat of current name (1,2,3,1,2,1,2,3,4,5,...)
in C2 paste this formula,
normal index function, (=index([array], match(),match())
PS:
array formula is need to confirm by
Ctrl + Shift + Enter instead of
Enter only
If not understand, please follow below step:
1, Paste the formula to the cell
2, Double click on the cell
3, press
Ctrl + Shift + Enter
It show
{ sign in front of formula. (ie
{=index(.....)
Bookmarks