Compare columns

[Solved/Closed]
Report
-
Posts
6
Registration date
Friday October 14, 2011
Status
Member
Last seen
December 13, 2011
-
Hello,


I have a situation like below.

Column A Column B Column C
A1 1
A2 1
A3 2
A4 2
A5 2
A6 3
A7 2


I want to compare cells in Column A, to find their related in Column B, and to display in Column C the ADD logic. for example: IF A1=A2=A3, in column C must be displayed 1/1/2, or IF A6=A7, in column C must be displayed 3/2.

Could anyone assist me ASAP.

Thank you in advance


3 replies

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Sara,

What is ADD logic?

Where is the logic in: if A1=A2=A3 (which is false) then 1/1/2?
And which cell should contain 1/1/2? C1?

C1 formula could be =B1 & "/" & B2 & "/" & B3.

Could you clarify your query?

Best regards,
Trowa
Posts
6
Registration date
Friday October 14, 2011
Status
Member
Last seen
December 13, 2011

im trying to figure out the same problem..
Hi All,

A1 A2 A3 are the cells, which could be identical. i solved the problem yesterday using the formula that u gave . Being that i had almost 400cells, I divided them like below example:

I had first:
Column 1 Column 2
ITALY 2
ITALY 3
FRANCE 1
FRANCE 4
Greece 2
Greece 2
Greece 2
Germany 3
Germany 3
Germany 3
Germany 3
Germany 3
..... ...

I divided them into different sheets, according the times that one name was repeated, for ex, Italy and France repeated twice, and used the formula =B1&"/"&B2 , and after it looked like below:
Column1 Column2 Column3
ITALY 2 2/3
ITALY 3 3/1
FRANCE 1 1/4
FRANCE 4 4/

Than copy-Paste special(Values and number formats) the Column3.
Go to DATA-Remove Duplicates, uncheck tick for Column2 and Column3.OK.
Delete Column2.
than i had what i wanted:
ITALY 1 2/3
FRANCE 1 1/4

thanks to All.

p.s in cases of 5 cells use =B1&"/"&B2&"/"&B3&B4&"/"&B5
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Sara,

Thanks for sharing your solution.
Posts
6
Registration date
Friday October 14, 2011
Status
Member
Last seen
December 13, 2011

Thanks a lot