Duplicate values in multiple columns
Solved/Closed
M3TM3T
Posts
2
Registration date
Saturday November 5, 2016
Status
Member
Last seen
November 5, 2016
-
Nov 5, 2016 at 12:23 PM
M3TM3T Posts 2 Registration date Saturday November 5, 2016 Status Member Last seen November 5, 2016 - Nov 5, 2016 at 01:25 PM
M3TM3T Posts 2 Registration date Saturday November 5, 2016 Status Member Last seen November 5, 2016 - Nov 5, 2016 at 01:25 PM
Related:
- Duplicate values in multiple columns
- Outlook duplicate items remover (odir) - Download - Email
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- How to make multiple selections in photoshop - Guide
- Based on the values in cells b77 ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 5, 2016 at 12:34 PM
Nov 5, 2016 at 12:34 PM
M3TM3T, Good afternoon.
Try to use:
D2 --> =INDEX($A$2:$A$7, MATCH(C2, $B$2:$B$7, 0))
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
D2 --> =INDEX($A$2:$A$7, MATCH(C2, $B$2:$B$7, 0))
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Nov 5, 2016 at 01:25 PM
You are my hero. thanks a lot.
It works like a charm.