0
votes
1answer
37 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
1
vote
0answers
17 views

Excel Table function

I got a Excel file. There is a formula, {=TABLE(C7,C5)}. I cannot find any table name from ribbon Name Manager, so I think there is no table. Then what is this formula doing ?
0
votes
1answer
40 views

How use Excel formula to add new row in table?

I'm using Excel 2013 on a Microsoft Surface 2 (which is an RT ARM machine). It's my understanding that the Surface 2/RT version of Office does not allow scripting or forms. I'm trying to create a ...
1
vote
1answer
38 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
2answers
174 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
3answers
81 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
1answer
42 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
1answer
43 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
1answer
43 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
0answers
141 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
0answers
269 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
0answers
108 views

Excel Combo box to filter a table column

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). When I select a team from the combo box, I want the ...
0
votes
0answers
32 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
3answers
852 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
1answer
143 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
0answers
68 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
2answers
361 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
2answers
525 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
1answer
472 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
2answers
3k 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
1answer
48 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
1answer
1k 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
2answers
71 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
1answer
688 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
1answer
2k 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
1answer
244 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
1answer
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
2answers
3k 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
1answer
121 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
1answer
31 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
2answers
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?
2
votes
3answers
4k 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
2answers
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
3answers
903 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
1answer
108 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
1answer
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 ...
7
votes
4answers
15k 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
1answer
242 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
5answers
4k 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 ...
5
votes
2answers
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
4answers
357 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
2answers
472 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
2answers
8k 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
2answers
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
3answers
4k 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
1answer
1k 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
3answers
4k 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
1answer
732 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
2answers
1k 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
2answers
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 ...