Page 4 of 4 FirstFirst ... 2 3 4
Results 31 to 33 of 33

Thread: Clearing Account formula ?

  1. #31
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,058
    Articles
    0
    Excel Version
    365


    Register for a FREE account, and/
    or Log in to avoid these ads!

    1. Which method are you trying? Quick and dirty, or the last file i attached? (It may not matter.)
    2. Can you put together some data so that I can see this happening here?

  2. #32
    Acolyte Coach Andrew's Avatar
    Join Date
    Jun 2021
    Location
    Ottawa
    Posts
    20
    Articles
    0
    Excel Version
    Excel 2016
    I'm trying to link to my excel file. Attached is the test data for Oct
    Attached Files Attached Files

  3. #33
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,058
    Articles
    0
    Excel Version
    365
    I downloaded your file and saved it. With the file I attached in msg#28, I updated cell A1 (with a double-click), then refreshed the table. No error, got the table as in attached (table left filtered for no blanks in Possibles column.
    …still investigating it here.
    Can you try again?
    Attached Files Attached Files

Page 4 of 4 FirstFirst ... 2 3 4

Posting Permissions

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