simplifying a very long formula!

I'm trying to simplify a formula. I don't mind the way it currently is, it's easy to see what's happening and to amend if necessary, but it just takes forever to edit or amend (despite having a good Mac, I'm forever seeing the spinning beach ball!).

I think because of it's length, it's soooo slow to edit. There's at least 15 groups of formula (below is just a snap shot of 3):

I'd appreciate any ideas to either make it easier to edit or to simplify, thanks.

Ric

macOS Sierra (10.12.4)

Posted on Jul 1, 2017 5:39 AM

17 replies

ric frankland Author

Level 2

380 points

Jul 13, 2017 2:20 AM in response to SGIII

Hi SG

Are you still able to help me please with the MATCH function or is it impossible to exclude some figures in the column that is being MATCH-ed?

I also don't understand why the OR function isn't working...?!

(The file is still in Dropbox)

Cheers

Ric

Yellowbox

Level 7

22,333 points

Jul 2, 2017 4:52 AM in response to Yellowbox

is it possible to upload this file??

Upload to Dropbox or a similar site and paste the link here.

Ian.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

simplifying a very long formula!