T Techtrend Member Sep 19, 2016 #1 Hello Need to filter the data only when there is a data in a Col , The details are mentioned in the attached document. Thanks for you time Vinod Attachments Short list Scripts.xls 23 KB · Views: 5
Hello Need to filter the data only when there is a data in a Col , The details are mentioned in the attached document. Thanks for you time Vinod
S sdsurzh Member Sep 19, 2016 #2 Hi, You can use advanced filter option. please refer the below links for further inforamtion. http://www.excel-easy.com/examples/advanced-filter.html http://www.contextures.com/xladvfilter01.html Regards, SK
Hi, You can use advanced filter option. please refer the below links for further inforamtion. http://www.excel-easy.com/examples/advanced-filter.html http://www.contextures.com/xladvfilter01.html Regards, SK
T Techtrend Member Sep 19, 2016 #3 Hi Need formula based as it is auto sheet and value keeps changing, no use of filters. regarsd vinod
B bosco_yip Excel Ninja Sep 19, 2016 #4 Try........ In E2, copy across and down : =INDEX(A$1:A$1000,SMALL(INDEX(($B$2:$B$100="")/1%+ROW($2:$100),0),ROWS($1:1)))&"" Regards Bosco Attachments Short list Scripts.xls 26.5 KB · Views: 9
Try........ In E2, copy across and down : =INDEX(A$1:A$1000,SMALL(INDEX(($B$2:$B$100="")/1%+ROW($2:$100),0),ROWS($1:1)))&"" Regards Bosco
M MohanBabu1023 Member Sep 19, 2016 #5 Hi Bosco, Formula seems great and it is very useful for me Regards, Mohan