look up

N

Neil Greenough

I had a job interview today and was given a spreadsheet (both on a laptop
and in written form).

I had to analyse the information, detailing the most common occurences, ie
best seller etc...

If i have a column of different products, is there a way I can list them in
order of the one with the most entries, ie the one which appears the most in
the column.

Also what is the formula to work out how many times something appears? So
for example, I want to find out how many times the word 'banana' appears in
a range in a column.
 
J

JulieD

Hi Neil

not sure about your first question but as to the second ..

to find out how many bananas there are in column A you can use the COUNTIF
function
=COUNTIF(A:A,"banana")

Cheers
JulieD
 
L

Lady Layla

Hi Neil

Sounds like you need some Excel training. Think about what you are trying to
do and what the common term for it is, ie how many times something appears ---
what would you do if you had a pile of apples and oranges and needed to find out
how many there are of each? In Excel -- go to help and type that word in and
see what comes up.

Read up on functions etc




: I had a job interview today and was given a spreadsheet (both on a laptop
: and in written form).
:
: I had to analyse the information, detailing the most common occurences, ie
: best seller etc...
:
: If i have a column of different products, is there a way I can list them in
: order of the one with the most entries, ie the one which appears the most in
: the column.
:
: Also what is the formula to work out how many times something appears? So
: for example, I want to find out how many times the word 'banana' appears in
: a range in a column.
:
:
 
F

Frank Kabel

Hi
for the first question a simple solution could be to use a pivot table
and sort according to the 'count' of entries
 
N

Neil Greenough

I tried the Count one and stuff but couldnt get it to work.

So wound up as I could use Excel a few months ago but im using Access at the
moment and so have kinda forgot about Excel.

Damn!
 
Top