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.
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.