G
GerryK
Hi,
I am getting a 0 (zero) at the end of a column in my
Summary sheet set up to list unique values from my
Forestry Export sheet (same workbook). I understand that
#N/A should be the last value returned when unique runs
out.
What is the 0 and why is it there?
This same formula does not return a 0 if all the data is
on one sheet.
TIA for any help.
I have this formula in I9 of the Summary sheet.
=INDEX('Forestry Export'!$B$3:$B$9999,MATCH(0,COUNTIF
(Summary!$I$8:$I8,'Forestry Export'!$B$3:$B$9999),0))
I am getting a 0 (zero) at the end of a column in my
Summary sheet set up to list unique values from my
Forestry Export sheet (same workbook). I understand that
#N/A should be the last value returned when unique runs
out.
What is the 0 and why is it there?
This same formula does not return a 0 if all the data is
on one sheet.
TIA for any help.
I have this formula in I9 of the Summary sheet.
=INDEX('Forestry Export'!$B$3:$B$9999,MATCH(0,COUNTIF
(Summary!$I$8:$I8,'Forestry Export'!$B$3:$B$9999),0))