Compare columns

Solved/Closed
Sara - Oct 13, 2011 at 04:53 AM
thomaswinter85 Posts 6 Registration date Friday October 14, 2011 Status Member Last seen December 13, 2011 - Dec 12, 2011 at 04:51 AM
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 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 13, 2011 at 10:08 AM
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
0
thomaswinter85 Posts 6 Registration date Friday October 14, 2011 Status Member Last seen December 13, 2011
Oct 14, 2011 at 07:13 AM
im trying to figure out the same problem..
0
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
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 17, 2011 at 08:47 AM
Hi Sara,

Thanks for sharing your solution.
0
thomaswinter85 Posts 6 Registration date Friday October 14, 2011 Status Member Last seen December 13, 2011
Dec 12, 2011 at 04:51 AM
Thanks a lot
0