index match large if

  1. F

    LARGE IF AND Formula

    Looking to populate the ID with the largest nth Value in L15 :P15 based on the following conditions. Date is 10/17 location is North =INDEX(A:A,MATCH(LARGE(IF(AND(D:D=L13,B:B=K15),C:C),1),C:C,0)) formula does not work, looking for the appropriate formula ABCDEFGHIJKLMNOP1IDLocation Value...
  2. C

    Find 2nd and 3rd highest numbers in a row and return column header

    <tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;"> ETF-A ETF-B ETF-C ETF-D 10 27 11 11 </tbody> I cannot seem to write the formula that would return the column header of the second...
  3. T

    INDEX MATCH LARGE IF? Help please

    Hello I am trying to work out a formula which will return a name in relation to a highest result in a column from a range of columns which will have data added to each week. Having used this website before (thanks for the help) I have used the following formula which gives me the name in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top