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
please check again
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
[Uploaded an Excel file]
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
Sure, you could download the file by going to File>Download As > Microsoft Excel
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.
