Bizarre, I posted this earlier and it didn't appear.
Here goes again. I'm trying to do something in Excel and the help pages don't tell me what I want. I have a column of salaries and I want to order them £1 to £24,999, £25,000 to £34,999, £35,000 to £45,000 etc right up to £100k +
Say I have 500 salaries, I want to know how many fit in each category. How do I go about doing this?
Any Excel expert able to help?
Here goes again. I'm trying to do something in Excel and the help pages don't tell me what I want. I have a column of salaries and I want to order them £1 to £24,999, £25,000 to £34,999, £35,000 to £45,000 etc right up to £100k +
Say I have 500 salaries, I want to know how many fit in each category. How do I go about doing this?
Any Excel expert able to help?