richjohnson311
New Member
- Joined
- Dec 5, 2013
- Messages
- 3
I need help with a formula that will list all of the unit #'s in a column based upon the results of 2 different columns. The range for this is approx. 200 rows. Example:
A B C
Unit # Inspection Date
100 Pass 4/12/14
101 Pass 4/20/14
102 Fail 4/23/14
103 Pass 4/21/14
The formula would look at columns B & C and if it said "Pass" and the Date was within the last week, it would list the Unit # (for all 200 applicable rows). So the result would be in this format: 101, 103, etc.
Thanks so much for your help!
A B C
Unit # Inspection Date
100 Pass 4/12/14
101 Pass 4/20/14
102 Fail 4/23/14
103 Pass 4/21/14
The formula would look at columns B & C and if it said "Pass" and the Date was within the last week, it would list the Unit # (for all 200 applicable rows). So the result would be in this format: 101, 103, etc.
Thanks so much for your help!