How to count cell with value

**Musthafa1977** · 04-18-2011, 09:27 AM

HI-11 HI-07 HI-11 HI-07
HI-11 HI-07 HI-11 HI-07
HI-63 HI-67 HI-63 HI-67
HI-11 HI-07 HI-11 HI-07
HI-68/70 HI-67/74 HI-68/70 HI-67/74

Dear Experts,

Please try to give me your valuable comments....

How to count the each unique value without doing manually. I tried with countif... But I coudn't find the solution.

I need final result like the below example

HI-11 ?
HI-68/70 ?
HI-07 ?

Thanks for your valuable suggestion.

Regards

**zbor** · 04-18-2011, 09:31 AM

COUNTIF sounds nice.

**prajakt** · 04-18-2011, 09:35 AM

Originally Posted by zbor

countif sounds nice.

good dude

**Musthafa1977** · 04-18-2011, 09:50 AM

Dear Zbor,

Thanks a lot for your immediate response.... But Still I didn't get solution....

Each Unique value should count and result need automatically in another place