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

How do i make a list from this data?

So i have the following table, how do i quickly make a list of the totals with their paired value, so take this: and change it into this: So that i can then sort the list by the total and find out which value has the most points, the actually…
Kyle Mann
  • 17
  • 3
0
votes
2 answers

Auto-Extend Formula Range

I have the following formula: =IF(MAX(C2:F2)>0,COUNTIF(C2:F2,">1")/COUNT(C2:F2),0) This formula is located in the second column of a structured table, and goes through the rest of the columns in the table to the right. The formula basically tells…
Duck9139
  • 69
  • 10
0
votes
0 answers

Updating pivot source file to specific table source on workname change

I have already scoured the internet (eg. 1 2 3 ) for the answer, but all of them seem to provide a rather convoluted answer, which the users raised with specific conditions that are characteristic only to their own project, I intend this…
Samuel Hulla
  • 6,617
  • 7
  • 36
  • 70
0
votes
1 answer

MS Excel 2016 - Weekly Totals Click and Drag

I am trying to create a table that totals the number of hours for all weeks. I don't want the totals to appear on each 7th line but one after the other. The formula I am using is simple but when I use click and drag the autocomplete function is not…
Pete
  • 23
  • 2
  • 8
0
votes
2 answers

How to select data based on previous date in a excel table?

I have a MS Excel table named 'equity' with the below columns. Date Open Close PrevOpen PrevClose 18-Jul-18 99.8 101.9 19-Jul-18 100.7 102.1 20-Jul-18 101.2 103.7 23-Jul-18 102.1 99.8 24-Jul-18 101 …
Roy
  • 3
  • 4
0
votes
0 answers

Excel Drop-Down Menu with dynamic Content

I want to build a Drop-Down menu in my excle-table which automatic updates itsself if the original table gets additional content. e.g.: France Germany Italy is my reference table, name "countries". Normally i do my drop-down menus by selecting…
Falu
  • 1
  • 2
0
votes
0 answers

Excel: Interpreting cell value as a table name

I have a couple of different tables defined in Excel 2016 with identical layout, based on Name as the left-most key field. I am doing VLOOKUP against those tables based on the Name in a different table, which has FieldName and TableName columns,…
gt6989b
  • 4,125
  • 8
  • 46
  • 64
0
votes
1 answer

Loan Amortization Quarterly Payments

Has anyone got a loan amortization table in excel for loans with payments every four months? I need to calculate the payment amount for a loan that will pay three times a year 20 times
Eva
  • 5
  • 1
  • 5
0
votes
1 answer

Extract related data from one table to another

Here is my worksheet, it doesn't show up right in google docs so you may have to download: https://drive.google.com/open?id=1Im8RY_cokV2NBtkU9YwMhzkVWwUT_Gn_ I need to grab the data from the first table, format it a bit and enter it into the second…
aglasier
  • 43
  • 5
0
votes
3 answers

Issue with VLOOKUP when using a named range table

I am having an issue with getting excel to recognize the table in my VLOOKUP formula. This is the formula that I am trying to use to show the current quantity based on a selection from a dropdown list. =IFERROR(VLOOKUP(K7,inventory,3,0),"") Where…
Eddie Maiale
  • 23
  • 1
  • 5
0
votes
1 answer

Counting in groups

Consider the following table in Excel: status | order | attribute --------------------------- purchased| table | brown purchased| table | yellow purchased| table | purchased| sofa | purchased| sofa | green purchased| sofa | purchased| pillow|…
4lackof
  • 1,250
  • 14
  • 33
0
votes
0 answers

VBA sorting table in other workbook

Good morning, I have a macro that, among other things, sorts a table in another workbook. Here's the relevant bits of code Set wbLSHP = Workbooks("CDU_Enrollee Engagement Tracking Report v2.2.xlsx") Set wsLSHP = wbLSHP.Worksheets("Sheet1") …
Dustin Burns
  • 307
  • 4
  • 13
0
votes
2 answers

need to remove empty rows from Excel table and then resize the table - using VBA

I wrote a macro (mostly by recording it) that copies data from a section on one sheet then calculates the end of my table on another sheet and pastes (paste special, being that the data I am pasting is a formula and I need to paste the values) the…
zfeld
  • 38
  • 1
  • 4
0
votes
1 answer

div to 0 handling excel

So I have this issue, I have two tables one is employees, and another one is the projects. Employees Table: Year Name Type Jan Feb 2018 Kevin Salary 5000 2000 2018 Kevin Insurance 200 400 2018 Alex Salary 3000 4000 2018 Alex…
Kev
  • 3
  • 4
0
votes
0 answers

Excel VBA - Total Merges With Table When Deleting Selected Row in Table

i have an issue where deleting a selected row, deletes the row selected, but the "Total Row" merges with the table and I'm unable to do anything in the excel sheet and have to reset my progress. I was wondering if someone can take a look at my code…
MSauce
  • 123
  • 2
  • 13
1 2 3
…
21 22