software

Attached is an excel file. There are two worksheets. In Worksheet 1
are 2 names with multiple dates and lab values. In Worksheet 2 is the
name with a blank space for labs and dates. I need put in the blank
lab and date fields on worksheet 2 the most recent date with associated
lab value.

Thanks to Steveg on a very similar topic we are using the formula
=SUMPRODUCT(--(Sheet1!$A$1:$A$12198=A1),--(Sheet1!$C$1:$C$12198=B1),(Sheet1!$F$2:$F$12198))
to get a value if there was only one to chose from on seperate
worksheets. The only problem I am having with this formula in my old
case, is that it is not working when the values are textual.

Thanks for the help,
Wendi -------------------------------------------------------------------
|Filename: Forum help.zip |
|Download: www.excelforum.com/attachment.php?postid=4272 |
-------------------------------------------------------------------

--
wgechter
------------------------------------------------------------------------
wgechter's Profile: www.excelforum.com/member.php...oamp;userid=30799
View this thread: www.excelforum.com/showthread...hreadid=505535we don't attache or look at workbooks around here.
if you can't explain your issue...
break it down into individual questions and ask 1 question per issue
otherwise I can GUARENTEE you that you will not get an answer

--
Gary Brown
quot;wgechterquot; wrote:

gt;
gt; Attached is an excel file. There are two worksheets. In Worksheet 1
gt; are 2 names with multiple dates and lab values. In Worksheet 2 is the
gt; name with a blank space for labs and dates. I need put in the blank
gt; lab and date fields on worksheet 2 the most recent date with associated
gt; lab value.
gt;
gt; Thanks to Steveg on a very similar topic we are using the formula
gt; =SUMPRODUCT(--(Sheet1!$A$1:$A$12198=A1),--(Sheet1!$C$1:$C$12198=B1),(Sheet1!$F$2:$F$12198))
gt; to get a value if there was only one to chose from on seperate
gt; worksheets. The only problem I am having with this formula in my old
gt; case, is that it is not working when the values are textual.
gt;
gt; Thanks for the help,
gt; Wendi
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Forum help.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4272 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; wgechter
gt; ------------------------------------------------------------------------
gt; wgechter's Profile: www.excelforum.com/member.php...oamp;userid=30799
gt; View this thread: www.excelforum.com/showthread...hreadid=505535
gt;
gt;


See attachmentHope it helpsGary L Brown Wrote:
gt; we don't attache or look at workbooks around here.
gt; if you can't explain your issue...
gt; break it down into individual questions and ask 1 question per issue
gt; otherwise I can GUARENTEE you that you will not get an answer
gt;
gt; --
gt; Gary Brown
gt;
gt;
gt;
gt; quot;wgechterquot; wrote:
gt;
gt; gt;
gt; gt; Attached is an excel file. There are two worksheets. In Worksheet
gt; 1
gt; gt; are 2 names with multiple dates and lab values. In Worksheet 2 is
gt; the
gt; gt; name with a blank space for labs and dates. I need put in the blank
gt; gt; lab and date fields on worksheet 2 the most recent date with
gt; associated
gt; gt; lab value.
gt; gt;
gt; gt; Thanks to Steveg on a very similar topic we are using the formula
gt; gt;
gt; =SUMPRODUCT(--(Sheet1!$A$1:$A$12198=A1),--(Sheet1!$C$1:$C$12198=B1),(Sheet1!$F$2:$F$12198))
gt; gt; to get a value if there was only one to chose from on seperate
gt; gt; worksheets. The only problem I am having with this formula in my
gt; old
gt; gt; case, is that it is not working when the values are textual.
gt; gt;
gt; gt; Thanks for the help,
gt; gt; Wendi
gt; gt;
gt; gt;
gt; gt;
gt; -------------------------------------------------------------------
gt; gt; |Filename: Forum help.zip
gt; |
gt; gt; |Download: www.excelforum.com/attachment.php?postid=4272
gt; |
gt; gt;
gt; -------------------------------------------------------------------
gt; gt;
gt; gt; --
gt; gt; wgechter
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; wgechter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30799
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=505535
gt; gt;
gt; gt; -------------------------------------------------------------------
|Filename: Forum help-R1.zip |
|Download: www.excelforum.com/attachment.php?postid=4273 |
-------------------------------------------------------------------

--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: www.excelforum.com/member.php...foamp;userid=7094
View this thread: www.excelforum.com/showthread...hreadid=505535
Thanks for the help Morrigan unfortunately the formula assumes that I
know the most recent date. In my real spreadsheet I have thousands of
patients with 1 to 20 different dates and I want the formula to be able
to find the most recent date of that one patient and their associated
value. Does that make sense? Thanks for helping, Wendi--
wgechter
------------------------------------------------------------------------
wgechter's Profile: www.excelforum.com/member.php...oamp;userid=30799
View this thread: www.excelforum.com/showthread...hreadid=505535Morrigan just took a VERY courageous move by opening a file from someone he
COULD NOT TRUST!!! Please recognize his RISK by giving him a 'Yes' to his
helpful post.!!!
Morrigan, you've just risked/lost one of your nine lives. Hope your LUCK
continues!
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;wgechterquot; wrote:

gt;
gt; Thanks for the help Morrigan unfortunately the formula assumes that I
gt; know the most recent date. In my real spreadsheet I have thousands of
gt; patients with 1 to 20 different dates and I want the formula to be able
gt; to find the most recent date of that one patient and their associated
gt; value. Does that make sense? Thanks for helping, Wendi
gt;
gt;
gt; --
gt; wgechter
gt; ------------------------------------------------------------------------
gt; wgechter's Profile: www.excelforum.com/member.php...oamp;userid=30799
gt; View this thread: www.excelforum.com/showthread...hreadid=505535
gt;
gt;


I think you lost me.

The formula in column E finds the most recent date for each patient and
outputs it. The formula in colum D searches for the corresponding value
and outputs. Isn't that how you want?
wgechter Wrote:
gt; Thanks for the help Morrigan unfortunately the formula assumes that I
gt; know the most recent date. In my real spreadsheet I have thousands of
gt; patients with 1 to 20 different dates and I want the formula to be able
gt; to find the most recent date of that one patient and their associated
gt; value. Does that make sense? Thanks for helping, Wendi--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: www.excelforum.com/member.php...foamp;userid=7094
View this thread: www.excelforum.com/showthread...hreadid=505535
Morrigan, yes that is exactly what I was looking for. I should have
looked more closely. Thanks for the response!! At least someone is
very helpful!!--
wgechter
------------------------------------------------------------------------
wgechter's Profile: www.excelforum.com/member.php...oamp;userid=30799
View this thread: www.excelforum.com/showthread...hreadid=505535