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

Banded Rows for Excel Table Design are Inconsistent When Sorted

I am tabling a lot of data and using Excel's "Format as Table" function to do so easily and quickly. Furthermore, I would like to sort the data from Newest to Oldest, because the data was not originally available that way. Long story short, I want…
Tom Crews
  • 135
  • 2
  • 12
0
votes
1 answer

Trim text after Bracket in excel

I would like to trim off the text which is after the bracket in the cell Value The current formula I'm using keeps giving me the error not being able to extract the targetted string. =LEFT([@[Name ]],FIND("(",[@[Name ]])) I want to go shopping…
Ajaxcbcb
  • 167
  • 2
  • 4
  • 14
0
votes
2 answers

Display a count for each unique value in a table column

How can I grab a count of each unique value from a table's column, plus the actual value, into another cell. Table 1's status column **status** ------ itemA itemA itemB itemC desired results into a single cell: Table 1 Status summary |2 itemA,…
FishyStacy
  • 1
  • 4
0
votes
1 answer

How to find (and edit) specific row with an Excel ListObject Table (former List)

Let us imagine that in ListObject table rows there are some strings or some patterns I would like to find, and if found I would like to format the entire row. My example may be a dump from a recordset via VBA and ACE OLEDB into an excel ListObject…
Jacek Kotowski
  • 620
  • 16
  • 49
-1
votes
1 answer

Loop table to change values in excel

I have a table in an excel spreadsheet. In this table I would like to go from columns AP2 : AW2 and run down the rows to the end of the table and perform 2 actions. One I would like to convert the cell values from text to number. Second I would…
Dan Kirchner
  • 45
  • 6
-1
votes
1 answer

Excel VBA - Scroll to first row under freeze frame

I have a table which I fill via VBA code and SQL. There is a freeze from at row 3 so that the table header doesn't scroll. After loading the data, my table is scrolled to the end of the table. How do I scroll back up to the first row of the table…
mchernecki
  • 29
  • 7
-1
votes
1 answer

How to add a Table to Excel Worksheet using openpyxl

I'm trying to add a table to an Excel worksheet using openpyxl. I know how to add a dataframe to a Worksheet, and it works great. Here's my sample code: import pandas as pd from openpyxl import Workbook from openpyxl.utils.dataframe import…
Barranka
  • 20,547
  • 13
  • 65
  • 83
-1
votes
1 answer

Excel Formatted Table Sync with Range Data for Powe BI

I am working on link up Power BI and Excel. As far as I know, Power BI can only link data from Excel via formatted table. I have Excel range data, thinking of to create another formatted table that link to the Excel range data. How can I dynamically…
James
  • 33
  • 6
-1
votes
1 answer

Macro in workbook fails when other workbooks are open - Runtime Error 1004

Macro works fine when it is the only workbook open, but when any other workbook is open it fails. I am sure this is an easy fix but I can't figure it out. Thank you in advance. Sub Sort_Leaders() Dim wb As Workbook: Set wb =…
kwmoore1218
  • 15
  • 1
-1
votes
1 answer

EXCEL - Compare two tables and fill one if matching data

I would like to get help because I need to improve table data by matching two tables. Each table are on separated sheet. The first table (sheet 1) looks like this : I have "SIRET number" (id), "Nom du vendeur" (column which need to be filled with…
Essex
  • 6,042
  • 11
  • 67
  • 139
-1
votes
1 answer

Python DataFrame, editing values in columns

Currently I have a data frame that looks like this below: name value position length table 5.0 1234567 .25 chair 8.0 789012 5 couch 6.0 345678 5 bed 5.3 1901234 .05 what I need to do is first edit the position column by adding a…
rcheeks23
  • 15
  • 5
-1
votes
1 answer

Implementing a 'tag'-like filter for a column in an Excel table?

I have a column in an excel table that may contain values such as: 5 7,1,8 3,5 ALL I want to implement a macro that can filter for these values, such that if I filter for "5", the first and third results come up. Also, I included the ALL in the…
Gary Z
  • 97
  • 1
  • 9
-1
votes
1 answer

How to combine multiple columns from a table

My issue is the following: I have a table where I have multiple columns that have date and values but represent different things. Here is an example for my headers: I Customer name I Type of Service I Payment 1 date I Payment 1 amount I Payment 2…
Milen Metev
  • 1
-1
votes
1 answer

Add value in a table even if the table changes location in the sheet

I have a table below another table. If I add a lot of values in the first table, the second table will change cells and go further below. Sub Macro4() Range("Table2[Work]").Select Selection.ListObject.ListRows.Add (1) Range("A24").Value…
Chadi N
  • 439
  • 3
  • 13
-1
votes
1 answer

Excel populate table from same workbook

I have a table on Sheet1. I want to pull in data into this table based on entry in another tab. For example, I have a table based on information in other tabs, I want to populate the Score column. Can this be accomplished using SQL query or…
S Tom
  • 33
  • 1
  • 3
1 2 3
…
21
22