I am trying to pull unique values from a table, based on a date criteria but not putting blanks in the results.
My table (Table_Std) has a number of columns, but the relevant ones here are B and C. B (Column1) is a course code which is want to pull out, and C (Start Date) is the course start date. The course code and the dates will be duplicated, hence the need for the 'unique'.
On the second sheet (Glynn Blank), there is a list of dates across the top (row 2) and I am wanting to get a list of the courses running each day. Using
returns the correct course codes but there are blank cells between the course codes which I need to get rid of as I just want them all in a single list.
If I then use
, where C23# is the range of the results from the first formula above, I get exactly what I need, but I cannot work out how to combine the formula's so I don't need to use an additional column for each one.
Can anyone tell me how I could combine the above two to use as a single formula (or another solution if that is better)
Hopefully that makes sense. Thanks in advance.
My table (Table_Std) has a number of columns, but the relevant ones here are B and C. B (Column1) is a course code which is want to pull out, and C (Start Date) is the course start date. The course code and the dates will be duplicated, hence the need for the 'unique'.
On the second sheet (Glynn Blank), there is a list of dates across the top (row 2) and I am wanting to get a list of the courses running each day. Using
Excel Formula:
=UNIQUE(IF('Glynn - Blank'!C2=Table_Std[Start Date],Table_Std[Column1],""))
If I then use
Excel Formula:
=UNIQUE(FILTER(C23#,C23#<>""))
Can anyone tell me how I could combine the above two to use as a single formula (or another solution if that is better)
Hopefully that makes sense. Thanks in advance.