Conditional Statements to Reduce Column numbers

This formula would be entered into cell F14 of your sample sheet. You then have to hit Control+Shift+Enter, not just enter to confirm the formula. You can then copy it down.
If you enter it with Control+Shift+Enter you will see {}on each end of the formula. This is done by Excel, do not attempt to enter these manually. If they are not there, then put your cursor in the formula hit the F2 key and try it again.
Good Luck!!!

Formula:

Please Login or Register  to view this content.

Hi Jane (is this your real name?? )

Because you have Excel 2013 you have this great tool that may do what you need. It is called Table Slicers. You could click on Gulls and/or Raptor and only see them...
Watch a video at: http://www.bluepecantraining.com/por...ual-dashboard/ and give it a try.

Or http://blogs.office.com/2012/10/24/b...ers-on-tables/ for another page that shows it.

If Slicers don't do it for you, I'm thinking you might need some Column Type Slicer tool. Report back after looking at Slicers and let us know.