Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    England
    Posts
    26

    Unanswered: array formulas question

    Hello everyone,

    Does anyone know if this is possible?

    I have got a large list of different transactions, I have summarised them by using array formulas, grouped into transaction type, payment method etc. showing total of transaction amount.

    Is it possible to then highlight which rows have been included in the formula to make up the total amount.

    This would be invaluable in working the formulas back to check that every row has been included.

    Thanks,
    Beth
    Beth

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    You might want to consider the add-in that Aaron Blood developed for auditing - it looks quite complete and would probably give you what you need.

    http://www.xl-logic.com/pages/explode.html
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •