How to look up a value within only a subset of another column?
Closed
Rachel
-
Sep 1, 2017 at 02:12 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 1, 2017 at 10:27 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 1, 2017 at 10:27 AM
Related:
- How to look up a value within only a subset of another column?
- Display two columns in data validation list but return only one - Guide
- How to delete column in word - Guide
- Tweetdeck remove column - Guide
- Excel copy column from one sheet to another automatically - Guide
- Excel count occurrences of string in column - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 1, 2017 at 10:27 AM
Sep 1, 2017 at 10:27 AM
Rachel, Good morning.
Suppose yoUr data at A1:C5
Try do use:
D1 --> =IF(COUNTIFS($A$1:$A$5,A1,$B$1:$B$5,C1)=0,"No","Yes")
Copy it down.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose yoUr data at A1:C5
Try do use:
D1 --> =IF(COUNTIFS($A$1:$A$5,A1,$B$1:$B$5,C1)=0,"No","Yes")
Copy it down.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
