indeax

  1. P

    Search in Range created from a condition or first searching

    Good morning, everyone, the present problem: It consists of 2 parts: First part of the problem. First we have two sheets: Sheet1 and SP2 In Sheet1 we have key elements column B which contains codes from row 5 downwards and then we have row 3 to the right starting from column L which contains...
  2. A

    Extract unique values but also exclude names from another column

    Hi everyone, I have a list of names on E10:E1000 and I am creating a list of unique values on this list using the function below. =IFERROR(INDEX(!$E$10:$E$1000, MATCH(0,COUNTIF($C$16:C16,!$E$10:$E$1000), 0)),"") However, I would like to exclude from this list a range of names that are in...
  3. C

    Adding another Criteria help needed

    I have a data set where I need to find the closest 3 results of a given number. column a speed 47 36 12 6 1 column b group 1 2 2 2 1 Given number "25" in c5 I want to be able to have the closest numbers to "25" in each group I can get the closest to it using...

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