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
thomaswinter85 Posts 6 Registration date Friday October 14, 2011 Status Member Last seen December 13, 2011 - Dec 12, 2011 at 04:51 AM
Related:
- Compare columns
- Beyond compare - Download - File management
- Display two columns in data validation list but return only one - Guide
- Excel compare two columns for partial matches - Guide
- Excel compare two columns for missing values - Excel Forum
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
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
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
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
thomaswinter85
Posts
6
Registration date
Friday October 14, 2011
Status
Member
Last seen
December 13, 2011
Oct 14, 2011 at 07:13 AM
Oct 14, 2011 at 07:13 AM
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 17, 2011 at 08:47 AM
Oct 17, 2011 at 08:47 AM
Hi Sara,
Thanks for sharing your solution.
Thanks for sharing your solution.
thomaswinter85
Posts
6
Registration date
Friday October 14, 2011
Status
Member
Last seen
December 13, 2011
Dec 12, 2011 at 04:51 AM
Dec 12, 2011 at 04:51 AM
Thanks a lot
