challenge

  1. S

    Formula for "Text to Row" Functionality

    All right . . . I have been bashing my head against a wall for two days now because I got interested in solving this issue. I have a cell that contains thousands of names in the following format: Smith MD, Bob; Savage DDS, Fred; Doe MD, Jane; . . . et cetera I have already fixed the issue...
  2. B

    Challenging Excel Question

    Hello everybody, I posted this question a few days ago and haven't gotten any replies. Not sure if this functionality is just too hard to do in Excel or if I wasn't very clear in what I'm trying to get the spreadsheet to do. Any help would be appreciated! I am working on a project in Excel...
  3. T

    NEED to figure out a sorter program,

    Hi, I am inputting alot of raw data from the field and Excel programming of this sort isn't my strong suit. Basically I have Seven Columns, Column "A, B,C, E" are the one i need to sort, column A is a type of configuration FFC-0###, where the number signs correspond to different locations, the...
  4. M

    CHALLENGE FOR an EXCEL WIZ

    Hi Everyone, Here is my challenge. It may sound easy but I have not been able to find a solution as of yet. I am creating a template so that when I upload data it auto populates and I have little work to do. Here is my problem: I have a list of Sales and wish to rank them (easy...
  5. V

    Want to do take an inventory spreadsheet to the next level

    I am in charge of inventory for various pieces of computer equipment. My office loans out equipment on a daily basis. I would like to either write some code or a macro that will fill a cell with a certain color (like red) if an item is checked out based on a specific value in a cell. For...
  6. A

    Speed Challenge

    Hello I have a friendly challenge for the board. I have some code I built that I want to see if anyone can improve the performance of. I never had any formal VBA education other than the trial and error method and learning from looking at different code on this board. Here is the challenge...
  7. D

    Excel Challenge - AMP Super Simulator

    Hi, AMP, an Australian financial services firm, has built a retirement calculator on the web that made me hear a "klunk" sound when my jaw bounced off the ground. It has a bar graph with a second Y axis. The second Y axis features a horizontal line with a spin button on the end that moves...
  8. B

    Numerology Challenge

    Hello, I have a HUGE list of either 2 digit or 3 digit numbers in column I. I'm trying to set up a macro that would convert this whole column into a single digit number by using the numerology method. This is it in a nutshell: If cell I1 was to have '157' in it, I would like cell J1 to contain...

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