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 LauIron ContributorJan 02, 2018=INT((COLUMN()-1)/4+1) & "/" & COLUMN() or = INT((COLUMN() + 3) / 4) & "/" & COLUMN()
Willy LauIron Contributor to Willy LauJan 03, 2018I think it will be better if "COLUMN()" is changed to "ROW()"
Willy LauIron Contributor to Willy LauJan 03, 2018I think it will be better if "COLUMN()" is changed to "ROW()"
