pattern

I want to insert in a cell a text "Saturday" and "Sunday" but I find it difficult to find the pattern inserting it. Thank you for your help.

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I want to find the all rows number of the each pattern</SPAN></SPAN> Below example shows the row numbers only for first 2 patterns, it is difficult to find manually.</SPAN></SPAN> Please need VBA help?</SPAN></SPAN> Result</SPAN></SPAN> data...

For example Is there a way for excel to see what would come out after the blow pattern Going from bottom to top ? ? ? OOO I. I. I I. I. I OOO OOI

I am trying to generate repeating numbers in the cell by decreasing patterns Here's the pattern: if starting number is 6 <tbody> 6 6 6 6 6 5 5 5 5 4 4 4 3 3 2 </tbody> Thank you for help in advance.

Hi, Can it be possible to have a quick way to have an alternating color pattern in excel rows depending on the cell value? Say I have these examples from Cell A1 to A9 with A1 as the header: <tbody> THIS IS THE HEADER IN CELL A1 <tbody> 10000123 </tbody> <tbody> 10000123 </tbody>...

Hello everyone. Thanks for looking. I have an excel issue that I'm hoping someone can help me with. I've been looking for a solution for a while but nothing I've tried so far works 100%. I'd love to hear your thoughts and any possible solutions. Here's my problem. I'm sorry that I can upload a...

Hello, I have a .txt file with a very long text. I would like to extract Lat and Long that follow the text "Coordinate: " using this pattern ##°##’##,##” N - ##°##’##,##” E after the comma can be one or two digit and after the dash there is often, but not always, a space character. I would...

Hi Guys, I cannot understand the logic in here. I am pretty much sure it should generate and error but it does not. It just adds me another Worksheet named according to regular pattern (Sheet4, Sheet5, etc.) I want to get an error just to skip creation with error handling and proceed to next...

Hi All, Would someone please be able to advise the quick way to auto fill a column based on the below pattern? =Sheet1!H3*Sheet2!B3 =Sheet1!I3*Sheet2!B4 =Sheet1!J3*Sheet2!B5 =Sheet1!K3*Sheet2!B6 New to this so apologise if vague or simple! Thanks.

Hi there I have a 9 box grid, each box has a value 1 to 9. I want each box to highlight its value if conditions are met in other cells. Example. 1. If 'A' <1.49 AND 'B' <1.49 then I want box 1 in the 9 box grid to show value '1'. 2. If 'A' >2.5 AND 'B' >2.5 then I want box 9 in the 9 box grid...

I would like to create a duplicate of each cell in a column and be able to auto fill the pattern on out. Example: B1: =A1 B2: =A1 B3: =A2 B4: =A2 B5: =A3 B6: =A3 and on and on. I cant get the auto fill to continue on with the pattern. It just keeps repeating the existing cell and doesn't...

Hey All, Wondering if you can assist. I'm trying to have Excel flash fill a pattern (similar to a alphanumeric serial number), but due to the patterns construction, Excel cannot identify and fill. Is there a good function or VBA code to use to have Excel continue the pattern? The pattern...

I have 3 columns of stock prices – the date, the low, the high, and the close. I am trying to build a formula (may have to be in multiple columns with each column having its own formula) that returns the A point price, B point price, and C point price of something called the ABCD pattern -- D is...

Using Excel 2000 Hi, I got patterns data in cells C6:C85 In the cells E5:G5 I got 3 patterns, In the cell C4 got 1 pattern X|X|1, what I want look this pattern from C6:C85 and get historical time period for the following patterns are listed in E5:G5 For example after the X|X|1 following...

Using Excel 2000 Hi, I got patterns data in cells C6:C69 In the cells E5:N5 I got patterns, which I want to extract from cells C6:C69 and put them in corresponding column E5:N5 Along with requested pattern; Bringing out 1 next following pattern For example in column E I want to extract...

Hello everyone, I have started playing around with calendars in excel and i've ran into a wall. Basically i have created a generic shift pattern spanning for 1 year in Sheet 1, and in Sheet 2 I am trying to create an interactive Attendance calendar. I was able to create a working 30-31 days...

I have an inventory of items in a sheet named Working Population. I would like to write some code that allows someone to select the names of the Associates that are in the office that day, then have Excel auto-enter those names into column E (the same process would happen in column J, but with...

Hi Everyone, I have 2 worksheets first sheet has list of computers. second sheet has list of computers (same computers as first sheet) but also has their errors , this sheet consists of 2 columns: computer name, error message. I have multiple error messages per computer, some repeating per...

Using Excel 2000 Hi, I got pattern in column C and in the column D Assign Num and in the column F got 27 unique patterns I am looking for 2 results... 1) In the column G find last the last row number of the each pattern 2) In the column H find the assigned number is matched in the column...

Hi, I want the following pattern to continue for the length of the worksheet but it doesn't follow the correct pattern when I drag down. This is what I want the pattern to be: Sheet 2 Z1 = 'Sheet 1'!AD2 Sheet 2 Z2 = 'Sheet 1'!AK2 Sheet 2 Z3 = 'Sheet 1'!AD3 Sheet 2 Z4 = 'Sheet 1'!AK3 Sheet 2 Z5 =...