How to Create Sequential Odd Number list in Excel

#Excel #ExcelTips #ExcelFormula #ExcelFunctions #ExcelTutorial #ExcelForBeginners #NumberSequence #OddNumbers #ExcelShorts #SpreadsheetTips "Please copy the link below to download the sample file." https://docs.google.com/spreadsheets/... Hello! I'll explain how to create a list of odd numbers in Excel using three different formulas: *ROW()2-1, SEQUENCE(20,1,1,2), and MAKEARRAY(20,1,LAMBDA(r,c,r*2-1)). 1. ROW()*2-1 This is the most straightforward and simple method. ROW(): This function returns the row number of the current cell. For example, if you enter this formula in cell A1, it returns 1; in cell A2, it returns 2. ROW()*2: This multiplies the row number by 2. In cell A1, it's 1*2 = 2. In cell A2, it's 2*2 = 4. In cell A3, it's 3*2 = 6. ROW()*2-1: Finally, it subtracts 1 from the result. In cell A1, it's 2-1 = 1. In cell A2, it's 4-1 = 3. In cell A3, it's 6-1 = 5. This method uses the ROW() function to transform the row number into an odd number. By dragging this formula down, you can create a sequential list of odd numbers like 1, 3, 5, 7, and so on. 2. SEQUENCE(20,1,1,2) This formula is a dynamic array function that automatically creates a list of a specified size with just one entry. SEQUENCE(rows, columns, start, step) rows (20): Creates an array that spans 20 rows. columns (1): Creates an array in a single column. start (1): The list begins with the number 1. step (2): The value is increased by 2 for each subsequent item. This formula is like telling Excel, "Create a 20-row, 1-column array, starting with 1 and increasing by 2 each time." This instantly generates a list of 20 consecutive odd numbers (1, 3, 5, ...). 3. MAKEARRAY(20,1,LAMBDA(r,c,r*2-1)) This formula combines the MAKEARRAY function, which builds an array, with the LAMBDA function, which creates a custom function. MAKEARRAY(rows, columns, LAMBDA) rows (20): Creates an array with 20 rows. columns (1): Creates an array with 1 column. LAMBDA(r,c,r*2-1): Defines the rule that MAKEARRAY applies to each cell in the array. r: Represents the row number of the current cell. c: Represents the column number of the current cell. r*2-1: Instructs Excel to apply the calculation (row number * 2) - 1 to each cell. MAKEARRAY first creates an empty 20x1 array and then uses the LAMBDA rule (r*2-1) to fill each cell with a value. The logic is the same as the first formula, but it creates the entire list automatically as an array. Comparison of the Formulas ROW()*2-1: Simple and intuitive, but you have to drag the formula down to fill the list. SEQUENCE(20,1,1,2): The fastest and easiest method. You enter it in one cell, and the entire list is automatically generated. MAKEARRAY: This is useful for applying more complex and flexible rules using a LAMBDA function. While it might seem complex for just making a list of odd numbers, it's a powerful tool for building arrays based on specific patterns. All three methods work well, but if you're comfortable with dynamic array functions, SEQUENCE is the most efficient choice.