Quote:
Originally Posted by SteveToms
Hey, I got a excel question for you guys.
I have a excel spreadsheet that is a logbook of my online flights in FSX, and I am wondering if there is a way to count the number of times some things are entered.
So I want to know how many times LSZH appears in the 2nd/3rd column, and how many times LX**** appears. Is that possible? |
In the help menu, check the "countif" function. It will do what you want.
Alternatively you could make a pivot table from any column.
And if you need anything starting with just LX, not unique LX****, create a column using the "left" function, taking just two characters. You can then use either the countif, or pivot table methods on the new column.