Excel

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

Comments

  • A-Vic
    A-Vic Registered Posts: 6,970
    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
    Paul24 Registered Posts: 578
    Just tested it and its fine here....
  • CJC
    CJC Registered Posts: 1,657
    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
    Paul24 Registered Posts: 578
    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
    A-Vic Registered Posts: 6,970
    Paul24 wrote: »
    Just tested it and its fine here....

    Sorry was my end, managed to open thanks
  • mark130273
    mark130273 Registered Posts: 4,234
    A-Vic wrote: »
    Sorry was my end, managed to open thanks

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