jeetssaiCopper ContributorJan 02, 2018Need help with formula https://www.quora.com/unanswered/How-do-I-make-formula-in-excel-of-this-series-i-e-1-1-1-2-1-3-1-4-2-5-2-6-2-7-2-8-3-9-3-10-3-11-3-12%E2%80%A6
Willy LauSteel ContributorJan 02, 2018=INT((COLUMN()-1)/4+1) & "/" & COLUMN() or = INT((COLUMN() + 3) / 4) & "/" & COLUMN()
Willy LauSteel Contributor to Willy LauJan 03, 2018I think it will be better if "COLUMN()" is changed to "ROW()"
