Hello there,
so i have a couple questions about indexing data from a table ive created, and wanted to know how i can have it output all the different data, but not output zero's for blank cells or #N/A for blank cells
Here is the formula im using
=INDEX(ProbeList[Mag 1],MATCH(0,COUNTIF($A$4:A4,ProbeList[Mag 1]),0))
where ProbeList[Mag 1] is a column of my table
this formula works great, but i have to fill down until it outputs all the different data which is fine, but is there a way to just have it fill down until all the different data is output?
and this formula also outputs a zero once in awhile, and #N/A as well which im assuming is due to blank cells in the column of my table? so how could i get rid of this so that it only outputs data in the table?
so i have a couple questions about indexing data from a table ive created, and wanted to know how i can have it output all the different data, but not output zero's for blank cells or #N/A for blank cells
Here is the formula im using
=INDEX(ProbeList[Mag 1],MATCH(0,COUNTIF($A$4:A4,ProbeList[Mag 1]),0))
where ProbeList[Mag 1] is a column of my table
this formula works great, but i have to fill down until it outputs all the different data which is fine, but is there a way to just have it fill down until all the different data is output?
and this formula also outputs a zero once in awhile, and #N/A as well which im assuming is due to blank cells in the column of my table? so how could i get rid of this so that it only outputs data in the table?
