I have an Excel worksheet that is downloaded from a server (Sheet2).
The number of rows vary each time the report is generated.
I have a summary worksheet (Sheet1) with formulae results. Not everyone uses 365 so am looking for a formulae to calculate the following on the uploaded worksheet :
1. Count the number of distinct values in Column A if Column B value is positive (>0)
2. Count the number of distinct values in Column A if Column B value is negative (<0) ((0 values are cleared by a macro))
3. Then subtract value in 2. from 1.
4. Because the number of rows vary need to be able to include additional rows in the formula so that should data populate those will also be counted.
The formulae should incorporate blank cells in rows 15 onwards.
The number of rows vary each time the report is generated.
I have a summary worksheet (Sheet1) with formulae results. Not everyone uses 365 so am looking for a formulae to calculate the following on the uploaded worksheet :
1. Count the number of distinct values in Column A if Column B value is positive (>0)
2. Count the number of distinct values in Column A if Column B value is negative (<0) ((0 values are cleared by a macro))
3. Then subtract value in 2. from 1.
4. Because the number of rows vary need to be able to include additional rows in the formula so that should data populate those will also be counted.
The formulae should incorporate blank cells in rows 15 onwards.