I am using this formula which works fine (if the set has complete data), I want to get data of the last available cell
=FILTER(Table1[DecEnd],Table1[Item]=$B$10)
Desired formula :
=FILTER(Table1[JanEnd, FebEnd MarEnd ....DecEnd],Table1[Item]=$B$10)
Need to filter JanEnd FebEnd MarEnd AprEnd MayEnd ....and so on..up to DecEnd.
Please see the attached sample file.
Thank you.
Bookmarks