Excel

Paul24

This is just something I come across recently and thought it may prove useful to some of us.

http://www.cimaglobal.com/cps/rde/xchg/live/root.xsl/Insight056234_6332.htm

Paul

A-Vic

Paul24 wrote: »

This is just something I come across recently and thought it may prove useful to some of us.

http://www.cimaglobal.com/cps/rde/xchg/live/root.xsl/Insight056234_6332.htm

Paul

Hi Paul

Not sure why but the link isn't opening

Paul24

Just tested it and its fine here....

CJC

Neat little technique but I'm not sure with the example that in practice that you wouldn't do this 'by eye' unless you had a humungous amount of balances to check. And in that case I'd probably want to return an array of all errors not just the first.

Paul24

Useful with a balance sheet with hundreds of codes on though like we have here, also when there a a lot of people posting into prior months without telling you. Useful with my previous job when doing cost reports on construction contracts, a lot of issues balancing retention entries when values were posted into prior periods, and by singleing out the first period in error, it quite often cleared up all more recent periods.

A-Vic

Paul24 wrote: »

Just tested it and its fine here....

Sorry was my end, managed to open thanks

mark130273

A-Vic wrote: »

Sorry was my end, managed to open thanks

well done a-vic........brains as well as beauty ?