Hello.
I have sheets that have some numbers in C column. Then in J column there are some values that are in other sheet, the value depends from number in C column. Some are still have div/0. And i have several sheets that look like that.
Now i need to get number of unique distinct values that are in column C in all sheets. And i need to get number of those which already have number in J column.
So that i will have the number of all unique distinct values in C(all sheets) and how many of that distinct values already have values iN J.
Can somebody help me?
BR
I have sheets that have some numbers in C column. Then in J column there are some values that are in other sheet, the value depends from number in C column. Some are still have div/0. And i have several sheets that look like that.
Now i need to get number of unique distinct values that are in column C in all sheets. And i need to get number of those which already have number in J column.
So that i will have the number of all unique distinct values in C(all sheets) and how many of that distinct values already have values iN J.
Can somebody help me?
BR
