+ Reply to Thread
Results 1 to 4 of 4

organizing data from a database import - blank cells

  1. #1
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2016
    Posts
    134

    organizing data from a database import - blank cells

    Hi

    We are asking some people to complete a form on a database. We can then pull the info from the database into a spreadsheet to number crunch

    We do not have control of the format that this data comes in to the spreadsheet

    Each row is a person

    Each col is a input field from the database.

    Now, here the issue.... not every input field is required to be completed by the person.

    For example,
    person 1 might only have data in A1 and B1
    person 2 requires data in A2 and C2 (b2 is blank)
    Person 3: A3 and F3 only

    All the data is in date form

    So, is there a way to perform a lookup so that excel "searches" the data in each row, looks for the last date and puts that date in Col B? The data in each row will always be chronological so as you move col's to the right, the dates will get closer to present day

    So, is it possible for Excel to search the row/area and look for the last date and show that in a specified field?

    Hope this makes sense?

    B
    Last edited by burnsie; 09-21-2020 at 12:30 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: organizing data from a database import - blank cells

    How about
    =LOOKUP(2,1/(C2:W2<>""),C2:W2)

  3. #3
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2016
    Posts
    134

    Re: organizing data from a database import - blank cells

    Quote Originally Posted by Fluff13 View Post
    How about
    =LOOKUP(2,1/(C2:W2<>""),C2:W2)
    You sir (or Ma'am) are a legend!!!

    So simple, but will literally save hours!!!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: organizing data from a database import - blank cells

    You're welcome & thanks for the feedback.
    (definitely a sir )

+ 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. Import data from Access database
    By Mark555 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2019, 12:43 PM
  2. Replies: 9
    Last Post: 10-10-2015, 02:32 PM
  3. import data into a database
    By rjhe22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2013, 11:53 AM
  4. Organizing data including linked cells
    By andrewgrant111 in forum Excel General
    Replies: 0
    Last Post: 03-10-2011, 12:50 AM
  5. Import Spreadsheet Data into Database
    By nkline in forum Excel General
    Replies: 3
    Last Post: 03-31-2010, 12:50 PM
  6. How to import data from Access Database.
    By vidi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2006, 02:35 PM
  7. Format of data import from a database
    By John Conklin in forum Excel General
    Replies: 2
    Last Post: 02-10-2005, 03:06 PM

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