Function DMIN?
 

Column A = Employee Name
Column B = Date of Activity in Chronological order
Column C = Date of Next Activity
I am trying to use DMIN in column C to find the Date of the next activity
(by searching column B) for the specific employee in column A so I can then
calculate if the date of Next Activity is = 60 days from the date in Column
B.
I am using the following formula and getting the #value error message
=DMIN(A3:$B$65530,B3:$B$65530,A1:B2)
If I enter the MIN formula as opposed to DMIN, I get a result but it just
finds the min date and doesn't take the employee name variable into account.
=MIN(A3:$B$65530,B3:$B$65530,A2:B2)
Woud the function INDEX be of any help?
Thanks for your help.

What is your criteria? That's probably the problem with the DMIN Formula. Is
it mistyped? Does it have extra spaces?
Could you post an example?

tj

"Function Question" wrote:

Column A = Employee Name
Column B = Date of Activity in Chronological order
Column C = Date of Next Activity
I am trying to use DMIN in column C to find the Date of the next activity
(by searching column B) for the specific employee in column A so I can then
calculate if the date of Next Activity is = 60 days from the date in Column
B.
I am using the following formula and getting the #value error message
=DMIN(A3:$B$65530,B3:$B$65530,A1:B2)
If I enter the MIN formula as opposed to DMIN, I get a result but it just
finds the min date and doesn't take the employee name variable into account.
=MIN(A3:$B$65530,B3:$B$65530,A2:B2)
Woud the function INDEX be of any help?
Thanks for your help.

Tell us what your criteria range looks like.

On Fri, 19 Nov 2004 15:39:04 -0800, "tjtjjtjt"
wrote:

What is your criteria? That's probably the problem with the DMIN Formula. Is
it mistyped? Does it have extra spaces?
Could you post an example?

tj

"Function Question" wrote:

Column A = Employee Name
Column B = Date of Activity in Chronological order
Column C = Date of Next Activity
I am trying to use DMIN in column C to find the Date of the next activity
(by searching column B) for the specific employee in column A so I can then
calculate if the date of Next Activity is = 60 days from the date in
Column
B.
I am using the following formula and getting the #value error message
=DMIN(A3:$B$65530,B3:$B$65530,A1:B2)
If I enter the MIN formula as opposed to DMIN, I get a result but it just
finds the min date and doesn't take the employee name variable into
account.
=MIN(A3:$B$65530,B3:$B$65530,A2:B2)
Woud the function INDEX be of any help?
Thanks for your help.

Assuming your criteria range is:

A B
1 Emp Name <blank
2 Fred =C4=B4

Change your formula to:

=DMIN(A3:$C$65530,3,A1:A2)


Function Question wrote:
Column A = Employee Name
Column B = Date of Activity in Chronological order
Column C = Date of Next Activity
I am trying to use DMIN in column C to find the Date of the next activity
(by searching column B) for the specific employee in column A so I can then
calculate if the date of Next Activity is = 60 days from the date in Column
B.
I am using the following formula and getting the #value error message
=DMIN(A3:$B$65530,B3:$B$65530,A1:B2)
If I enter the MIN formula as opposed to DMIN, I get a result but it just
finds the min date and doesn't take the employee name variable into account.
=MIN(A3:$B$65530,B3:$B$65530,A2:B2)
Woud the function INDEX be of any help?
Thanks for your help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html