Kelly
Reputation: 1
Fill in sequential numbers
I have listed out sequential numbers (ie. 1,2,3,4,5,6,7,8,9,10,11,12,13...) in column A on excel, and I have the start and end numbers for a certain event (eg. start number: 3, end number: 8). I want to put a "1" from 3-8 and "0" for the rest using a formula. Does anyone know how to do this?
Upvotes: 0
Views: 60
Answers (1)
Related Questions
- Fill out numbers in list by sequence in Excel
- Fill a column with start number to end number
- Fills the cells below with a number sequence by filling only first cell
- How do I fill a series in VBA from a higher number to another?
- How to autofill number depending on next column and cell(number-1)?
- Generate a 3rd column sequential number based on two columns data
- Excel - How to fill in incrementing numbers in column starting from 1 until the value in another columns stays the same
- Autofill a number sequence from column A to column B
- How to fill blank cells with increment value in different cells in Excel?
- Fill an Excel column with consecutive numbers of another column?