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