Compare columns
Solved/Closed
Sara
-
Oct 13, 2011 at 04:53 AM
thomaswinter85
thomaswinter85
- Posts
- 6
- Registration date
- Friday October 14, 2011
- Status
- Member
- Last seen
- December 13, 2011
Related:
- Compare columns
- Excel - Compare column A & B give results in column C - How-To - Excel
- Comparing columns and returning value ✓ - Forum - Excel
- Compare columns and create list of duplicates ✓ - Forum - Excel
- Comparing columns in Excel 2010 ✓ - Forum - Excel
- Compare Column A to Column B and return Column C ✓ - Forum - Excel
3 replies
TrowaD
Oct 13, 2011 at 10:08 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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
Oct 14, 2011 at 07:13 AM
- 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..
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
Oct 17, 2011 at 08:47 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Oct 17, 2011 at 08:47 AM
Hi Sara,
Thanks for sharing your solution.
Thanks for sharing your solution.
thomaswinter85
Dec 12, 2011 at 04:51 AM
- 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