-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
table array
-
F
dynamic table
hi, in sheet1 I have source table: <tbody> Car Year Color Type Audi 2000 Red Sport BMW 2001 Black Coupe Volvo 1998 Yellow Combi VW 1996 Black - Fiat 2003 Red Family </tbody> Then in sheet2 in A1 I will be selecting car name (Audi, BMW etc). Now if I choose "Audi" I want to in...- Forestq
- Thread
- dynamic table table table array table design table formula
- Replies: 1
- Forum: Excel Questions
-
R
TABLE - Array formula slowing down save process
Hi everyone I have had a table array formula set up for many years in my main spreadsheet. I also always have my xls set up with "automatic except tables", so the tables only calculate when I want them to, or when I save. A few weeks ago I added several (60-ish) columns to a different tab...- Rho77
- Thread
- 2010 array formula slow excel table array
- Replies: 5
- Forum: Excel Questions
-
D
formula required
Hi all I need a formula that can recognise the common demonators below and then add based on this common demonator. Please see the below - the bolded numbers are where i need the formala. Basically its to recognse where a and b are in the top table and then add the numbers in the second table...- deck-b
- Thread
- index match sumif sumifs table array
- Replies: 1
- Forum: Excel Questions
-
J
VLOOKUP when Table Array Changes
Hi, I'm new here, and I have a question regarding a problem I ran into today, at work. I am basically using the VLOOKUP function in a sheet (sheet1), to pull out data from another sheet(sheet2). But on a regular basis, the Table Array from sheet2 is changed, because the data from sheet2 is...- jb007
- Thread
- relative reference table array vlookup
- Replies: 9
- Forum: Excel Questions
-
T
VBA Summarize data based on information in table
Hi all= I wonder if anyone has a slick solution for this problem. I have information in a table that corresponds to data in an excel file. I need help with some code that will use the information listed in the table to summarize the data in the excel file and drop the output in a new sheet. I...- talt0612
- Thread
- table table array vba
- Replies: 0
- Forum: Excel Questions
-
J
IF Formula, Excel 2010, Choosing in table only those items that are present on another table/list
I have established two tables: the first being records over a long period of time(lets call it "AllTime"), including names; the second being only the names of current employees (lets call it "Current"). I am trying to establish an equation in a column of the "All-Time" table where if an employee...- jakup5031
- Thread
- if formula help lookup functions table array table look up
- Replies: 2
- Forum: Excel Questions
-
C
When VLOOKUP returns #N/A when there IS AN EXACT MATCH
When: -VLOOKUP fails to recognize your exact data match within the table array, and returns #N/A. I originally called this post VLOOKUP IS BLIND!!!! As I was writing the post asking for help I came up with the clever solution :rolleyes:! Here it is! Copy your data into Notepad and then...- cgifford
- Thread
- #n/a column index number table array vlookup vlookup fails
- Replies: 3
- Forum: Excel Questions
