Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2022, 11:39 AM
ColtonYYZ ColtonYYZ is offline Explanation Needed With Formula Please? Windows 11 Explanation Needed With Formula Please? Office 2021
Novice
Explanation Needed With Formula Please?
 
Join Date: Oct 2022
Posts: 4
ColtonYYZ is on a distinguished road
Default Explanation Needed With Formula Please?

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?



Please and thank you!
Reply With Quote
  #2  
Old 10-30-2022, 12:06 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Explanation Needed With Formula Please? Windows 10 Explanation Needed With Formula Please? Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,653
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default

Have you also posted this on 5 other forums ?
Then please add links as cross posting etiquette requires
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
Reply With Quote
  #3  
Old 10-31-2022, 11:54 AM
ColtonYYZ ColtonYYZ is offline Explanation Needed With Formula Please? Windows 11 Explanation Needed With Formula Please? Office 2021
Novice
Explanation Needed With Formula Please?
 
Join Date: Oct 2022
Posts: 4
ColtonYYZ is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 11-07-2022, 04:00 AM
Debaser's Avatar
Debaser Debaser is offline Explanation Needed With Formula Please? Windows 10 Explanation Needed With Formula Please? Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 211
Debaser will become famous soon enough
Default

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.
Reply With Quote
Reply

Tags
formula help, index, quotient

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Explanation Needed With Formula Please? 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
Explanation Needed With Formula Please? hard formula needed nfsmith Excel 6 03-19-2016 06:12 PM
Explanation Needed With Formula Please? Explanation for this formula Will Excel 7 11-26-2014 05:27 PM
Explanation Needed With Formula Please? Formula help needed 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft