Check multiple cafeterias

Logit · #1 05-14-2020, 06:52 PM

So ... Sheet2 is the problem and Sheet1 is the corrected version ?

So long as the other cells in the row have the number 4 somewhere, it is ok ?

OCM · #2 05-15-2020, 04:14 AM

Logit, thanks.

No, it's the other way around. sheet1 is the source data, and sheet2 is what I expect to see. I produced sheet2 by manually: filtered out those individuals who have H0004 codes along with any other codes. So, my goal is to apply formula so that I get sheet2.

Simply put, H0004 code is not allowed with any other codes
1. an individual can have all H0004 codes
2. an individual can have any other codes, but NOT along with H0004 code

Hope this helps

TIA

Regards,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select multiple check boxes at once.	Batchook	Word	0	09-08-2016 03:44 PM
Excel vba to check to check if two columns are empty	subspace3	Excel Programming	5	07-09-2015 04:45 PM
Multiple Check In/check Out Times	big0	Excel	4	09-19-2013 05:02 AM
cannot check/uncheck check box but added check box	learn2office	Word	1	11-27-2012 02:02 AM
Link word check box to access check box	Mrkieth	Word	4	01-30-2012 06:43 AM