Hy,
I am trying to display last 5 value from a table based on some criteria.
I have managed to find a solution for the first 5 values. How can i modify this to display last 5 values.
I have attached a spreadsheet.
Thanks,
Hy,
I am trying to display last 5 value from a table based on some criteria.
I have managed to find a solution for the first 5 values. How can i modify this to display last 5 values.
I have attached a spreadsheet.
Thanks,
may be this
IF(ROWS(C$7:C7)>$D$6,"",INDEX(D$22:D$51,LARGE(IF(($B$22:$B$51=$C$3)*($C$22:$C$51=$D$3),ROW($B$22:$B$51)-ROW($B$22)+1),ROWS(C$7:C7))))
☚ Click ★ just below left if it helps, Boo?ath?
Works!!!
Thanks,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks