Formula to skip collumns with blank data

[James bolton]

Hi,

I have uploaded a file as an example.

In the data workbook - I want to be able to select the year, and then show all the data that is in that year in a table underneath, however, if 1 of the events have no data in the "turnout" column, that it should skip that entry

I've highlighted in purple how the table would ideally look when you change to that year

It is essential for this to work that this is a dynamic table that changes when you select a new year from the list.

 

[Chihiro]

See attached.

 

[Khalid NGO]

Hi James,

Or this (similar to Chihiro's)

for Event {array formula} :
=IFERROR(SMALL(IF((DATA!$A$2:$A$31=$C$3)*(DATA!$C$2:$C$31<>""), DATA!$B$2:$B$31),ROW(A1)),"")

for Turnout (regular formula)
=SUMIFS(DATA!$C$2:$C$31,DATA!$A$2:$A$31,$C$3,DATA!$B$2:$B$31,A5)

Use custom format for zeros:
0;-0;

Regards,

 

[James bolton]

Thankyou both - theyre great