Forum Discussion

jeetssai's avatar
jeetssai
Copper Contributor
Jan 02, 2018

Need 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

Formulas & Functions
Need Help

2 Replies

  • Willy Lau's avatar
    Willy Lau
    Iron Contributor
    Jan 02, 2018
    =INT((COLUMN()-1)/4+1) & "/" & COLUMN()

    or

    = INT((COLUMN() + 3) / 4) & "/" & COLUMN()
    • Willy Lau's avatar
      Willy Lau
      Iron Contributor
      Jan 03, 2018

      I think it will be better if  "COLUMN()" is changed to "ROW()"

Resources