Counting repetition of item number

Hi all,

I am trying to count the number of occurrences of items. Unfortunately, because of the way the data is set up, the item number does not actually repeat, instead there's a blank row below, instead of the duplicate. How can I nevertheless count the repetition of such item? See sample file for clarification.

Maybe I misunderstand something...I don't see any duplicates in the list you provided.

OK, I get it now. The blank lines are the repeat.

Sorry, perhaps I wasn't clear enough. Every blank below an item serves as a 'duplicate'. This is just how it was initially set up in a pivot.

Or try in G3:

=IF(H3="","",MATCH("*",$H4:$H$45,0))

Perfect! Both solutions work! Thanks!!

If the data was already in a pivot table then the count can be obtained directly from the pivot.