Hi All,
I am currently working on a spreadsheet which summarises a table of data.
The user needs to be able to select from three options to narrow down the results returned one of which is a reference number. The problem i am having is that the user needs to be able to select either a specific reference number or leave the cell blank so that all reference numbers are counted.
I have created a dymanic list using the following formula
=OFFSET('Raw Data'!$G$2,0,0,COUNT('Raw Data'!$G:$G),1)
This provides a drop down list of all the reference numbers used in the source data, but im completely stuck with how to amend this so that the user can have it include all references.
Does anybody know if this is possible?
I am currently working on a spreadsheet which summarises a table of data.
The user needs to be able to select from three options to narrow down the results returned one of which is a reference number. The problem i am having is that the user needs to be able to select either a specific reference number or leave the cell blank so that all reference numbers are counted.
I have created a dymanic list using the following formula
=OFFSET('Raw Data'!$G$2,0,0,COUNT('Raw Data'!$G:$G),1)
This provides a drop down list of all the reference numbers used in the source data, but im completely stuck with how to amend this so that the user can have it include all references.
Does anybody know if this is possible?
