switches

  1. B

    Formula To Flash Fill Goofy Pattern

    Hey All, Wondering if you can assist. I'm trying to have Excel flash fill a pattern (similar to a alphanumeric serial number), but due to the patterns construction, Excel cannot identify and fill. Is there a good function or VBA code to use to have Excel continue the pattern? The pattern...
  2. J

    Macro to run as long as there is a value in column A

    I have a Macro that was written by someone else. This is a Macro/VB module we use to scrub data so that it will cleanup a number of special characters and style tags. I have detected a bug that it will only run against a spreadsheet until it encounters the last blank line in column "B". It needs...
  3. K

    Rank Question

    In column D I am needing a formula to give the rank of Column C as it relates to Column B. The Rank formula will reset when the Lane ID # switches. <tbody> Lane ID # Base Rate ($) Quote ($) Rank 1 10 15 1 10 10 1 10 20 2 20 25 2 20 30 2 20 35 </tbody>
  4. D

    Help with: Prefill cells with command line switches from a browser

    Hi everyone, I've been coming here a while now, and I can see my question has been partly answered. I'm looking to have an excell file shared on a windows network to a simple LAN (samba sharing), and then for a user to be able to click on a HTML link that will launch that excell pile, and to...
  5. S

    Flex year end

    Have a monthly model and want to be able to flex the year ends between Dec, March and June from a switch. What's the easiest way to do this, use flags?

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
Top