Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 221
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
 

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 02:16 PM.


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