# Tagged Questions

**1**

vote

**1**answer

19 views

### Unable to format datetime in Excel Table

I have an Excel document with a table linked to a table in sql server containing a datetime field. The datetimes display as yyyy-mm-dd hh:mm:ss.sss and I'm unable to format the cells directly to a ...

**1**

vote

**2**answers

51 views

### Excel Lookup adds double quotes to string

I'm using this formula to get value form a table
=LOOKUP(C11;Alias[A];Alias[B])
where C11 = 12354567
But when I use
=LOOKUP(LEFT(C11,7);Alias[A];Alias[B])
where C11 = 12345678, the formula does ...

**0**

votes

**3**answers

53 views

### How to use =VLOOKUP under these circumstances?

So I know how to use =VLOOKUP when you are searching for a single value within a cell, but I'm not sure how to do it when I have a range, ex. say the cells value is 1-5, the next is 5-10.
This is ...

**0**

votes

**1**answer

15 views

### How to refer to a 'related' table in another excel table?

I have created two related tables (tableA and tableB) in excel and linked them using 'Relationships' in Excel 2013. I'm trying to create a new formula field in tableB that refers to two cells from a ...

**0**

votes

**1**answer

18 views

### Excel 2010 - Use a Variable in a structured Table Reference?

I have several tables of financial forecasts (Revenue, Cost, Staff, etc). Each forecast has a unique name (FY14-1, FY14-2, etc.) I would like to use a variable in a structured table reference to get ...

**0**

votes

**1**answer

19 views

### Formula error message when adding new rows to tables in Excel

I always use tables when working with Excel, but recently I’ve run into a strange new issue. I'm assuming it's just a bug and I'll need to reinstall but this issue is on my work system and that will ...

**-1**

votes

**1**answer

34 views

### Rearranging spreadsheet data

If I have the following data table:
Country 1990 2000 2010 LEB 1990 LEB 2000 LEB 2010
Afghanistan 15 17.72 18.24 48.60 54.86 59.61
...
How would I in an automated ...

**0**

votes

**0**answers

90 views

### Link table in Destination Workbook to table Source Workbook in Excel

I have two workbooks, which work as follows:
The source workbook has a table where the values are inserted or updated;
The destination workbook has a table linked to the source table.
I came up ...

**0**

votes

**0**answers

150 views

### “Reference is not valid” error when refreshing pivot table

I have a .xlsm file on a network drive (source.xlsm for example) with a table that serves as the source for pivot tables that live on various other files (localfile.xlsm for this example).
When I try ...

**0**

votes

**0**answers

67 views

### Excel Combo box to filter a table column

I have a table that I want to filter a column of 'team names' (D10 is the column header) using a combo box (which has a list of the 10 team names from another sheet).
So, when I select a different ...

**0**

votes

**0**answers

28 views

### Select column without cell adjacent in Excel for Mac

I want to select the entire column to the left without the cell adjacent to the left to run a fuzzy-lookup. Of course I'd like to make that expandable, so I don't have to make it by hand. Here is the ...

**0**

votes

**2**answers

123 views

### Newly inserted rows in a table do not get properly formatted

I am using Excel 2013. I have a table (not just a cell range, but a full table with table name, etc.). I have applied striped formatting to it. When I add new blank rows to the end of the table, they ...

**0**

votes

**1**answer

64 views

### Unable to sort selected cells within the Table in Excel 2013

I created a Table in Excel 2013 but I want to sort only selected cells. The table range is A1:I200 but I only want to sort A150:I200. I tried selecting the cells, right click, sort, it sorted the ...

**0**

votes

**0**answers

51 views

### Excel or OpenOffice Table Summary: how to reconstruct a table from another, with “missing” values

I have a table of values (partial) with 3 columns: month (from 1 to 12), code and value. E.g.,
MONTH | CODE | VALUE
1 | aaa | 111
1 | bbb | 222
1 | ccc | 333
2 | aaa | 1111
2 ...

**1**

vote

**2**answers

199 views

### Cumulative average using data from multiple rows in an excel table

I am trying to calculate a cumulative average column on a table I'm making in excel. I use the totals row for the ending cumulative average, but I would like to add a column that gives a cumulative ...

