Comparing three columns and giving back specified values
Closed
sepideh.ha
Posts
1
Registration date
Monday July 28, 2014
Status
Member
Last seen
July 28, 2014
-
Jul 28, 2014 at 11:00 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 29, 2014 at 11:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 29, 2014 at 11:57 AM
I want search for strings I have in source(A) in both source(B) and source(C) and when it finds those documents give them the three revisions I have from different sources. I mean each string(cell) I will have with three revision, one for itself and two revisions from source B&C.
Related:
- Comparing three columns and giving back specified values
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- How to delete rows and columns in word - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Excel Macro/Code help: Creating sheet for each name in column of another sheet ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 29, 2014 at 11:57 AM
Jul 29, 2014 at 11:57 AM
Hi Sepideh.ha,
Next time posting a pic change 325px in 500px at the end of the picture code line, so that is actually readable (I don't blame you for not knowing).
Your query is rather vague. I get that you want to compare column A to E and H (I believe those are the column letter from the pic).
So if A=E and A=H then ... And there you lost me. Which data you want to put where is not clear to me.
Best regards,
Trowa
Next time posting a pic change 325px in 500px at the end of the picture code line, so that is actually readable (I don't blame you for not knowing).
Your query is rather vague. I get that you want to compare column A to E and H (I believe those are the column letter from the pic).
So if A=E and A=H then ... And there you lost me. Which data you want to put where is not clear to me.
Best regards,
Trowa
