formula question
 

Hi I am looking for the best formula to return a value depending on a couple
of arguements.

I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..

I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05

Thanks in advance

Format an empty cell as a date and enter in this formula (enter it by
pressing CTRL+SHIFT+ENTER) as it is an array formula:

=MAX(IF(A1:A10="meeting",A1:A10,""))


--
Regards,
Dave


"G" wrote:

Hi I am looking for the best formula to return a value depending on a couple
of arguements.

I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..

I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05

Thanks in advance

Thanks for the reply David but think i am missing something.. would you mind
dumbing it down a little .. sorry its 5 to 7 in the morning here !!

Ctrl+shift+enter not doing anything and I'm a little lost ..

"David Billigmeier" wrote:

Format an empty cell as a date and enter in this formula (enter it by
pressing CTRL+SHIFT+ENTER) as it is an array formula:

=MAX(IF(A1:A10="meeting",A1:A10,""))


--
Regards,
Dave


"G" wrote:

Hi I am looking for the best formula to return a value depending on a couple
of arguements.

I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..

I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05

Thanks in advance

If your dates are in ascending order, try

=LOOKUP(2,1/(B1:B5="Meeting"),A1:A5)

Otherwise, try...

=MAX(IF(B1:B5="Meeting",A1:A5))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"G" wrote:

Hi I am looking for the best formula to return a value depending on a couple
of arguements.

I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..

I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05

Thanks in advance

Sorry bout that, I had a typo in the previous formula, try this, it should
work (enter by CTRL+SHIFT+ENTER again):

=MAX(IF(B1:B10="meeting",A1:A10,""))

--
Regards,
Dave


"G" wrote:

Thanks for the reply David but think i am missing something.. would you mind
dumbing it down a little .. sorry its 5 to 7 in the morning here !!

Ctrl+shift+enter not doing anything and I'm a little lost ..

"David Billigmeier" wrote:

Format an empty cell as a date and enter in this formula (enter it by
pressing CTRL+SHIFT+ENTER) as it is an array formula:

=MAX(IF(A1:A10="meeting",A1:A10,""))


--
Regards,
Dave


"G" wrote:

Hi I am looking for the best formula to return a value depending on a couple
of arguements.

I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..

I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05

Thanks in advance

goal..

well done and thank you

"David Billigmeier" wrote:

Sorry bout that, I had a typo in the previous formula, try this, it should
work (enter by CTRL+SHIFT+ENTER again):

=MAX(IF(B1:B10="meeting",A1:A10,""))

--
Regards,
Dave


"G" wrote:

Thanks for the reply David but think i am missing something.. would you mind
dumbing it down a little .. sorry its 5 to 7 in the morning here !!

Ctrl+shift+enter not doing anything and I'm a little lost ..

"David Billigmeier" wrote:

Format an empty cell as a date and enter in this formula (enter it by
pressing CTRL+SHIFT+ENTER) as it is an array formula:

=MAX(IF(A1:A10="meeting",A1:A10,""))


--
Regards,
Dave


"G" wrote:

Hi I am looking for the best formula to return a value depending on a couple
of arguements.

I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..

I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05

Thanks in advance

Hi,

Use the following formula in another cell formatted as 'Date', and confirm
with
CTRL-SHIFT-ENTER

=MAX(A1:A100*(B1:B100="Meeting")) [Change the cell range appropriately]


Regards,
B. R. Ramachandran

"G" wrote:

Hi I am looking for the best formula to return a value depending on a couple
of arguements.

I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..

I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05

Thanks in advance