Hi,
In sheet1 have the raw data with playername, Runs and wickets.
sheet2 i need output. I need to combine the runs (highest value) and wickets (lowest value match with highest value) based on player name.
for example:
Player name is praveen.
Praveen highest wicket is 4 and corresponding lowest runs is 6
Output is highlighted in yellow color in sheet2.
Attached spreadsheed
Try this array formula on sheet2 and in cell B2 and drag down. Remember to confirm this formula with Ctrl+Shift+Enter
=MAX(IF(Sheet1!$A$2:$A$30=A2,Sheet1!$C$2:$C$30))&"/"&MIN(IF(Sheet1!$A$2:$A$30=A2,IF(Sheet1!$C$2:$C$30=MAX(IF(Sheet1!$A$2:$A$30=A2,Sheet1!$C$2:$C$30)),Sheet1!$B$2:$B$30)))
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thank You so much! This formula is working perfectly. This is what i expected.
Glad to help you. Thanks for the feedback. If you have got your answer, please mark your thread as solved. Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
plan 
Register To Reply
Bookmarks