Mar 20 2023 10:42 AM
Hey guys,
I´m trying to create my own online logbook but I have a problem.
I want to calculate how many different helicopter I flew.
For example:
AAWWE
AAWWE
BBEEZ
BBEEZ
134
Would make a total of 3 Helicopter. How can I do that?
Unfortunately they are not in order like this above.
Mar 20 2023 10:50 AM
=COUNTIF($A$1:A1,A1)
=COUNTIF(B1:B7,1)
Maybe with these formulas in cells B1 (filled down to B7 in the example) and C1.
Mar 20 2023 11:27 AM
Mar 20 2023 11:36 AM