-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
structured table
-
C
Returning a column within a Named Range or Structured Table array of a given value
Hello, thanks for looking I was hopping that my last post ( Structured Table Names for current row ) would have given me workable answer to this problem. I need to find in array (7*20+ x 25 rows) if a number or greater is a selected in a row. This done by checking the 1stcolumn in a set of 7...- Calgary_Neil
- Thread
- named arrays nth occurrence structured table
- Replies: 2
- Forum: Excel Questions
-
C
Structured Table Names for current row
I have a structured table called Prod_TechT that is in B82:IX106 that I what to count the Number of "Y"s in every seventh column in IW82..106. This worked =SUMPRODUCT(N(MOD(COLUMN($B82:IV82)-1,7)=0),N($B82:IV82="Y")), but I want to converted it to the structured names. i.e...- Calgary_Neil
- Thread
- every nth cell structured table sumproduct
- Replies: 5
- Forum: Excel Questions
-
P
Problem using indirect on structured table in array formula
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]-->PROBLEM USING INDIRECT ON STRUCTURED TABLE IN ARRAY FORMULA I use a template to extract data from an external source into a structured table. The name of the table is based...- Poenankie
- Thread
- array indirect structured references structured table
- Replies: 1
- Forum: Excel Questions
