'To get an condition for excel mentioned in the attachment
Please follow the attachment and let me know how can i get true, false and NA condition for the excel sheet
Column A --> It has repeated set of ID's (A,B,C) Column B --> Data 1 to be compared with Data 2. And if the data2 is anywhere present in Data 1 and both share the same data from column ReportID, I should get true...otherwise false...and if data2 is blank then NA
Solution 1:[1]
Just use COUNTIFS:
Formula in column D:
=IF(C2="";"NA";COUNTIFS($A$2:$A$11;A2;$B$2:$B$11;C2)>0)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Foxfire And Burns And Burns |