How to use frequency function in a particular case

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lecossais - 13 Jun 2006 12:18 GMT

Hi,

I am a column of formated number cells, when i want to work out th
frequency this ranger, it is all wrong, apparently cos the cell numbe
are formated.

How can i sort this out? ang get right frequency without having t
unformat, 'round' function....

Thanks for your hel

Reply to this Message

Paul Lautman - 13 Jun 2006 13:16 GMT

> Hi,
>
> I am a column of formated number cells,

Wow, I've never met a column of formatted numbers that could actually post a
message to usenet!

> when i want to work out the
> frequency this ranger, it is all wrong, apparently cos the cell number
> are formated.

You say "apparently cos the cell number are formated." but you haven't given
us any information about this at all. It might be the case, but it is very
likely to be nothing to do with the formatting.

> How can i sort this out? ang get right frequency without having to
> unformat, 'round' function....

I have no idea, because you haven't actually said anything concrete about
the problem. You haven't given any examples of the actual data, of what you
actually see as a result and what you expect to see.

I guess this is because you are just a column of formated number cells.
Please see if there are any humans around and ask one of them to take a look
at you and maybe post some of your details here.

> Thanks for your help

Reply to this Message