Results 1 to 15 of 15

Counting Occurance of Particular Digit

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-11-2008
    Location
    Malaysia
    MS-Off Ver
    Office for Mac 2016
    Posts
    138

    Exclamation Counting Occurance of Particular Digit

    Hi everyone...

    I have a slight problem...I have a range of values..

    0113
    1240
    8430
    0903

    I need to count the occurance of a a particular no. from 0-9.. So i want to know how many times say 0 appears in that range of values etc so on till 9. I tried using CountIF but the problem i face is lets say in my cell 0903 there are 2 0s inside, it doesnt count this 2 zero.. I do not know why this is a problem..

    Anyone care to share some light on this issue..
    Last edited by newbie1234; 12-13-2008 at 07:11 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1