table name

Bye all, I would like to add the query name as a column name in my Power Query. For example, the query name is "Cost1", so I would then like to have a column cell with the data "Cost1" at each row. Or is there any way to add the table name as the column name Is there any particular formula I...

Couldn't find a built in formula to do this, and didn't want to write VBA. So found a way to get the name of a table in Excel. It's a little clunky and I'm hoping for a cleaner solution,but here it is. Used three functions: MID, FORMULATEXT, and INDEX. Have a table with name tblHarry 1...

Hi guys, Would like to search value using vlookup and indirect function through by sheet name and table name? Plus, in every sheet has different table names in different arrays. Can you help me? Thanks guys.

Hi, I have a sheet which contains a list of many tables. Each Table is for a set, Table1 > Set 1 Table2 > Set 2 Table3 > Set 3 ....... Table99 > Set 99 Each set contains its own list of items and the qty of each item (column[Model#] and column[Qty]) . And at the end, each set has a qty for...

Dear Excel Experts I may be asking a question for something that cannot be done. Nevertheless, I thought there is no harm asking. Is there a way to retrieve the name of the listobject/table which is located in, for example, cell A5 without the use of VBA? Thanks Maria

Hi All, This is my first post so please be patient. I have simplified what I want to achieve in the following example using kids building blocks of different sizes. First I have a reference table called BlockTypes <tbody> Block Size A 1 B 1 C 2 </tbody> I then have a table that...

Hi Does anyone know how to use dynamic reference as part of a table name. So If I have 10 tables called... Revenue_WK1 Revenue_WK2 ... Revenue_WK10 Can I then select the relevant Table using =SUMIF(Rev_WK10[ITEM],"11*",Alacer!D:D) where the _WK10 part of the table name is dynamically...

Hi, Hopefully you can help? I am trying to create a dynamic reference in a table name using.. =SUMIF((CONCATENATE("rev_"&E2))[ITEM],"11*",Alacer!F:F) E2 = wk12 Table name = rev_wk12 I am trying to reference the table name by concatenating the name and then addressing column...

Hello, Any ideas on how to capture the name of a table in a variable? To add a table, we use the following code (recorded it) : ActiveSheet.ListObjects.Add(xlSrcRange, Range("$D$4:$J$16"), , xlNo).Name = "Table1" I need to refer to a table from a sheet that gets updated periodically but...