Previous Topic Next Topic

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

Answer 1 / 3
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
Answer 2 / 3
Posts
6
Registration date
Friday October 14, 2011
Status
Member
Last seen
December 13, 2011
im trying to figure out the same problem..
Answer 3 / 3

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
Report
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
 487
Hi Sara,

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