Large IF a range of text contains a certain value

[adricor]

Hello,

I am trying to create a formula that ranks values based on a certain criteria. For example, return the 10 highest ranked catchers.

I can get excel to return the 10 highest ranked players, but not filter out only catchers.

Attached is the spreadsheet.

In Column A, I list the rankings I want to see: 1 through 10

In Column C11, I have this formula: =LARGE(MM,A11) MM is the name of the column with rankings I am evaluating.

In Column D11, I have: =MATCH(C11,MM,0)

In Column F11 I have: =INDEX(Players,D11) The "Players" is the name of the column with the players names.

The catchers were assigned a value of 2.00 in the column named "Pos". Also, many players have multiple positions so actual value may be 2.00, 7.00.

I have tried =LARGE(IF(Pos="2.00",MM),A11) any many other things and cannot get it to work.

Any help is very appreciated

help.xlsx

[samba_ravi]

Hi welcome to the forum.
where you are getting problem and what is your expected result

[FDibbins]

Hi, welcome to the forum

THis is (kinda) the syntax you would need to use...
=LARGE(IF(D1:D50="Pitcher",D1:D50),1)

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[bebo021999]

try to input your desired results without formula

[adricor]

Thanks- This might be getting closer but the result is "0". I uploaded the excel file at the bottom of the original post.

[adricor]

The desired result would be a rank of the top 10 catchers from a list of all players and positions

[ATTACH]371192

[samba_ravi]

d5=SMALL(INDEX((MM<>C5)*10^10+ROW(MM),0),COUNTIF(C$5:C5,C5))
try this and copy towards down

file you attached in post1 and post6 are same

if it is not you are looking for, fill expected results manually in your attached file

[adricor]

help2.xlsx

Thank you but that didn't solve the problem. I attached a new file with the results I was hoping for manually entered. It ranks column G on the Raw Data Tab for ONLY players with a value of 2.00 in column D on the Raw Data Tab.

[samba_ravi]

see the attached file

pls not that the formula in column c was an array formula, confirm with shift+ctrl+enter when you modified the formula
and Pos condition was given in Cell C1
If you want to change the pos change it in Cell C1

[adricor]

Thank you... this is really close! Can we change so that the value in C1 doesn't require an exact match? For example, if we enter a value of "2" in C1.... can it review any position that contains a 2 (2 or 23 or 2,09, etc)?