Stack Overflow
Stack Overflow

Questions tagged [excel-tables]

Questions dealing with structured (aka ListObject) tables in Excel-Formula and Excel-VBA. Should be reserved for questions involving the special syntax of Structured Table References.

Questions dealing with structured (aka ListObject) tables in Excel-Formula and Excel-VBA. Should be reserved for questions involving the special syntax of Structured Table References.

324 questions
0
votes
0 answers

VB.NET Extract Excel Tables from received email body

I receive everyday an email which contains some excel tables (about 10rowsx10columns each) and I would like to have them empty keeping formats and labels intact (just erasing cell contents) and store the empty tables in a variable , or a List(Of) in…
sickboy
  • 11
  • 3
0
votes
1 answer

Update excel table using power automate

I am using power automate to add a row to a table on excel File located in share point using data from a query in azure dev ops. It works fine, it adds the data. However, I need to find a way to refresh the table and delete the previews rows and…
Slandaverde12
  • 1
0
votes
0 answers

Pivot table consisting data from three separate tables

I have three tables with a very similar layout, where i would like a pivot table to present the data in a certain way and i'm wondering if it is possible. Each table starts with a column for participent name, followed by 3 columns with different…
Clocked
  • 9
  • 2
0
votes
2 answers

Excel Replace Text via Another Ranges

In column A i have a long text, containing substrings that you can find on another range (column D). I want to search for the substring and if I find it then replace it with the value in column E. Any help will be much appreciated.
Kobe2424
  • 147
  • 7
0
votes
2 answers

In Excel, How would I attach, or concatenate single attributes together when there are multiple

I want to attach each attribute to a "name" in a single row. each row could have one or many attributes. If there are more than one attributes, I want to create a new line with the 2nd, 3rd, or 4th attributes attached to the names in the first…
user3887901
  • 3
  • 3
0
votes
0 answers

Pivot Table/Chart

I have a large spreadsheet with multiple columns. I need to create a pivot table/chart to show the difference in the "Prev RFS Month" to the "New RFS month" Counts, so I have a column with the count per month of "Prev Month" and a column with the…
chasedward
  • 1
0
votes
1 answer

Excel function not showing result after loaded through power query

My power query loads a CSV file in my Excel workbook as table. The CSV file has values like the following: =HYPERLINK("https://www.example.com/";"This is an URL.") The issue with that is, that those values are shown exactly this way in the cells of…
cec
  • 1
  • 2
0
votes
2 answers

Excel: Automatically Bring Column Data From One Table into Other Tables

I have multiple sheets in a excel document. The first sheet I have is called "Companies" which has a table called "Watchlist". That table contains a list of companies with some basic data concerning those companies. So, for example: * Ticker…
Moshe
  • 6,011
  • 16
  • 60
  • 112
0
votes
0 answers

how to format several cell ranges at once in excel?

I have several of these "tables" (not actually a table format) spanning over 900 rows, is there anyway I could delete/add rows and apply these changes to all of them? Also, if there are formulas for each of the cells, would the formulas transfer…
Critical Core
  • 1
0
votes
0 answers

Using pyodbc to query Excel table (not a named range)

I am looking for a way to query an Excel table (https://support.microsoft.com/en-us/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c) using pyodbc. As a test I created an Excel file with some named ranges and an Excel table: I…
Ondrej
  • 43
  • 3
0
votes
2 answers

How to set the Number Format of a totals Row in an Excel Table with VBA?

I have a vba that shows a totals row and sets specific columns to average. I want to set the number format of the totals row to be "0.00", but sometimes there are more or less rows, so I can't just select a specific range. I tried using…
Chelsea Ziss
  • 27
  • 4
0
votes
0 answers

Replace the "@" for reference a row of a table with another "kind" of reference to that row

I want, if possible, to replace the "@" in the formula: =SUM(COUNTIFS(MyTable[@[a1]:[a6]],"B",Cond2,"S"), COUNTIFS(MyTable[@[a1]:[a6]],"A",Cond1,"<>0")) which it counts the cells of "MyTable" that fulfill some conditions that are found above…
mpolenis
  • 1
  • 2
0
votes
0 answers

Excel-Table named like Worksheet-Function overwrites it

I have a table in my Excel-Workbook named "Year". Using the formula =YEAR(A1) returns an reference error. Excel thinks I want to reference the table "Year" instead of the function. The table overwrites the built-in function YEAR . Does somebody…
hendrik
  • 11
  • 2
0
votes
2 answers

MS Excel: change a tables reference to point to a new table

I have an Excel workbook containing an "old" table which is referenced all over the place in thousands of formulas. I want to replace this "old" table with a "new", already exisiting table. All the formulas should therefore reference this "new"…
baby blizzard
  • 1
0
votes
0 answers

Excel: Fill rows In table with data from another table Column depending on previous cell value

Any help appreciated, I'm fairly sure this is not possible without VBA as I want to spill information from one table into another. In Table 1 I have a dropdown list in column 1 that references column 1 from table 2. when selected i'd like column 2…
Chumbawamba
  • 121
  • 2
  • 11
1 2 3
…
21 22