Compiling a list based on criteria

chrisb86

New member
Joined
Jan 23, 2017
Messages
2
Reaction score
0
Points
0
I have a large data entry sheet that I am looking to break down into a separate sheet if criteria are met.

I am looking to compile a list that includes:

Unique ID ('Data Entry'!A6:A5006)
Surname ('Data Entry'!B6:B5006)
Forename ('Data Entry'!C6:C5006)
Projection phase completion ('Data Entry'!CL6:CL5006)

ONLY IF

Attended ('Data Entry'!AG6) = 1

I can get the list to display using an if function however this would leave gaps between the list whereby criteria was not met.

Have tried to read some threads regarding this but cannot for the life of me follow what is going on!

Any help on this would be greatly appreciated.
 
Hi and welcome
if it's a one shot operation you could filter the necessary values out
 
This actually makes perfect sense, so simple!

No idea why I didn't just think of that in the first point!
 
Back
Top