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
1 answer

Get Data from UserForm into existin Table in Excel

I have a problem, I'm trying to add data from userform into existing Table which contains different formulas (Table 1) but I do not know how to insert that in the code. Here is the code: (And the sheet where the table is, is Sheet1.) Private Sub…
Camelia4
  • 1
  • 2
0
votes
1 answer

Refresh all does refresh the connections but doesn't refresh the tables

I have three tables which pull data from SQL database. When I click refresh all from the data menu, the connections refresh but only sum of the tables are refreshed. When I right-click>refresh the tables themselves, they reflect the correct…
user12447772
  • 1
0
votes
1 answer

how to sum values in a table with multiple criterias

I need your help with an excel formula. I want to sum values of a table based on criterias in the first row and the first column e.g. row-criteria="z" and column-criteria="1": for those criterias the solution is 3.69…
André K
  • 1
0
votes
0 answers

Looking to import filter criteria from an excel table

I am looking to import the list of unique value (the one in the filter menu of a table) in a vba code. Is it something possible? I know the autofilter method, but i can't find a way to import that list. I've tried to use the autofilter function, but…
phill_24
  • 1
  • 1
0
votes
0 answers

Autofilter to copy & paste multiple unique values

I'm trying to filter an Excel Table using VBA for unqiue values. I first filter for a specific date, then I try to obtain unique values in columns L, H and Q. My approach detailed below works properly only for column L. When I copy and paste unique…
Josh
  • 3,231
  • 8
  • 37
  • 58
0
votes
1 answer

Excel how to transform a table to be used for pivot: use the column headers in a field

I have a table in Excel that is filled as below PROD JAN-19 FEB-19 ... ... product1 123 098 ... ... product2 314 467 ... ... I would need to use the data in a pivot table so I suppose I…
Donats
  • 19
  • 4
0
votes
2 answers

Excel macro that changes all populated cells to value instead of formula

at the moment I have a large table with formulas in every single cell that helps me track weekly percentage change of a parameter. They way I update this every week is I manually "Copy" & "Paste Value" on the last populated cell. I am looking for a…
Dodo
  • 55
  • 10
0
votes
2 answers

Get slicer selection of a data table

I have been struggling with this issue in the past days and haven't found yet any solution. I have a simple table (not a pivot table) and some slicers attached to it. I want to 'simply' show selected value/values of the slicer in a cell. It implies…
Takichiii
  • 453
  • 4
  • 14
  • 27
0
votes
3 answers

Table Auto-Expand Changes Formula Range

The attached image is a table in a workbook I'm working out of. It's pretty self explanatory if you read the column headers. The Week number has a simple count formula to count the number of Week Ending dates in the range from the top of the data to…
Duck9139
  • 69
  • 10
0
votes
1 answer

How to create a bar chart from an excel file into R?

I am new to the R software and playing with a different dataset. But recently I am facing a problem in creating Barplots where I do not have the original dataset but have the outcome e.g. percentage, frequency of that dataset of different…
Shakil Ahmed Shaon
  • 109
  • 1
  • 10
0
votes
0 answers

How to reduce an excel table to non empty rows with VBA

I have the following code which reduces the table to the header + 1 row. This is great if the table is empty, but I also want to use it if there is data in the table. In this case I would want to reduce the table to the row of the last data…
DAve
  • 27
  • 5
0
votes
1 answer

How to use comparison operators within a SumIfs formula using structured table references

I am trying to use the SUMIFS function to sum all entries in a table that fall between the date ranges specified in another table. I cannot get the comparison operators (">=" or "<") to work. Every variation I make results in an incorrect sum of 0.…
user6828404
  • 1
  • 2
0
votes
1 answer

EXCEL TABLE: Find Value based on Latest Date in Column from Multiple Criteria

I am trying to work out how to get a value from a column in an Excel (Office 365) Table based on the latest date from another column which is selected based on multiple criteria. I have written the formula to get the latest date, now i need to get…
ccocker
  • 1,146
  • 5
  • 15
  • 39
0
votes
1 answer

Populating ActiveX comboboxes with distinct values

My issue is that I want to populate an ActiveX control combobox with a specific name, List_Funds as I renamed it. The population is based on a specific column in a table I have generated in my workbook called Table_Funds. I want the combobox to only…
BlackBear
  • 385
  • 1
  • 5
  • 25
0
votes
0 answers

Excel Array Formula's referencing Excel Tables

I have trying to write a formulae that will look up values in an excel table and return the result based on a cell in another worksheet. This formulae works but i have one of the criteria hardcoded i.e confidence >=.50 and i want to make it…
ccocker
  • 1,146
  • 5
  • 15
  • 39
1 2 3
…
21 22