Solved

Why are the formulas in cells CL16: CQ21 not working as the formulas in cells CL10:CQ15

Posted on 2014-07-25
5
135 Views
Last Modified: 2014-07-25
I adjusted the formulas in cells CL16:CQ 21, but they are not working as the formulas used in CL10:CQ15.
I guess I don's understand completely how the formulas work.
I made shre I pressed the Ctl>Alt.Enter buttons to create an array.
Root-Cause-Analysis-Ver-31-development.x
0
Comment
Question by:cssc1
  • 3
  • 2
5 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 40219690
Can you shorten the name of the attached file?  It cuts of the lsx from the .xlsx and doesn't allow us (me anyway) to open it.
0
 

Author Comment

by:cssc1
ID: 40219723
so sorry.

Plese see attachment
rc.xlsm
0
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 40219753
Formula in CL16 should be:

=IFERROR(ADDRESS(16,6+SMALL(IF($G$16:$M$16<>"",COLUMN($G$16:$M$16)-COLUMN($G$16)+1),ROW()-15)),"")

CSE confirmed and copied down.

It looks like you were using the whole subtable range instead of row by row range... also need to offset 6 cells not 7 to start at G.
0
 

Author Comment

by:cssc1
ID: 40219883
Thanks.
I see where I went wrong.
Thanks again
0
 

Author Closing Comment

by:cssc1
ID: 40219885
Thanks

now I see what you mean.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now