Compare columns
Solved/Closed
Sara
-
13 Oct 2011 à 04:53
thomaswinter85 Posts 6 Registration date Friday 14 October 2011 Status Member Last seen 13 December 2011 - 12 Dec 2011 à 04:51
thomaswinter85 Posts 6 Registration date Friday 14 October 2011 Status Member Last seen 13 December 2011 - 12 Dec 2011 à 04:51
Related:
- Compare columns
- Beyond compare - Download - File management
- "Compare versions word" - Guide
- How to merge and compare two excel files - Guide
- How to delete columns in word - Guide
- Tweetdeck larger columns - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
13 Oct 2011 à 10:08
13 Oct 2011 à 10:08
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 14 October 2011
Status
Member
Last seen
13 December 2011
14 Oct 2011 à 07:13
14 Oct 2011 à 07:13
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 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
17 Oct 2011 à 08:47
17 Oct 2011 à 08:47
Hi Sara,
Thanks for sharing your solution.
Thanks for sharing your solution.
thomaswinter85
Posts
6
Registration date
Friday 14 October 2011
Status
Member
Last seen
13 December 2011
12 Dec 2011 à 04:51
12 Dec 2011 à 04:51
Thanks a lot
