Excel Formula (2003)

Topic

New Reply

Hi,

I have a very complex worksheet with the a variation of formula’s that are used thousands of times over.

Would it be possible to simplify the following three formulas into one?

In Q104 =IF(P104=””,””,COUNTIF(X_DR_1,P104)) – How many debits do I have identical to P104
In R104 =IF(P104=””,””,COUNTIF(X_CR_1,P104)) – How many credits do I have identical to P104
In S104 =IF(P104=””,””,IF(R104/Q104=1,”MATCH”,”NO MATCH”)) – Do I have the same number of debits and credits

Any suggestions greatfully received!!

Thanks

Nath

Reply | Quote

Replies

Assuming you’re only interested in whether they match:
=IF(P104=””,””,IF(COUNTIF(X_CR_1,P104)=COUNTIF(X_DR_1,P104),”MATCH”,”NO MATCH”))
should do it.

Reply | Quote

Hans, I cannot thank you enough!!! That should speed the worksheet up a lot!!!

Many Thanks
Nath

P.S, nearly brakfast time, diamond shreddies here I come…..

Reply | Quote

Er, it was Rory who answered your question!

Reply | Quote

LOL, sorry, am in sleep mode!!

Cheers Rory!!!!

Reply | Quote

Glad to help.
Regards,
Hans. Er, no wait, Rory.

Reply | Quote