• 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.

Extract data and add to another sheet

H

Hazra Hadee

Member
Hello,

I have a sheet with data like first name, last name, mobile and email. Plus I am entering yes and no for each person/row, e.g. is this person an admin? is this person a volunteer.

If the answer to "is the person an admin", Yes, then in another sheet, I want to grab the name, mob and email address. What is the best formula to use to grab the data for these fields? Please help.

Appreciate it much
 
I used the formula =IF(cell="Yes",cell value,"") The problem with this is, it also gives you a blank row if the cell value is "No".

Is there a better formula to do the same? Thanks
 
You must log in or register to reply here.
Back
Top