Unique count of number of instances

Please try this file.

I have listed the unique vales of indent # & unique count.

If this not the correct result, please let me know.

hi arnab0711. looking at your previous posts, you seem to be using Excel 2007. could you update that in your profile under the MS Off Ver. it helps us decide which method to share. if your records are indeed only hundreds of rows, try this formula in column AL2:
=--(COUNTIF(E$2:E2,E2)=1)

copy down & add this to your pivot's Value. Sum it

if your records are over 10 or 100 of thousands, you may find that the formula slows down or even unable to have available resources to do it. then try this method i shared in Microsoft Answers:

1. open a new workbook. go to Data -> From Other Sources -> From Microsoft Query. I unchecked the "Use the Query Wizard to create/edit queries". i think it's down to preferences. Choose Excel Files & click OK

2. Find the file Copy of IDEA_Pending_Indent___Buyer_Wi_081113-ALL.xls & click OK.

3. Click on IDEA_Pending_Indent___Buyer_Wi_$ & press Add. Click Close

4. Double-click Buyer Name & Indent # & it'll go down to the data below

5. go to View -> Query Properties -> Unique Values Only. Click Ok.

6. go to File -> Return Data to Microsoft Excel

7. Click on Pivot Table Report & OK

8. drag Buyer Name to Row Labels & Indent to Values. Make it Count of Indent #

Please use this function to count the unique value of indent # column.

Add a sheet & paste this function in any cell.
(Ctrl+shift+enter is required)
=SUM(IF(FREQUENCY(IF(Data!$E$2:$E$271<>"",MATCH(Data!$E$2:$E$271,Data!$E$2:$E$271,0)),ROW(Data!$E$2:$E$271)-ROW(Data!$E$2)+1),1))

or if you want the unique values, then you can try this (Ctrl+shift+enter is required)
Copy in a new sheet in cell A2 & drag down
=IFERROR(INDEX(Data!$E$2:$E$271,MATCH(0,COUNTIF($A$1:A1,Data!$E$2:$E$271),0)),"")

Rgds,