• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

filter the column based on the conditional format

giri ravirrala

New Member
Hi,

i want to generate the list from B5:B16 based on the condition "qty>90" of C5:C16
as E5:E8

could please help me , what formula i need to use at cell E5 to generate the values like E5:E8

please find the attachement

Thanks and regards,
Giri.
 

Attachments

  • conditional formating.xlsx
    10.6 KB · Views: 2
@Chihiro
Yep, it's amazing how many times I've used that technique. Learned it awhile, and got tired of typing an explanation in the forum that I decided to write an article for Chandoo. :cool:
Glad you liked it!
 
Back
Top