Question description:
This user has given permission to use the problem statement for this
blog.
I have 2 excel files.
I want to highlight the values in column A of Table 1 which appear in Column 1 of table 2.
Thanks for your help
Solved by S. H. in 43 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
15/08/2018 - 07:34
hi!
Excelchat Expert
15/08/2018 - 07:34
Hello!
User
15/08/2018 - 07:34
Im not sure if you got my question?
Excelchat Expert
15/08/2018 - 07:34
How can i help you today? :)
User
15/08/2018 - 07:34
alright I know i know how to do this but im going crazy so i give up
Excelchat Expert
15/08/2018 - 07:35
what i undestood is that you want to be able to identify the records from your first file that are as well on the second file
User
15/08/2018 - 07:35
Yes!
Excelchat Expert
15/08/2018 - 07:35
correct?
Excelchat Expert
15/08/2018 - 07:35
sure, i can help you with that
User
15/08/2018 - 07:35
loyalty card numbers
Excelchat Expert
15/08/2018 - 07:35
can you share with me your 2 files please?
User
15/08/2018 - 07:35
on this table on the right?
User
15/08/2018 - 07:36
or just as files
Excelchat Expert
15/08/2018 - 07:36
if you want you can send them as attachment
Excelchat Expert
15/08/2018 - 07:36
so i can work on them on faster
Excelchat Expert
15/08/2018 - 07:36
then i'll explain you what i did
User
15/08/2018 - 07:36
ok! give me just a second
User
15/08/2018 - 07:36
fantastic
User
15/08/2018 - 07:36
let me just merge my 3 e3xcel tables
Excelchat Expert
15/08/2018 - 07:36
okok!
User
15/08/2018 - 07:37
thanks won't be long
User
15/08/2018 - 07:37
sorry
Excelchat Expert
15/08/2018 - 07:37
it's ok, don't worry
User
15/08/2018 - 07:38
sheet 1
User
15/08/2018 - 07:39
is it sending you the file?
[Uploaded an Excel file]
User
15/08/2018 - 07:39
so on that file
Excelchat Expert
15/08/2018 - 07:39
yes
User
15/08/2018 - 07:39
i want to highlight all the numbers from file 2 column 1 that appear in the first file in column 1
User
15/08/2018 - 07:40
give me just a sec for the second one
Excelchat Expert
15/08/2018 - 07:40
okok
User
15/08/2018 - 07:42
[Uploaded an Excel file]
User
15/08/2018 - 07:42
there you go =)
Excelchat Expert
15/08/2018 - 07:42
on the first file that you send me
User
15/08/2018 - 07:42
yes
Excelchat Expert
15/08/2018 - 07:42
which sheet would it be? sheet 2?
User
15/08/2018 - 07:43
its actually from the second file
User
15/08/2018 - 07:43
but i can merge them on one if you want and resend it
User
15/08/2018 - 07:43
sorry i didnt think youd actually do i i thought you would just explain how to do it
Excelchat Expert
15/08/2018 - 07:43
i can do both
User
15/08/2018 - 07:43
SHEET 1
User
15/08/2018 - 07:43
sheet 2 was a test i was trying
Excelchat Expert
15/08/2018 - 07:43
for example
Excelchat Expert
15/08/2018 - 07:44
what i would do for this is
Excelchat Expert
15/08/2018 - 07:44
on the file that you want it to be marked
Excelchat Expert
15/08/2018 - 07:44
(file 2) right?
User
15/08/2018 - 07:45
let me merge them it will be a lot easier
Excelchat Expert
15/08/2018 - 07:45
okok
User
15/08/2018 - 07:46
[Uploaded an Excel file]
User
15/08/2018 - 07:46
youll notice on this file stuff is red in sheet 2 .. probably from my failed formula
Excelchat Expert
15/08/2018 - 07:47
ok, i'm dowloading it
User
15/08/2018 - 07:47
so i want to highlight in sheet 1 column 1 the values from column 1 in sheet 2 that appear in column 1 sheet 1
User
15/08/2018 - 07:47
do we just have 6 minutes left?
Excelchat Expert
15/08/2018 - 07:48
yes, but you can extend it
Excelchat Expert
15/08/2018 - 07:48
it will allow you to extend when timer hits 5-
Excelchat Expert
15/08/2018 - 07:49
ok, i'm working on it
User
15/08/2018 - 07:49
thanks
Excelchat Expert
15/08/2018 - 07:49
does it allow you to extend?
Excelchat Expert
15/08/2018 - 07:49
time*
User
15/08/2018 - 07:49
nope
User
15/08/2018 - 07:50
and i presume to extend i have to pay
User
15/08/2018 - 07:50
i dont have access to the company card
Excelchat Expert
15/08/2018 - 07:50
oh ok
User
15/08/2018 - 07:50
so we have 4 minutes lol
Excelchat Expert
15/08/2018 - 07:50
basically
Excelchat Expert
15/08/2018 - 07:50
what i would recommend you to do is this
User
15/08/2018 - 07:51
it allowed me to extend
Excelchat Expert
15/08/2018 - 07:51
perfect! time was extended!
Excelchat Expert
15/08/2018 - 07:51
i was a bit nervous haha
User
15/08/2018 - 07:51
hehe
User
15/08/2018 - 07:51
so was i
Excelchat Expert
15/08/2018 - 07:52
first i would do this, a vlookup on the final columns
User
15/08/2018 - 07:52
ok
Excelchat Expert
15/08/2018 - 07:52
then i would add a condittion formating for column b
User
15/08/2018 - 07:52
why on the final columns
User
15/08/2018 - 07:53
the only column i want is column A
User
15/08/2018 - 07:53
1
Excelchat Expert
15/08/2018 - 07:53
where i would do, while value on the e column is different than #N/A color them on yellow
User
15/08/2018 - 07:53
i want to know which clients on sheet2 appear on sheet 2 and highlight them in sheet 1
Excelchat Expert
15/08/2018 - 07:54
ok, let me do it on the file
User
15/08/2018 - 07:54
sorry i graduated 10 years ago
Excelchat Expert
15/08/2018 - 07:54
then i'll explain you what i did once i send it back to you
User
15/08/2018 - 07:54
lol
User
15/08/2018 - 07:54
ok
User
15/08/2018 - 07:54
thank you very much
User
15/08/2018 - 07:54
i do want to understand
Excelchat Expert
15/08/2018 - 07:55
i will search it by card# right?
User
15/08/2018 - 07:55
yeah exactly
User
15/08/2018 - 07:55
all by card number
Excelchat Expert
15/08/2018 - 07:55
which is what column in sheet 1?
Excelchat Expert
15/08/2018 - 07:55
VIP #
?
User
15/08/2018 - 07:56
Card / in sheet 2 or VIP in 1
User
15/08/2018 - 07:56
so column 2 sorry
Excelchat Expert
15/08/2018 - 07:56
ok, and you want me to mark it on sheet 1, correct?
User
15/08/2018 - 07:56
yes
Excelchat Expert
15/08/2018 - 07:56
ok
User
15/08/2018 - 07:56
highlight on sheet 1 the customers that appear in sheet 2
User
15/08/2018 - 07:56
by card number
User
15/08/2018 - 07:57
as u can notice i wanted to do an IF formula which is why i created the true or falso column
Excelchat Expert
15/08/2018 - 07:58
okok
User
15/08/2018 - 07:59
brb
Excelchat Expert
15/08/2018 - 07:59
just to be sure
Excelchat Expert
15/08/2018 - 07:59
this is on your sheet 2, right?
Excelchat Expert
15/08/2018 - 07:59
--->>>
User
15/08/2018 - 08:01
?
User
15/08/2018 - 08:01
whats on my sheet 2
Excelchat Expert
15/08/2018 - 08:01
what i copied on the excel sheet on the right
User
15/08/2018 - 08:01
i dont see anything
Excelchat Expert
15/08/2018 - 08:02
row 12 and below
User
15/08/2018 - 08:02
the excel on the right is blank
Excelchat Expert
15/08/2018 - 08:02
oh ok
User
15/08/2018 - 08:02
a ha
User
15/08/2018 - 08:03
now i see it
User
15/08/2018 - 08:03
thats sheet 2
Excelchat Expert
15/08/2018 - 08:04
okok
Excelchat Expert
15/08/2018 - 08:04
give me a second
User
15/08/2018 - 08:04
no prob you have 9 min 23 sec lol
Excelchat Expert
15/08/2018 - 08:08
I'm still with you give me a few minutes more
User
15/08/2018 - 08:08
no prob
User
15/08/2018 - 08:09
ms.brodeur@motointer.com is my email if ever this runs out of time.. although you probably can't do that which i understand
Excelchat Expert
15/08/2018 - 08:09
you can extend again, i believe
Excelchat Expert
15/08/2018 - 08:10
sadly, i cannot contact you outside the tool. We are not allowed to do that
User
15/08/2018 - 08:10
ok .. i juste have to leave work for my nieces swimming class which wont wait for me
User
15/08/2018 - 08:10
can i extend and you send me the file while im not there?
User
15/08/2018 - 08:10
or it will be gone by tomorrow
Excelchat Expert
15/08/2018 - 08:13
[Uploaded an Excel file]
Excelchat Expert
15/08/2018 - 08:13
Ok, please look attached file
User
15/08/2018 - 08:14
So all the names highlighted in yellow are the ones that appear on sheet 2
Excelchat Expert
15/08/2018 - 08:14
what i did is, on sheet 1 column x, i created a formula that will look for column B value into the sheet 2 Column A
User
15/08/2018 - 08:15
Vlookup
Excelchat Expert
15/08/2018 - 08:15
then i created a condition formatting in the name
Excelchat Expert
15/08/2018 - 08:15
all yellows are the ones found
Excelchat Expert
15/08/2018 - 08:15
correct
User
15/08/2018 - 08:15
YOU ARE THE BEST !
User
15/08/2018 - 08:15
are u in the states
Excelchat Expert
15/08/2018 - 08:15
does this work for you?
User
15/08/2018 - 08:15
absolutely
Excelchat Expert
15/08/2018 - 08:15
perfect!
Excelchat Expert
15/08/2018 - 08:15
glad i coud help you
Excelchat Expert
15/08/2018 - 08:16
is there anything else i can help you with?
User
15/08/2018 - 08:16
i really appreciate it
User
15/08/2018 - 08:16
no that is all
Excelchat Expert
15/08/2018 - 08:16
you're welcome! thank you very much for using the service
Excelchat Expert
15/08/2018 - 08:16
hope to be able to help you again!
User
15/08/2018 - 08:17
have a great evening! are you guys in Canada or the UST6
User
15/08/2018 - 08:17
US
User
15/08/2018 - 08:17
i have to run
User
15/08/2018 - 08:17
thanks
User
15/08/2018 - 08:17
again
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.