pattern

This my first posting, I have used this site dozens of times to find answers, now I NEED HELP!! I have a series of numbers (angles in degrees) in columns. I need to know the process for searching the column and displaying the results based on my rules below: Search Column A > When there are 5...

I need a formula, way to input the dates of every Wednesday and Friday since 01/07/2105 so for example the dates I require int he pattern would be: 01.07.15 03.07.15 08.07.15 10.07.15 15.07.15 17.07.15 and so on - every Wednesday and Friday. Rather than typing out the actual date is...

I need help with creating a pattern with the average formula. I'm brand new to this site so I tried a search, but didn't have any luck finding what I wanted. This is the formula I'm currently using: =IFERROR(AVERAGE(B19,B32,B45,B58,B71),"") The IFERROR is for the cells that can't divide by 0...

Hi There. I need to take the average of cells in column A, but I need to take them for rows 1-5, 6-10, 11-15....etc. Does anyone know how I can quickly do this with a fill? Or a work around for this? I tried manually typing in for a few cells AVERAGE(A1:A5) then AVERAGE(A6:A10) and so on but it...

Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 To become: Column A AAA_BBB_0002135 AAA_BBB_0002135 AAA_BBB_0002135 AAA_BBB_0002135 AAA_BBB_0002136 AAA_BBB_0002136 AAA_BBB_0002136...

I have data similar to below 17120141548 58820136814 31220146235 18020148742 91020137421 I want to use the custom filter to identify only those cells in which the 6th and 7th digit is 14. I've tried every combination I can and can't make it work. I've chosen "contains" *****14**** and...

i have this pattern GRB1F GRB2F GRB3F GRB4F Is there a way to drag it down so it continues as GRB5F GRB6F ? please help. i have hundreds to do and dont want to do them one by one:confused:

I would like to search for a certain pattern that appears in a cell. For example, I have certain cells that begin with a 7 digit project code (Ex: "1234567 - Project Red"). I was planning to use an IF inside a FOR loop and then do an action when I find the cell with the pattern. I thought I...

I have a string and a pattern. If a substring of the string is found in the pattern, the string is no longer valid. I would like to return a message stating which substring was found in the pattern. I appreciate any help. String: K22+L09+P88+Q12+J56 Pattern: (N75|X02|A21|U67|L09|...) Output...

Hello, hoping for some advice please. I am looking to set up a shift rotation planner for a charity I am involved with, and am not sure if I should be attempting this in Excel or if because of the number of potential volunteers/requirements I should be looking at separate software. Details as...

Hi, I am having a few issues with the excel autofill function. Here is what I want it to look like: <tbody> A A1 =IF(Sheet2!A1>=4,100,IF(Sheet2!A1=3,75,IF(Sheet2!A1=2, 50, IF(Sheet2!A1=1,25)))) A2 =-A1 A3 =IF(Sheet2!A2>=4,100,IF(Sheet2!A2=3,75,IF(Sheet2!A2=2, 50, IF(Sheet2!A2=1,25))))...

I have a need to create a complicated series of cell copies (atleast complicated to me). In Sheet1, I have info in cells A5 to B40. In Sheet 2, I need to take the info from Sheet1!A5 and place it into Sheet2!E2. This is straight forward. Next, I need cells Sheet2!F2 to Sheet2!K2 to have the same...

Hello, I was wondering if it is possible to count the occurrence of a specific series relative to other cell values. . . My dataset has two relevant columns, G and H. The data are 1s and 0s. If G=1 then H=0 and vice versa. Alternatively, both G and H can = 0 at the same time. What I would...

Hello People, I have one (middle) column of numbers and I want to have a running total as a certain pattern appears as shown in the numbers below: <tbody> 91 91 92 93 94 94 3 95 96 96 2 97 98 99 99 3 100 99 99 98...

I was wondering if anyone knew how to use VBA to solve the following problem - I am transposing several ranges of data from Sheet2 to Sheet8-Sheet57. A detailed description is as follows: Horizontal range B3:X3 of values to vertical range L7:L29 in Sheet8 {=transpose('Sheet2'!B3:X3)}...

I could really use some help with this one... I have the following formula that I want to copy and keep a pattern: In cell A1 I have =CONCATENATE(DATA!H4,DATA!I4) and in cell B1 I want it to read =CONCATENATE(DATA!L4,DATA!M4) and in cell C1 I want it to read =CONCATENATE(DATA!P4,DATA!Q4) and...

Hello, I hestitate to ask this, as I feel there is probably a very simple solution that I am overlooking. I am setting up a macro, and have a repeating pattern of approx 30 lines that I will need to populate across maybe 90 items. Each item in column A will be repeated 30 times, and then...

Not sure if someone has asked this before, if so I can not find it. I have a sheet that needs to be formatted for printing. The text in the file is a lookup form a different sheet. What I am trying to do is colour code thing ie if the cell is YEL and change colour to Yellow, BLU to Black and...

Can someone please advise what the correct pattern is to return the text between two search strings? For example, in the html string below, I want to return the text between "selected>" and "<". In this example I want "NA". "<SELECT class=nfinput name=pace0><OPTION value=L>L</OPTION><OPTION...

Hi, I have created an Access database and imported a load of data from an Excel spreadsheet. All fields are set to TEXT except a YES/NO field, a MEMO field and of course the ID field. I have been searching my database most of today updating records as required by using the SEARCH function at...