Hi there! I have a list with over 11K emails from a user panel recruiting spreadsheet. I have a list of 300 emails that are spread all throughout this list that I need to find. [scenario] When I recruit users for tests that I need to run...I need to identify which users I have reached out to and which ones I have selected. I would like to to a Find All (at once) and some how indicate in a column with an "x". Any ideas?
you could use conditional formatting to highlight OR as you say add a Y
so if the 11K list is in column A1 to A11000
add a formula to B1
AND Assuming the list of 300 emails are in say column F1:F300
then
in B1
=IF (Countif( $F$1:$F$300, A1), "Y","N")
then filter on Y
and use a conditional formatting
Select A1:A11000
formula
=Countif( $F$1:$F$300, A1)
choose fill colour
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks