Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
lanem951Copper ContributorMay 16, 2022auto fillhow do you auto fill makeing a list as0-11-22-3 and so on
HansVogelaarMVPMay 16, 2022lanem951 Let's say that you want the first value 0-1 in a cell in row 2. In that cell, enter the formula =ROW()-2&"-'&ROW()-1 You can fill this down.lanem951Copper Contributor to HansVogelaarMay 16, 2022IM NOT REALLY UNDERSTANDING THATHansVogelaarMVP to lanem951May 16, 2022lanem951 Like this: See the attached sample workbook.Sequence.xlsx9 KBShow More
HansVogelaarMVPMay 16, 2022lanem951 Let's say that you want the first value 0-1 in a cell in row 2. In that cell, enter the formula =ROW()-2&"-'&ROW()-1 You can fill this down.
HansVogelaarMVP to lanem951May 16, 2022lanem951 Like this: See the attached sample workbook.Sequence.xlsx9 KB