+ Reply to Thread
Results 1 to 2 of 2

formulas calling to wrong cells after query

  1. #1
    Registered User
    Join Date
    05-17-2007
    Posts
    45

    formulas calling to wrong cells after query

    Hi All;

    I have a worksheet that queries an external database and I have formulas that tie into that query - ex. the query brings back dates to column B:B, I want the week number in A:A so I type in IF(B2="","",WEEKNUM(B2,2)).

    What's happening is when I refresh the query the formulas are getting messed up - if cell A1 called out to B1 before the query its calling out to B47 after I refresh. Sometimes I get #REF errors. Is there a way I can have A1 always call out to B1, and all the way down? The query pulls close to 5000 values each time it refreshes, so I'm hoping I dont have to put $ signs on each cell in column A or if that would even solve the problem.

    Any help is greatly appriciated, thanks

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi minkus,

    You might try this formula instead in column A:
    Please Login or Register  to view this content.
    It assumes your data starts in row 1. If it starts in row 2, change the ROW() references to ROW()+1.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1