Modifying the SMALL function to not include zeros?

**thewrathful** · 12-09-2009, 03:30 PM

Hello, i'm having a bit of trouble. I have a list of numbers and any that start with zeroes eg. 00221 come up with 221. After using the SMALL function to put these in order, i use the COUNTIF function to calculate how many times these numbers have come up in another bit of a spreadsheet. However, it always comes up with '0' as if it's not picking up the numbers.

The numbers in the small column are like 00221 but the other column is 221. Can i change the SMALL function to make it the same?

Thanks a lot!

**Ron Coderre** · 12-09-2009, 03:48 PM

A few more details would be helpful.
Can you post a list of sample numbers, the formulas you've tried (even if they don't work), and the resulting list you'd like to see?

**thewrathful** · 12-09-2009, 03:52 PM

Sure thing-just a moment.....

**thewrathful** · 12-09-2009, 04:08 PM

Here you go

**teylyn** · 12-09-2009, 04:46 PM

Hi,

what exactly are you seeing? I opened your sheet and the countif() in column R returns the correct results

Please Login or Register  to view this content.

so I don't really see what the problem is ...

Modifying the SMALL function to not include zeros?

LinkBack

Thread Tools

Rate This Thread

Display

Modifying the SMALL function to not include zeros?

Re: Modifying the SMALL function to not include zeros?

Re: Modifying the SMALL function to not include zeros?

Re: Modifying the SMALL function to not include zeros?

Re: Modifying the SMALL function to not include zeros?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions