I have a column of data on a table that consists of 3-digit numbers.
I need to strip the third digit and count the unique instances of the remaining two digit numbers in the column.
So on another sheet in A1 I have the following:
And that spills an array of the results I need to count.
Then B and C I put the following:
Which returns exactly the totals I need.
So I return to my first sheet and put in:
It works fine, but when I go to the adjacent column and try to type the following:
...I get the Excel stop warning of "There's a problem with this formula."
What gives?
I need to strip the third digit and count the unique instances of the remaining two digit numbers in the column.
So on another sheet in A1 I have the following:
Excel Formula:
=(LEFT(range,2)
And that spills an array of the results I need to count.
Then B and C I put the following:
Excel Formula:
=UNIQUE(A1#)
=COUNTIF(A1#,UNIQUE(A1#))
So I return to my first sheet and put in:
Excel Formula:
=UNIQUE(LEFT(range,2))
Excel Formula:
=COUNTIF((LEFT(range,2),UNIQUE(LEFT(range,2)))
What gives?