Hi shirlyn. Welcome to the forum.
This doesn't quite line up like the pic. It appears you are starting the formula above in G3 which seems unlikely, But try array entering this formula in F2, fill down and across.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
|
A |
B |
C |
D |
E |
F |
G |
H |
1 |
Date |
Criteria1 |
Criteria2 |
Criteria3 |
|
SW |
NE |
W |
2 |
10-Feb-18 |
|
|
|
|
|
11-Feb-18 |
11-Feb-18 |
3 |
11-Feb-18 |
|
NE TRUE |
W TRUE |
|
|
|
14-Feb-18 |
4 |
12-Feb-18 |
|
|
|
|
|
|
|
5 |
13-Feb-18 |
|
|
|
|
|
|
|
6 |
14-Feb-18 |
|
S TRUE |
W TRUE |
|
|
|
|
7 |
15-Feb-18 |
NW TRUE |
W TRUE |
|
|
|
|
|
8 |
16-Feb-18 |
|
|
|
|
|
|
|
9 |
17-Feb-18 |
|
|
|
|
|
|
|
If this isn't what you expect then please upload an Excel workbook showing the above.
If you are not familiar with how to do this:
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
- be sure to desensitize the data
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
The file name will appear at the bottom of your reply.
Bookmarks