How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 30128
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

If I have 4000 rows of data on 4000 unique indiviuduals, each

This answer was rated:

If I have 4000 rows of data on 4000 unique indiviuduals, each individual designated as a value with the first cell of each row, how do I isolate 2000 of the individuals within the 4000 rows of data based on a separate excel list the identifies the 2000 individuals that need to be isolated.
Thank you for your question, my name is Richard.

You do this using Conditional Formating.

First, put the list from the seperate sheet, into the current workbook (you can do it on another sheet)

Then, lets assume the Column is A that has the cell that identifies the individual.

And Sheet2 Column A has the list that identifies the individual

Select cell A1, go to top menu's > format > conditional format.

You set the conditional format as a formula a
formula is: =if(Sheet2!A1=1,true,false) and apply desired format eg: Fill Cell Yellow.

Click OK.

Drag cell A1 down.

As you already have data in column A, select "format only" from the small square that appears when you are done dragging.

This will then highlight all Cells that match with the Cells in your list.

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you
Richard and 5 other Microsoft Office Specialists are ready to help you