switches

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...

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...

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>

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...

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?