I have a column of data (
Y2:Y4993 with a heading in
Y1) in a worksheet showing various text entries.
Currently there are ten different items in the list, although the number may go up or down as the data changes from week to week - I have a dynamic named range to reference the column.
Using an array-formula I am returning a unique list of entries (formula is dragged down across 10 rows from
The named range
Gas_Reason_Column is defined as:
=INDEX('Audit Raw Data'!$Y:$Y,2):INDEX('Audit Raw Data'!$Y:$Y,COUNTA('Audit Raw Data'!$A:$A))
I'm looking to update the formula to ignore the 'Pass' entry as this is dealt with elsewhere on the sheet and would make the chart I'm planning on building from the data hard to read due to the large disparity between the Pass count and all the other counts.
I just can't figure out where to add a
<>"Pass" check in the formula.
NB: The raw data sheet will be cleared and new data copy/pasted in every week, so I would definitely prefer a solution that doesn't add require any changes to that sheet.