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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top