**5**

votes

**2**answers

193 views

### How to convert embedded excel sheet to word table?

We receive word documents from clients that will sometime contains Embedded Excel Object(sheet) and we need to convert them to word table so that we can then import the documents in InDesign properly.
...

**-2**

votes

**1**answer

264 views

### Merging data tables to form one master table

I have multiple sheets containing a table each which I want to merge to form a master table sheet. I also need this master sheet to be updated automatically incase we make any changes to the tables ...

**1**

vote

**2**answers

995 views

### Excel VLOOKUP by second column using table name as range

Using the example table below, I can use the formula =VLOOKUP("ABC123456",Table1,3,FALSE) to lookup the Demand value, but I want to do be able to perform the lookup by using the Cust Part field ...

**0**

votes

**1**answer

46 views

### Excel Date Manipulation Function

I have an excel table that contains start times and end times and the added hours. Here is what it looks like
***********************************
* Start Time ** End Time ** Hours *
...

**1**

vote

**1**answer

586 views

### PivotTable — how to sum the result of a countif formula by group?

Current Setup
A table (Table1) that has the following fields:
Organization Name
Person Name
Several fields that users can put an "X" into (each represents a "module" that users would need access ...

**0**

votes

**2**answers

66 views

### Excel - Divide informations

I have an excel file with several rows (about 1k).
Each row describe some action of one user and (my bad) for differents actions there are differents rows. Something like this
action ...

**0**

votes

**1**answer

434 views

### Formula to copy a specific character from one cell to another

I am using MS query to pull in data. I need to create a column that copies the first character in another column. For example:
Cell A1 - E00633
Cell A2 - B00842
Cell B1 - I want this cell to ...

**2**

votes

**1**answer

1k views

### Export Office Excel table to csv using a macro

I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv.
My current workflow:
1. Select table manually
2. Copy the contents into a new workbook
...

**0**

votes

**1**answer

171 views

### Can I force MS Excel table column to use the specified pattern?

I need to develop a tool that enforces strict format of some table. The fields in this table follow specified patterns like number:number (11:20. 2:00), agreed date (11/20/2012 but not ...

**0**

votes

**1**answer

2k views

### How to extract unique data from cells in a single column with thousands of similar values?

I have a single column in an Excel sheet with around 25,000 cells (numbers). Most of them are identical that in the end there are only - I guess - maybe 200 different numbers.
Is there a way to ...

**1**

vote

**2**answers

2k views

### How to copy an unformatted table into excel?

I want to copy the following table http://www.fifa.com/mm/document/classic/awards/01/36/25/40/ballondor_award_men_player_finalx.pdf into excel but when I do it doesn't format it as a table as the ...

**3**

votes

**1**answer

111 views

### Excel file links through SharePoint

I'm working for a small company which manages it's knowledge throughout Excel files.
Some of the files contain data from other files, for example our orders file contains products that are saved in ...

**0**

votes

**1**answer

30 views

### Excel Statistical Table

I am trying to create a statistical table based on columns of information. The row/column identifiers of the table are also incorporated in part of the statistics of the table. I have three columns of ...

**0**

votes

**2**answers

47 views

### getting data from several columns in a record

I have excel sheet contains the following table:
I want to get the last recent DATE with its LAB Result?

**1**

vote

**3**answers

3k views

### Excel 2010: How can I obtain a one-to-many rows table by merging duplicated cells in a large normalized table?

As I am a newbie when it comes to Excel (and the entire Microsoft Office suite, to be honest), I spent a lot of time browsing for a solution to this issue - how to get a one-to-many rows table out of ...

**1**

vote

**2**answers

1k views

### How do I group rows in a table by one column's value in Excel?

I have a table of data (5000+ rows) with two columns, ID and value.
It may look like this:
ID Value
01 02
01 03
01 17
02 05
03 06
03 28
What I want to do is find the average value for each ID. ...

**0**

votes

**3**answers

763 views

### Excel 2010: Do sortable tables support sorting within multiple columns?

In Excel 2010 (and perhaps recent versions), you can select a range of data and insert a table over it that adds user-friendly sorting capabilities to the data. However, it appears that it doesn't ...

**0**

votes

**1**answer

107 views

### Extracting Excel-published tables from a PDF document

I'd like to copy Tables 1,2, and 3 found at the bottom of this PDF file:
http://www.cbo.gov/sites/default/files/cbofiles/attachments/03-13-Coverage%20Estimates.pdf
into Excel. I've tried Copy+Paste ...

**1**

vote

**1**answer

2k views

### Use Excel Table Column in ComboBox Input Range property

I asked this in StackOverflow and was redirected here. Apologies for redundancy.
I have an Excel worksheet with a combo box on Sheet1 that is populated via its Input Range property from a Dynamic ...

**4**

votes

**3**answers

10k views

### Excel table - delete rows not in filter

i have a very large table in excel (1000's of rows) and i filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown [ ie dont meet filter conditions]? this would enable ...

**0**

votes

**1**answer

191 views

### Prompt to select excel spreadsheets in Access?

I have a Microsoft Access 2007 database that uses excel spreadsheets to track changes between the two. A new file is generated every week. I then do a compare against the two of them with some custom ...

**2**

votes

**5**answers

3k views

### How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?

Consider a table of employee name, age and employee manager. Employee manager is a reference to employee name in same table but different row. I tried this by referencing cell =A3
Now if I sort ...

**4**

votes

**2**answers

2k views

### How to paste table from MS Excel to Wolfram Mathematica?

When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica.
How to have a ...

**0**

votes

**4**answers

321 views

### What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns.
I want to manually update and add to the information within this table on a frequent basis.
Would exporting the ...

**1**

vote

**2**answers

414 views

### Filter and reorder columns in Excel

I've got a service (phplist, a newsletter manager) that exports a user list with several fields. At the end of it, each user has one or more lists to which he has subscribed.
The problem is, that ...

**1**

vote

**2**answers

7k views

### Excel: text values in a pivot table?

I have a table (in MySQL) with 3 columns:
Location Category Supplier
A Computers Company X
A Printers Company Y
B Computers Company X
B ...

**0**

votes

**2**answers

2k views

### PowerPoint 2007: Setting custom cell margins causes text to display as if centered

I'm using PowerPoint 2007 and have pasted in a table from Excel 2007. When I paste it in it automatically becomes a PowerPoint table, and looks fine. However, everything is quite squashed together, so ...

**0**

votes

**3**answers

3k views

### Dates not recognized as dates in pivot table pulling directly from SQL Server

My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is ...

**0**

votes

**1**answer

891 views

### Is is possible to apply separate formatting to multiple different Excel table columns?

I have some calculated columns in an Excel (2007) table. I'd like to distinguish them visually from the user-input columns in some way, but without losing the nifty automatic row banding. It looks ...

**0**

votes

**3**answers

3k views

### How to use excel to disply a list of cells, depending on dropdown box selection

What I want to achieve:
select list A, B or C from a dropdown, when pressed, list of values displays underneath. I would also like the list to be populated from items in a table (which would have ...

**2**

votes

**1**answer

648 views

### Exporting a subset of an Excel sheet as a (clean) HTML tab

I have an Excel sheet with several sheets and containing quite a few tables of information which are really intended to be published on a common wiki at my company. Previously, we used to use ...

**1**

vote

**2**answers

874 views

### Is there a way to give an Excel table a name that is worksheet-scoped instead of workbook-scoped?

When you create a table in Excel (I'm using Excel 2007) you can give it a name that shows up in the Name Manager dialog. However, the name has workbook scope. I'd like to have a table with a name ...

**2**

votes

**2**answers

2k views

### Excel: lock sheet, but keep tables expandable

My goal is to protect a sheet, but make users able to edit and add rows to the contained tables.
When I try to protect the sheet with no cells locked, the tables become unable to add rows even though ...

**10**

votes

**6**answers

25k views

### Table Formatting in Excel 2007: How do I remove it?

I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it ...

**1**

vote

**1**answer

284 views

### long table in excel - how to produce stats for subtables?

(new to excel - ) say I have a table with columns A = {1..5}, B = {a..e} and Score = Number. I want to produce a new table that would display statistics for each A,B combination, e.g.
A B Mean ...