Hi all,
Interested in who can solve this problem. I have multiple tests (about 2000) in column A, many of which are duplicated 2, 3 or 4 times but some are not duplicated. I'm trying to write a formula that will look at the tests that match and then combine the rows so that if 'Yes' is present in any of the Result columns then a 'Yes' is returned in a single line.
For example, duplicate tests that I need to know if there is a Yes present in any relevant row for the same test:
Current state
A B C D E Test name Result Result Result Result Test 1 Yes No No Yes Test 1 No Yes No Yes Test 1 Yes No No Yes Test 2 No No Yes No Test 2 Yes No No No Test 3 Yes Yes No No
Desired state
Now the tests have been combined and if there is a Yes in any column then a Yes is returned in the combined test row:
A B C D E Test name Result Result Result Result Test 1 Yes Yes No Yes Test 2 Yes No Yes No Test 3 Yes Yes No No
Bookmarks