jeetssaiCopper ContributorJan 02, 2018Need help with formulaHow 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…?
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 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()"
