PDA

View Full Version : Compiling a list based on criteria



chrisb86
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)

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.

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

chrisb86
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!