willay
Moderator
Organiser: South East, National Events
Premium Member
Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
|
I have a list of colours:
red
blue
black
white
etc.
Is it possible to use a formular in excel to work out how many of each I have?
essentially my spreadsheet has a liust of peoploe showing on the stand, each row has a number plate and a colour, I want to sum up the colours.
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
look at ollies thread about excel, can use =countif(range, "colour"). But you would need an if statement for each colour.
However, you could use a macro (visual basic) to go through each cell, detect what the colours are and then count them....would be a lot of ballache though 
|
|
