bobby

  1. B

    Insert row question

    If I want to add/insert the name Mary (after each Larry) to the Excel column below, without typing in Mary about 10 or more times, what menu would I use? <tbody> Bobby Doris Jane Joe Larry Bobby Doris Jane Joe Larry Bobby Doris Jane Joe Larry Bobby Doris...
  2. B

    Loop with a formula on a dymanic range

    I have a need to loop through a dynamic range with a formula preferrable. If i have to use a macro i can, but would rather not if possible just for ease of maintenance down the road. My situation is this: "Names" would have a list of names repeated a number of times (variable but is based...
  3. J

    Lowest Number based on criteria, then second lowest number based on criteria

    Needing assistance with the following... Name Month Rank Time Order # Desired Result Bobby April 4 2:30 12433 0 Bobby April 0 4:30 14655 1 Bobby April 4 7:30 18654 0 Bobby April 2 3:30 98752 0 Bobby April 0 1:30 11548 1 Tommy April 0...
  4. B

    If statement to find variable data points and copy paste

    Hello all. I needs some guidance. I'm trying to create a formula that will look at a range of data and based on the words "closed" and "open" it will perform a cut paste to another tab. Example: A1 B1 C1 D1 E1 Joe Dirt Dodge...
  5. E

    Need help in finding a formula for the school i work for

    I need a formula in excel to have a worksheet showing that a student has completed all 9 courses as indicated in the database shown below. The original database has thousands of rows. Notice that ID # are repeated. If there was one ID# and if each course was in separate column, I would have used...

Watch MrExcel Video

This Week's Hot Topics

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