I am trying to adopt formulas from one workbook (Rolling Averages) to a second workbook (Sample) but I am not getting the same results. Somebody Please tell me what I am not doing correctly.
I would like cells DC5:DG5 in the ‘Sample’ Workbook to have the same content as cells O8:S8 in the ‘Rolling Averages’ workbook.
Attached are the two sheets.Rolling Averages.xlsx
Sample.xlsxSample.xlsx
Are you looking for sample.xlsx to be a stand alone document in its own right or to reference Rolling Averages data?
If someone has helped you then please add to their Reputation
It should be a standalone.
It has all the data required to generate the desired results in columns D to K
But the positioning should not be altered.
Looks to me like the formula for the helper columns is off by a factor of two. There would seem to be a couple, at least, of ways to rectify that situation, however in the following modification to that formula, I changed the constant -4 to -2:In the attached copy of the 'Sample' file the resulting values in DC5:DG24 seem to match those of the 'Rolling Averages' file.Formula:
=IFERROR(INDEX(ROW($D$4:$D$75),LARGE(IF((($CT5=$F$4:$F$75)+($CT5=$I$4:$I$75)),ROW($D$4:$D$75)-ROW($D$4)-2,""),$AD$29-COLUMNS($D:D)+1)),"")
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks