View Full Version : Compiling a list based on criteria

2017-01-23, 04:07 PM
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)


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.

2017-01-23, 04:11 PM
Hi and welcome
if it's a one shot operation you could filter the necessary values out

2017-01-23, 04:15 PM
This actually makes perfect sense, so simple!

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