MarkCBB
Active Member
- Joined
- Apr 12, 2010
- Messages
- 497
Hi There,
Challange:
I am currently using the following formula to count unique items inside of a database (as a columns).
=IF(COUNTIF($D$2:D2,D2)=1,1,0)
This gives me either 1 or 0 in return, I use this column in other calculations to show a base .
However I need this formula to act like a Subtotal formula, so when the database is filtered the calculation updates.
The database is very big so I need a way to do this without an array.
Challange:
I am currently using the following formula to count unique items inside of a database (as a columns).
=IF(COUNTIF($D$2:D2,D2)=1,1,0)
This gives me either 1 or 0 in return, I use this column in other calculations to show a base .
However I need this formula to act like a Subtotal formula, so when the database is filtered the calculation updates.
The database is very big so I need a way to do this without an array.