repeating data

  1. J

    count based on whether numbers within a given range repeat 6 times in a row

    Hi. I have a data set of hourly wind values over a number of years. I have divided the wind into speed groups - for example: range 1: >=0 - <=1m/s range 2: >1 - <=3m/s range 3: >3 - <=5m/s range 4: >5 etc. I would like to count if there is an occurrence of when the wind blew for 6 hours -...
  2. A

    Search in worksheet 2 (where data is stored) to find an exact side by side match for data in TWO cells not one. IF exact match Return (repeat) two ce

    I really hope I can get an answer for this question. I've spent HOURS trying to figure this out! I’M hoping that someone can help direct me. I’m able to search for an exact match using a VLOOKUP. I can only search one column though. <o:p></o:p> <o:p> </o:p> Here is my “current formula...
  3. H

    Removing Repeating Blocks of text

    Hi, I have a very long excel spreadsheet (46K rows) Made up mostly of a repeated text block & then a list of serial numbers, then the same text block and different serial numbers. This repeats over and over. I just want the serial numbers and to remove the text part. I get an error when I...
  4. B

    Creating a shift Rota / Calendar

    I am currently devising a rolling shift rota/calendar for a friend and his colleagues who work different shifts (Earlies, Lates and Nights). I want to input an abbreviation/letter (for example 'N' for night-shifts) in a cell and then get excel to automatically repeat that same 'N' entry, every...
  5. T

    repeating numbers

    actually not a question, more like an Excel trick someone could use. Formula to produce an array of numbers, starting from 1, repeating that number x times. After that, repeating the next integer x times. Until the maximum y is met. From then on, it repeats itself. This description might be...
  6. F

    Pivot table - Repeat data in certain fields

    Hello, I was hoping someone could help me with 2 simula problems regarding pivot tables. 1) Is there any way to have the pivot table fill in the data from a field list item on every line. In my example (under the variety column) I would like "bases" and "Shoes" to fill down into the empty...

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