Help with formula

[Richard]

Is there a way to count how many days a specific number
has been entered. Example:
Column A Column B
Part Number Date
12345 3-Oct-4
12345 3-Oct-4
99999 3-Oct-4
12345 7-Oct-4
99999 8-Oct-4
For part number 12345 answer would be from todays date to
7-Oct-4

 

[Jason Morin]

I think you could use:

=COUNTIF(A:A,"12345")

HTH
Jason
Atlanta, GA

 

[Myrna Larson]

Hi, Jason:

With the data he showed, do you suppose he wants to count Oct 3 twice? If not,
COUNTIF won't fill the bill.

I'm not sure *what* he wants. He talks about "from today's date to Oct 7". I
don't know what that has to do with it. Does he want the earliest data that's

= today and the latest date?

Myrna Larson

 

[Richard]

Part Number 12345 from October 3rd. thur October 7th,
would be 5 days.

 

[Myrna Larson]

This array formula may work:

=MAX(IF(A1:A5=12345,B1:B5))-MIN(IF(A1:A5=12345,B1:B5,100000))+1

Enter this with CTRL+SHIFT+ENTER.

100000 represents a date sometime in the year 2173. I hope that's high enough.
Or, instead of the literal, you could substitute something like TODAY()+1000,
which would be ~3 years into the future.