c56

  1. D

    Remove duplicates & create list

    I have a long list with codes in sheet 1 of my data starting at A2 (the list is very long 4500 rows): <tbody> C56 A125 R89 C56 B125 B125 A125 R89 D512 S226 D512 R89 </tbody> In sheet 2 I need to create a list of all the codes and remove the duplicates. I'm using the...
  2. F

    If Then statement returning cell contents

    I am trying to work an If Then formula that will return the contents of a cell. F78 = locations the Dr can practice (this is mult-select), C78 = Name of Doctor, C56 = location name. What I need is if the location is listed in F78 to populate the Doctors name. For example the location list...
  3. K

    Finding the lowest carrier amoung a specific list

    Hello - I'm looking to find the lowest carrier based on a certain criteria. Hoping someone can help. Cell C56 gives me my rating bands 1-22 If C56 is NOT 7 or 15 I need to find the lowest silver rate among Aetna, BCBS or United F55:O55 is the row that list all my carriers F56:O59 are my rates...

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