Microsoft Office Forums Explanation Needed With Formula Please?
 Register FAQ Search Today's Posts Mark Forums Read

#1
10-29-2022, 11:39 AM
 ColtonYYZ Windows 11 Office 2021 Novice Join Date: Oct 2022 Posts: 4

So in a different post earlier, the solution was the following formula:

=INDEX(Sunday!\$A:\$L,QUOTIENT(ROW(C13)-14,31)+3,COLUMN(C13)-3)

Can someone please explain to me what the red bold part means, so that I can adapt it to the workbook I am currently working on?

#2
10-30-2022, 12:06 AM
 Pecoflyer Windows 10 Office 2021 Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,653

Have you also posted this on 5 other forums ?
A message to forum cross posters - Excelguru
Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
#3
10-31-2022, 11:54 AM
 ColtonYYZ Windows 11 Office 2021 Novice Join Date: Oct 2022 Posts: 4

This post is asking to define what's highlighted. My other posts that are all linked properly are asking for solutions on how to achieve what I need. And for the record, I thought it worked but it didn't. Further down the copy down, I found duplicates and errors. So I am back to square one.
#4
11-07-2022, 04:00 AM
 Debaser Windows 10 Office 2016 Competent Performer Join Date: Oct 2015 Location: UK Posts: 211

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

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post OTPM Excel 7 02-05-2018 07:16 AM Ylli Excel 10 12-13-2017 04:06 AM nfsmith Excel 6 03-19-2016 06:12 PM Will Excel 7 11-26-2014 05:27 PM Cosmo Excel 1 08-23-2012 11:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:53 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top