Deepak
Excel Ninja
Hi all,
Hope, You are doing good!
Your lovable solution are welcomed in attached file where we need to count the unique records based on the following condition..
Note:
We can't manipulate data like as sorting etc, it would be as it is.
Each count should not be more then 100
Both Formula/VBA approach are valid.
Hope, You are doing good!
Your lovable solution are welcomed in attached file where we need to count the unique records based on the following condition..
- Each count should only be max 100.
- Either Each doc [col C] should be 100 or doc [col C] & FN&SN [col A&B] combination should be 100.
Note:
We can't manipulate data like as sorting etc, it would be as it is.
Each count should not be more then 100
Both Formula/VBA approach are valid.