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
Bookmarks