Excel Question

[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?

[Shawnski]

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.

[SteveToms]

Originally Posted by Shawnski

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.

Thanks, I will give it a look later