Distinct count unique value

[tpracsg]

Hi Friends
I need a help for finding Distinct count unique value as follows :

Product Month Salesman Merge A&B&C DistinctCount
Apple Apr Alexandar AppleAprAlexandar 1
Apple May Alexandar AppleMayAlexandar 1
Apple Apr Alexandar AppleAprAlexandar 0
Apple Apr Mathew AppleAprMathew 1
Orange May Mathew OrangeMayMathew 1
Apple Apr Mathew AppleAprMathew 0

I need to merge (merging not compulsorily) but output in DistinctCount column as same required. (i.e. First value 1 and if duplicate 0)
PLEASE NOTE MY EXCEL FILE IS VERY BIG APPROXIMATE 100000 ROWS. Hence I need output result very quickly.
How to solve my problem.
Thanks in advance
CSGanesh

 

[Roderick_E]

Supposing this is columns A-E, in E you would
=IF(COUNTIFS($D$2:$D2,D2)>1,0,COUNTIFS($D$2:$D2,D2))

This will place a zero in any duplicates

 

[tpracsg]

Hi
Thank you for your immediate help. But please note my excel file is very big (i.e, appr. 1,00,000 rows). Hence for copy and paste the above take more than 20 minutes (some times excel file hanged). Actually I need this for pivot tables. If it is possible to apply this in pivot table in calculate field. i need a fast output. or any vba for fast result. Please help me.
Regards
CSGanesh