LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Count but in Diffrent way

Hi ! Experts

My data look like this:
Name
Hardeep
Hardeep
pai
pai
renu
aditya
john
john
john
john
gorden
gorden

And i want to get the count of each name in next Column like mentioned below
Example

Name Count
Hardeep 2
Hardeep 2
pai 2
pai 2
renu 1
aditya 1
john 4
john 4
john 4
john 4
gorden 2
gorden 2



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you do labels with diffrent recipients? jessy18 Excel Discussion (Misc queries) 2 February 6th 09 02:58 PM
TOO MANY DIFFRENT CELL FORMATS Raz Excel Discussion (Misc queries) 0 January 9th 09 09:42 AM
TOO MANY DIFFRENT CELL FORMAT Raz Excel Discussion (Misc queries) 2 January 8th 09 08:39 AM
I want to seperate two words in same cell to be in two diffrent ce oasalako1 Excel Discussion (Misc queries) 2 September 22nd 08 05:15 PM
how can i format a cell with 3 diffrent group to add JMGRC Charts and Charting in Excel 0 October 26th 06 10:49 AM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"