Excel help

[Foofam77]

hello

 

i have a column of numbers in a excel sheet. .

 

i want to know the occurence of each of these numbers.

 

How should i go about using Excel formula to help me?

 

thanks...

[Iceklsy]

what is occurence ?

[Silver_z]

Use dcount() function

[KapitanE]

Use.... COUNTIF

[Altivo]

i think wat TS meant is that he has a set of numbers and he wants to know how many times these numbers appear.

[Silver_z]

Yea... CountIF is a better choice.

[Jayk]

You can use Countif function.

 

Eg. In the formula bar put .... = countif (A1:A5, rule) where rule is whatever condition you want to put.

 

It will count the number of times the range A1 to A5 fulfills the rule.

 

Hope this helps.

[Jayk]

Sorry about my message. know that its abit lag.

 

I was disconnect from the internet because I was traveling. When my post got through (when I was reconnected quite a long while later), I realized that you have already suggested Countit.

 

[Sigstore]

Hi.

 

Don't need so complicated. Can do without formulas.

Make sure your table has headers, then Just use pivot table.

 

Attached is file for ur reference.

 

 

 

hello

 

i have a column of numbers in a excel sheet. .

 

i want to know the occurence of each of these numbers.

 

How should i go about using Excel formula to help me?

 

thanks...

numbers.xls

numbers.xls

[Guyver]

Use.... COUNTIF

 

Wah!! I don't even know this function existed ....

[Cactus]

Hijack this thread,

I also need some Excel help!!

 

I have a column of data in excel... and I need to invert them, as in reverse their order.

Such that the Row 1 data will go to the last and vice versa.

 

Any function for this? thks!

[Coolbluewater]

here's what i'll do.

 

Copy the set of data, paste special(select value, transpose) at another location, arrange the data to what your requirement, then copy and transpose again.

[Cactus]

thks bro,

 

I hope I'm missing a point here, but transposing will only covert the column to row, the sequence still remains. I don't know how to invert the sequence ... hehe.

[Coolbluewater]

how about additing row numbers beside your data?

[Titanium]

just number ur rolls, eg: 1 ~ 100

 

Use the "auto-filter", then use "Sort Descending"

Edited April 14, 2008 by Titanium

[Yaloryalor]

i think wat TS meant is that he has a set of numbers and he wants to know how many times these numbers appear.

 

Maybe TS wanna check for some 4D numbers

[Cactus]

oh yah hor... how come I didnt think of that!

*smack forehead* thks dude