Hi,
I am trying to filter out multiple data to collate some information, now I am ok in doing countifs for a single column but how do I do if for multiple columns ? any one in simple terms please
Example Column 1 has multiple names eg place of accident ( I am ok at counting them) Colum 2 has multiple type of injury - what formula do I use to collate the multiple information from one big spreadsheet ?
Thanks in advance
Spreadsheet Data
Moderator: Moderators
- Keith1983
- Suitable and Sufficient since 1983
- Posts: 8330
- Joined: Mon Dec 08, 2008 3:08 pm
- 15
- Industry Sector: Engineering/Manufacturing/ Construction
- Occupation: H&S Coordinator
- Location: Lincolnshire / South Yorkshire
- Has thanked: 34 times
- Been thanked: 24 times
Re: Spreadsheet Data
Sounds to me like you need a pivot table!
So when the whole world is safe..............what are we going to do then?
- grim72
- Anorak Extraordinaire
- Posts: 689
- Joined: Fri Aug 20, 2010 3:53 pm
- 13
- Twitter: goodtogosafety
- Industry Sector: Safety inspection systems
- Location: UK
- Has thanked: 4 times
- Been thanked: 81 times
- Contact:
Re: Spreadsheet Data
Yup pivot tables are good for this type of stuff. Whenever I've been stuck with spreadsheet maniopulation I post my query on http://www.excelforum.com/" onclick="window.open(this.href);return false; and someone has always managed to provide me with a solution - usually within the hour. Certainly worth a try from my experience.
Grim72
Good to Go Safety - Providing you with a safer workplace
Before you criticize someone, you should walk a mile in his shoes. That way, when you criticize him, you're a mile away and you have his shoes
Good to Go Safety - Providing you with a safer workplace
Before you criticize someone, you should walk a mile in his shoes. That way, when you criticize him, you're a mile away and you have his shoes