![]() |
|
|
|
#1
|
||||
|
||||
|
COLUMN(C13) returns the column number of cell C13, which is 3. Subtracting 3 from that gives you 0 and passing 0 as the column argument to INDEX gives you all the columns of the relevant row.
The QUOTIENT function returns the integer part of a division, ignoring any remainder. SO that part is taking the row number, subtracting 14, dividing by 31 and keeping the integer part. You then add 3 so the result here will never be less than 3. Other than the first block of 3s, you will get blocks of 31 of the same number - i.e. 31 4s followed by 31 5s and so on. |
|
| Tags |
| formula help, index, quotient |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Formula Help Needed
|
OTPM | Excel | 7 | 02-05-2018 07:16 AM |
| Formula needed; I'm helpless | Ylli | Excel | 10 | 12-13-2017 04:06 AM |
hard formula needed
|
nfsmith | Excel | 6 | 03-19-2016 06:12 PM |
Explanation for this formula
|
Will | Excel | 7 | 11-26-2014 05:27 PM |
Formula help needed
|
Cosmo | Excel | 1 | 08-23-2012 11:50 AM |