pull max wins from another sheet

[jackf-nc]

sheet 2 has 3 col. -(abc)
col a is name
col b is a date
col c has an amount

I want to pull max amount(col c) or greater date (col b)for example Sue 01/10/17 $24. However if there is a tie in $ amounts - bob 01/01/17 $24 to only show Sue's info in cell on sheet one.
Thanks guys!
Jack

[FDibbins]

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.


Also, take a look at the LARGE() and MAX functions

[jackf-nc]

Ford,
I have uploaded a file to comply with your email... I thought I explained it good enough. Sorry man!

[FDibbins]

Do you mean something like this?
=MAX(C2:C14)

[jackf-nc]

yes and no FDibbons. Yes the max function needs to be used to determine date / $ amt. I believe I also need to incorporate the index function. I am needing to show the, name, date , and $ of that particular user - so in the example On sheet 1 it should display in a1 Jack 05/06/16 $20.00 - like this: Jack $05/06/17 $20.00 pulling data from sheet 3.

If there is a tie(max $) then it goes to following date - example FDibbons wins $20. on 5/10 - Only your name would show!

Thanks,
I am still learning - have learned a lot. This inddex function is killing me.
Thanks again,
Jack

[FDibbins]

Lets try this as the next step, and build it as needed...
=INDEX(A:A,MATCH(MAX(C2:C14),$C$2:$C$14,0))

[jackf-nc]

FDibbons,

While this did pull up a name - it pulled up wrong name. In the example sheet - should of pulled up "Jack" since he has the greatest $ from col c. Instead it is pulling up Anthony. Any ideas?

[Phuocam]

Maybe ...

=INDEX($A$2:$A$14,MATCH(MAX($C$2:$C$14),$C$2:$C$14,0))

[jackf-nc]

That did it Phuocam. Would I have to add seperate index to bring in $ amount (col c) and date(col b)?
thanks again!

[Phuocam]

Date ...

=INDEX($B$2:$B$14,MATCH(MAX($C$2:$C$14),$C$2:$C$14,0))