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 02, 2018I think it will be better if "COLUMN()" is changed to "ROW()"
Willy LauIron Contributor to Willy LauJan 02, 2018I think it will be better if "COLUMN()" is changed to "ROW()"
