large and small function

  1. S

    Need to get formula to work IF,(Index(Match(Large

    I am having trouble trying to get this formula to work. In the workbook I have a scorecard table(sheet 1 & its not a pivot table) that pulls in the information from raw data(sheet 2). I want to return the top 5 contract #'s based on the top five highest priority level and contract owner name...
    • studentpro
    • Thread
    • formula formula and functions index & match large and small function
    • Replies: 1
    • Forum: Excel Questions
  2. B

    Return column names of three highest values (with ties!)

    I'm working on matching ~2000 survey participants with 1 of 15 election candidates based on (amongst other criteria) their rating of how important different issues are to them. There are 10 issues (A-J), but to keep it simple I want to match based on the top 3 issues (i.e. get best fit(s) for...
  3. C

    LARGE function with only positive value/SMALL function with only negative value

    Hello, i've been searching how can i just have positive numbers in LARGE function and only negative numbers in SMALL function. <colgroup><col span="2"><col span="2"><col></colgroup><tbody> A B C D 1 Weight 2 City 2013-14 2014-15 Variance 3 HKG 12,930,136 12,837,363 -92,773 4 SHA...

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