# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello I have a list of codes, some of these a duplicated in one column. In another column I have a list of prices. I am trying to work out how I identify when the code and two prices match and when they are different please? thank you
Solved by O. C. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 22/06/2018 - 02:25
Hi! How are you?
Excelchat Expert 22/06/2018 - 02:26
Hello? Are you with me?
User 22/06/2018 - 02:26
yes
Excelchat Expert 22/06/2018 - 02:26
Cool. Thanks for responding.
Excelchat Expert 22/06/2018 - 02:27
By the way, is it possible for you to paste the data (or sample data) in the document preview on the right?
Excelchat Expert 22/06/2018 - 02:27
That is so I could better visualize and understand your requirement.
User 22/06/2018 - 02:29
yes I will do this now.
User 22/06/2018 - 02:29
I am trying to highlight where the code is the same and the price please?
Excelchat Expert 22/06/2018 - 02:30
Okay, so for example row 2 and 3 should tagged as Same price
Excelchat Expert 22/06/2018 - 02:30
and row 6 and 7 are not, right?
User 22/06/2018 - 02:31
yes and row 6 and 7 should be identified as different.
Excelchat Expert 22/06/2018 - 02:31
okay, thanks for confirming... I'll do the tagging in column C.
Excelchat Expert 22/06/2018 - 02:31
Please stay with me as I build the formula for you, okay?
User 22/06/2018 - 02:32
ok
Excelchat Expert 22/06/2018 - 02:32
One clarification, are there instances where the code appears more than twice?
Excelchat Expert 22/06/2018 - 02:34
Hello? are you still there?
User 22/06/2018 - 02:34
yes
User 22/06/2018 - 02:34
potentially yes.
Excelchat Expert 22/06/2018 - 02:35
Oh I see. so how should i tag it if, say, 2 of the 3 codes has the same price and the other one is not?
User 22/06/2018 - 02:37
all three need to be identified as not been consistent?
Excelchat Expert 22/06/2018 - 02:38
Alright, thanks...
Excelchat Expert 22/06/2018 - 02:38
I am actually working on excel now as this will involve array formula and it would be faster if I do it in excel locally.
Excelchat Expert 22/06/2018 - 02:38
So please wait a little bit more as I figure out the correct formula
Excelchat Expert 22/06/2018 - 02:39
If we need more time - we are actually allowed for a maximum of 2 20-minutes extension per session for free
Excelchat Expert 22/06/2018 - 02:39
So kindly, select YES/OK if you get a prompt to extend the session later on
User 22/06/2018 - 02:39
yes will do.....
Excelchat Expert 22/06/2018 - 02:40
Thanks!
Excelchat Expert 22/06/2018 - 02:41
Hi! It turned out faster than expected.
Excelchat Expert 22/06/2018 - 02:41
Could you please check values in column C?
User 22/06/2018 - 02:42
the first two look incorrect.
Excelchat Expert 22/06/2018 - 02:42
Sorry, I copied the wrong formula
Excelchat Expert 22/06/2018 - 02:42
Excelchat Expert 22/06/2018 - 02:42
I also added another line to check if it works in case where we have 3 duplicate codes
Excelchat Expert 22/06/2018 - 02:43
As you could see i tried adding 7649 in row 13 with price of 50
Excelchat Expert 22/06/2018 - 02:43
it therefore tag rows 4,5 and 13 as No
Excelchat Expert 22/06/2018 - 02:45
By the way, are you using Excel or Google Sheets?
Excelchat Expert 22/06/2018 - 02:45
If you are using excel - in this example you type the formula in cell C2 =IF(AND(IF(A:A=A2,B:B=B2,TRUE)),"Yes","No")
User 22/06/2018 - 02:45
excel
Excelchat Expert 22/06/2018 - 02:46
then press CTRL+SHIFT+ENTER for it to be assessed as Array Formula
Excelchat Expert 22/06/2018 - 02:46
Or if you like, you could send me the excel file and I'll do the edit for you.
Excelchat Expert 22/06/2018 - 02:47
You could send the file as an attachment by clicking the paperclip button as shown in the screenshot below
User 22/06/2018 - 02:48
thank you I will give it a look at this as I need to jump on a conference call with my colleague.
Excelchat Expert 22/06/2018 - 02:49
Excelchat Expert 22/06/2018 - 02:50
If you don't have any more clarifications at this point, you may end the session by hovering over the TIME REMAINING section of this chat window and select END SESSION
Excelchat Expert 22/06/2018 - 02:50
Also, I'd appreciate if you could drop a few lines for your kind and honest feedback on a survey after this session. Any constructive criticism or points for improvement are also welcome. Many thanks and have a good day!

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.