Highlight and Publish Data Separately

[suresh kannah]

Need help to Highlight and Publish Data Separately based on the condition,
The details are mentioned in the Attached excel

Thanks for your time
Suresh

 

[David Evans]

Have you thought of making your data range into an Excel Table and filter out anything that is not Blank under HBLB?

Just hit the filter on Col E and your done

If you really need to have the data in a separate location let us know and we can come up with a mechanism to do so.

Or you can do a search and find this on Chandoo - a great source

http://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/

 

[tomas]

Hi

probably not the most straightforward way

 

[suresh kannah]

Mr.David

The value keeps changing in real time and filter wont be possible,
In real time if conditions meet need to get it a diff place as there are more then 200 SYMBOLS to monitor in real time.

FOrmula would be better.

Thanks
Suresh

 

[jindon]

Alter "1000" to suite.
In G1:
=IFERROR(INDEX($A$1:$E$1000,SMALL(IF($E$1:$E$1000<>"",ROW($E$1:$E$1000)),ROW(A1)),COLUMN(A1)),"")

Confirm with Ctrl + Shift + Enter (Array formula entry)
Then copy across+down.

 

[suresh kannah]

Thanks it works and very simple to.

Thanks for your time
Suresh