If data matches in one column, check 2nd column matches
Solved/Closed
vickylouise
Posts
2
Registration date
Monday 7 October 2013
Status
Member
Last seen
7 October 2013
-
7 Oct 2013 à 05:43
vickylouise Posts 2 Registration date Monday 7 October 2013 Status Member Last seen 7 October 2013 - 7 Oct 2013 à 10:35
vickylouise Posts 2 Registration date Monday 7 October 2013 Status Member Last seen 7 October 2013 - 7 Oct 2013 à 10:35
Related:
- If data matches in one column, check 2nd column matches
- Tmobile data check - Guide
- Excel column number - Guide
- How to delete a column in word - Guide
- How to copy data from one excel sheet to another - Guide
- Radiation check number - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
7 Oct 2013 à 09:58
7 Oct 2013 à 09:58
Vickylouise, Good morning.
I did an example for you.
https://www.cjoint.com/?CJhp3GgGAS0
I used only simple functions.
IF , COUNTIF , SUMPRODUCT
Please, take a look at it and tell us if it is what you desire.
I hope it helps.
Greetings from Brazil.
I did an example for you.
https://www.cjoint.com/?CJhp3GgGAS0
I used only simple functions.
IF , COUNTIF , SUMPRODUCT
Please, take a look at it and tell us if it is what you desire.
I hope it helps.
Greetings from Brazil.
vickylouise
Posts
2
Registration date
Monday 7 October 2013
Status
Member
Last seen
7 October 2013
7 Oct 2013 à 10:35
7 Oct 2013 à 10:35
Hi Mazzaropi
It worked!
Thank you very much, really appreciate your help :)
It worked!
Thank you very much, really appreciate your help :)