Shortlist Data

[Techtrend]

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

 

[sdsurzh]

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

 

[Techtrend]

Hi

Need formula based as it is auto sheet and value keeps changing,
no use of filters.

regarsd
vinod

 

[bosco_yip]

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

 

[MohanBabu1023]

Hi Bosco,

Formula seems great and it is very useful for me

Regards,
Mohan

 

[Techtrend]

Hi Bosco,

Thanks for the work,
great Job.

Thanks
Narendra