Create dynamic list based on blank cells

Hi Folks,

I run a training oversight workbook and I'm trying to dynamically create a list of users who need to be enrolled in training.

Using data from the "Data Source" worksheet, I'm trying to dynamically create a list on different worksheet based on whether or not the cells in column O or Q is blank.

If one or other (or both) of the cells in columns O and Q are blank, then I want to be able to pull certain values across to the 'desired output' tab (without any blank rows).

• Columns A - M of the "Data Source" tab (Headers marked in Red) MUST be maintained in the order they're in
• I have no issues with having a 'helper' column in column Z of the "Data Source" Tab.

I've tried working it with Index and Aggregate and while I feel I've been close it just doesn't quite work for me.

Any help, as always, will be very much appreciated.

Any questions, queries or clarity needed, drop me a line

MM

Hi Team

Firstly, I was able to use the basis of etaf's initial solution to work out a good solution. Basically, I used the "Filter" just in column A and then, as the employee number is unique, I used Index and Match for the remainder of the data.

@Glenn. A couple of weeks ago my work laptop was refreshed, and I lost several functions and capabilities (more than a little bit annoying ) So I couldn't implement your solution. Also, you asked where the data for columns H - M were. The data in those cells is generated by the content in the location, Secondary filter and the final column (which is the individual's grade) Whatever is calculated in those columns determines wehre a "Y" entered in to columns J - N and then the values in H, (I) and J is calculated based on that.

All this enables me to export the A2:M? as a CSV for uploading in to the LMS.

Anyway, thanks again to all of you for all your help. I will mark this thread as solved.

MM

Originally Posted by etaf

sorry i had to leave after producing a partial solution, however looks like you have answers now , so i will leave to the other experts here

No problems, you pointed me in the right direction - Rep added