+ Reply to Thread
Results 1 to 5 of 5

Wierd Formula hidden somewhere in data base

  1. #1
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    494

    Wierd Formula hidden somewhere in data base

    I have large database ( 190,000 rows of data and 7 columns). During one of my analysis, I deleted all data from 12/18/2015 throu 12/31/2015. Which left a data base of all months and all dates up to 12/17/2015.

    After I finished what I was doing, I closed the database. When I reopened it, all dates are there, which I expected to see. But when I run a query using a different file and input all the data with all the dates, it picks up all data from 1/1/2015 to 12/17/2015?

    I do not see any thing to account for this in the data fields of either the original database or the query field from another file. But something is stuck with data above 12/17/2015.

    Can someone give me some ideas of where to look or what to do. I have already copied the original database into a new file and saved it. But it persists. Therefore somehow I must have used the query file to delete all dates past 12/17/2015. But I don't see anything in the query file that could account for this. So, I am looking for help. Thanks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Wierd Formula hidden somewhere in data base

    Will you please attach a sample Excel workbook?

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    494

    Re: Wierd Formula hidden somewhere in data base

    found the problem

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Wierd Formula hidden somewhere in data base

    For the benefit of others, what was it?

  5. #5
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    494

    Re: Wierd Formula hidden somewhere in data base

    Two things. I had copied and pasted some data into my analysis program, by using "Insert Function" . This removed some of my "IF= etc" formulas by using the Insert Function. Should have used Insert Function only for the row/columns I was going to put new data in and not the entire row from A1 to ZZ or however far that row goes in Excel. Lesson learned. "When doing things too fast to try to save time, sometimes it causes you many times that time to figure what happened why it didn't work".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Misbehaving formula and wierd decimals
    By m3gney in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2017, 09:32 PM
  2. Excel data base or access data base collection?
    By mcdonalds in forum Excel General
    Replies: 0
    Last Post: 02-17-2014, 08:04 AM
  3. how to transform data from row-base to column-base
    By fei2010 in forum Excel General
    Replies: 3
    Last Post: 11-23-2012, 12:17 AM
  4. convert non data base to data base format using formula
    By murarihyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-22-2011, 11:42 AM
  5. Data validation formula - base 60
    By rgarber1950 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2008, 04:05 AM
  6. [SOLVED] How do I decile a data base, is there a formula that I can use?
    By I_raggs in forum Excel General
    Replies: 1
    Last Post: 05-18-2006, 11:25 AM
  7. Excel formula issues, wierd..
    By schleppy2 in forum Excel General
    Replies: 2
    Last Post: 09-06-2005, 10:05 AM

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