position of values

  1. S

    Help with finding the position of a value as a percentage

    Hi all...I have a query that I'm struggling with, I'm not too sure if I'm going too technical too quickly tbh! I have some values laid out in a table similar to below, I need a formula that can automatically calculate the position of the value in % form. Min Max Value Position % 50 100 75...
  2. P

    Finding the position of parentheses

    Hi guys. I have a worksheet that contains around 90,000 rows. Column A contains product descriptions imported from an outside source. Other columns contain codes and usage data, etc, and are not relevant here. The descriptions in Col A vary insofar as the parentheses are not consistent; e.g...
  3. A

    Formula to find position with multiple conditions

    Hi, I'm running analysis of data that includes delivery times for two distinct store types (stores under 3000 and over 3000). Each delivery is distinguished by "Run" which can repeat for different regions (see example below). What I need to find is relative position of stores that are over 3000...
  4. M

    CLABE Checksum. Determining position of values.

    Hi there guys, hope you can help me :). First of all, the CLABE number is just a banking standard like IBAN or Routing numbers. I've been trying to write a code which could lead to retrieving the whole Mexican CLABE number + control digit from just the first 17 digits. This is how the checksum...

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