Solved

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

Posted on 2014-07-25
5
140 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to line 23 53
Batch Numbering 6 30
Pivot a table with 3 coulmns with two layers of header columns 3 33
combine fist two words in a cell 2 23
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

809 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