Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default counting the number an item appears

I am trying to place a number next to an item for every time it appears, any
suggestions?

ex:
apple 1
orange 1
grape 1
apple 2
apple 3
orange 2
kiwi 1
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default counting the number an item appears

Assuming your data starts in cell A1, enter this formula in B1 and copy down
as needed:

=COUNTIF(A$1:A1,A1)

--
Biff
Microsoft Excel MVP


"klh84" wrote in message
...
I am trying to place a number next to an item for every time it appears,
any
suggestions?

ex:
apple 1
orange 1
grape 1
apple 2
apple 3
orange 2
kiwi 1



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default counting the number an item appears

In B1 enter 1
in B2 enter:
=COUNTIF(A$1:A2,A2) and copy down
--
Gary''s Student - gsnu201001


"klh84" wrote:

I am trying to place a number next to an item for every time it appears, any
suggestions?

ex:
apple 1
orange 1
grape 1
apple 2
apple 3
orange 2
kiwi 1

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default counting the number an item appears

Put this in B1:

=COUNTIF(A$1:A1,A1)

and copy down.

Hope this helps.

Pete

On Feb 25, 6:53*pm, klh84 wrote:
I am trying to place a number next to an item for every time it appears, any
suggestions?

ex:
apple * * 1
orange * 1
grape * * 1
apple * * 2
apple * * 3
orange * 2
kiwi * * * 1


Reply
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
Counting the times a number appears Jennifer B[_2_] Excel Discussion (Misc queries) 2 July 17th 08 11:54 PM
counting the number of times a word appears Adrienne[_2_] Excel Worksheet Functions 5 September 5th 07 02:49 AM
Counting the number of times a word appears 'anywhere' on a page Brother Laz New Users to Excel 1 June 17th 06 03:06 PM
Counting number of time a character appears in a string Henrik Excel Worksheet Functions 5 October 20th 05 11:00 PM
Counting the number of times a word appears in a worksheet Jig Bhakta Excel Worksheet Functions 4 February 3rd 05 04:01 AM


All times are GMT +1. The time now is 10:23 PM.

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

About Us

"It's about Microsoft Excel"