Hi,
i have List B8:E37 generated using data validation table.in Column E, i have use formula as =IFERROR(INDEX(Choices!$F$2:$F$90,SMALL(IF(($C$4=Choices!$F$2:$F$90)*IF($D$4="ALL",1,($D$4=Choices!$G$2:$G$90)),ROW(Choices!$F$2:$F$90)-ROW(Choices!$F$2)+1,""),ROWS(Choices!$F$2:F2))),"") in which if the data is not present it will added "" in that cell of E Column.
E8:E24 contains data whereas E25:E37 is displayed as blank but formula is there.
Since in my case E24 is the last Non Empty Cell. but when i use formula to find out Last Column number I get as 37.
pl help to find out last Non Empty Cell.
below is the code i used to verify
Below is the code which i am using
Bookmarks