Workaround for UPPER(F31:F10000)

P

Pantryman

Bob and Harlan,

the Sun support forum seems to be on election break...
I have decided to give this a rest since the sheet works for now.
The problem remains that I can't add my aircraft types up unless the
are all listed in the same case.
That really is too bad, since I want to make this spreadsheet accesibl
to anyone.
And I can't assume people will list their flights in upper/lower onl
case.
The Calc Autocorrect may be turned on too for some users, so there ma
even be 'proper' cases..

Makes you wonder huh..?

I tried the SUM(IF(..... solution but that doesn't work as yo
indicated.
If you have any ideas then please keep me informed.

Greetings from Holland
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top