repeating data

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

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

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

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

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

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