Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria

Hi,
I saw EXCELISFUN TRICK 369. I need to do something similar. I tried to follow his code and couldn't. Then I tried copying it and growing his records and still couldn't get it to work.

What I am trying to do is on the first list use an inventory list. Which could be about 2000 - 5000 records or maybe double that (not sure how big of a list I could use in Excel). But lets say it is the max number (if someone could tell me that number I would be most appreciative).

I then will load a second list, or would load a list into second column. I then want the difference (what is missing) from the second list to appear in the third list. If it can give me the row of where it is in the first list that would be great (not a problem if you can't). I just don't know why the code from that video is not working any help would be greatly aprreciated?

Thanks,

Peter Fraga
(fragapete@hotmail.com)

Hi All,

I was setting up a spreadsheet that was based on the following vid:
http://www.youtube.com/user/ExcelIsF...14/tqCEY5YMyqw

Dynamic sub tables based on a master sheet array formula

The formula in question is:
=IF(ROWS(A$7:A7)>$E$1,"",INDEX('2010Corn'!A$4:A$17,SMALL(IF(Table2[From]=$B$1,ROW(Table2[From])-ROW('2010Corn'!$H$4)+1),ROWS(A$7:A7))))

B1 is the customer I'm looking for, E1 is the count for the customer and the master page is 2010Corn. I have 20 sheets looking to this master page for data. It works great, except for an issue when adding a new line in the master table.

What is happening is when I get to the end of a row, I tab to enter a new line in the table. It takes up to a minute for the cell to change color and for me to regain control of the computer.

I have run a performance trace and while the computer is locked, one of the CPU core's is pegged for the whole time with a processor que of up to 10 items at a time.

My question is...does anyone have any hints how to optimize this formula?

Thanks
Tony

Ok so let me set this up. I have 2 columns:

Project Date Start
NY 1/14/2009
Cali 5/6/2010
NY 7/2/2009
NY 8/2/2010
Cali 3/2/2009
Cali 10/2/2011

Ok, so what function can I use that will output the earliest "Date Start" but using the criteria of "Project". I want to make sure that when this list grows to 1,000+ that I don't have to go back through and create a new formula each time. The objective is to have Tab 1 show:

Project Date Start
California 3/2/2009
New York 1/14/2009

So on and so forth for new projects as they come on.

Things I have tried and might just be scripting wrong (Keep in mind that for me "Project" is column B and "Date Start" is column E:

=IF((IF(T(B:B)="cali",COUNT(E:E),"")),MIN(E:E),"")

I have found several ways to pull the lowest date, but not when I need it to reference it based on the criteria of "Project". Anything you can offer would be great! Thanks!

Please find attached excel file. I am stumped as to what formula I should try in order to achieve as in the examples?

I've tried MAX/MIN formulas and sometimes using IF formula, but with no success?

Any ideas?

Cheers.

Hello everyone. I'm thinking this one should be simple, but I am confused as to why I can't get it to work. I have a column of dates listed at the bottom of this post. I am looking to have a formula in a cell that gives me the earliest date from the column. I have tried Min() and Small() with no success. Is it perhaps the "AM" and "PM" that is throwing things off? A small example of the data:
11/21/2008 AM 11/09/2008 AM 11/09/2008 PM 11/09/2008 PM 11/10/2008 PM 11/11/2008 AM 11/11/2008 AM
and it should return 11/09/2008. Thanks in advance any and all.
Ed

much like this:

http://www.ozgrid.com/forum/showthre...goto=newpost**

But I need it to show the 12 earliest dates, accompanied by information in the same row... (see attatchment)

The example has them sorted, but this will not be the case as there are literally hundreds of dates changing in the run of a day...so some of the earliest dates may be in the middle or end (completely random).

Hi all,

There is a speadsheet at work with a column which has a range of dates (from 18/05/2003 - date) which information gets drawn from every Friday. The information needed from the column is pretty simple but lengthy to expalin. For example...

http://xs511.xs.to/xs511/07043/shot1.png

As you can the dates are in no order...and need to stay that way. The information needed every week is shown here...

http://xs311.xs.to/xs311/07043/shot2.png

I have got the formula for the number of enteries between each date but strugling with the earliest date within the dates. I can do it manually by auto filtering the column and looking for the date closest to the earliest date but this is long.

The dates change on a weekly basis...just to throw a spanner in the works.

Any help offered is appreciated.

Thank You.

I have two columns in a table; Plan and Date.

Plan Date
A 01/02/03
B 12/08/05
C 02/04/06
C 06/04/07
C 06/04/07

Now I want the third column, also a date, so that it returns the earliest date for the repeating plan type.

Plan Date New Date
A 01/02/03 01/02/03
B 12/08/05 12/08/05
C 02/04/06 02/04/06
C 06/04/07 02/04/06
C 06/04/07 02/04/06

I would appreciate any help. Thank you.

Ok, i'm linking cells from different worksheets.
I'm using this "LOOKUP(2^20,SHEET4!A:A", to get the last value of a cell.
I'm getting stuck with a cell link.
One cell will need to be formulated to find the earliest date from 2 sheets.
I would like to still use the formula above to find the last value in row A:A, which will be dates. Those dates will be the ones the script will find the earliest date from.

Thanks!

Help!

I have a column with dates and time in which I like to find the earlist entry and the latest entry automatically among the data.

Example

A B C Time Start date End date 2009-02-06 06:41:26 2009-02-01 22:30:11 2009-03-04 12:58:39 2009-02-01 22:30:11 2009-02-01 22:54:11 2009-02-24 13:22:29 2009-02-17 10:00:22 2009-02-27 11:45:17 .... 2009-03-04 12:58:39 2009-03-03 11:52:43

Length of the column and the order of the data varies from each time I extract the data from a database. Date for earliest entry is to be displayed in B1 and date for latest entry is to be displayed in C1.

Thanks in advance!