Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

3
votes
3answers
2k views

How to fill in missing dates in chart

I'm looking for a simple way to chart a list of values each correlating to a date. For example: Date Value 11/7/13 2 11/8/13 2 11/11/13 3 11/14/13 2 Etc. The problem is, the chart does ...
0
votes
1answer
265 views

Cant edit excel file in Sharepoint because it has Comments, Shapes, or other objects

I have an excel sheet in a Sharepoint which is no longer editable in browser because Sharepoint complains that there are "Comments, Shapes, or other objects" and that is apparently not supported. I'm ...
0
votes
1answer
64 views

Edit current cell via keyboard?

In Excel for Macintosh 2011, when the cursor is in a particular cell of a spreadsheet and you wish for the focus to move to the edit line for that cell where the formula is displayed, is there a ...
1
vote
1answer
34 views

Can you insert a formula into the tab of a worksheet?

I am creating a worksheet that will gather all of its displayed information from a database produced Excel file. This data will include a property name that I want to display on the tab. Is it ...
1
vote
2answers
3k views

Excel tries “Accessing Printer” while opening specific workbook

Excel 2010 (Windows 7 Professional 64-bit) is loading a specific Excel file to 100%, then the status message on the splash screen rotates between "Opening (100%)" and "Accessing Printer". It sits and ...
0
votes
1answer
190 views

Formula to find items in Excel and determine total quantity of each item

I have a steel cut list in Excel. There are over 1000 rows of information and probably 100 different part numbers. Is there a formula that can find the total quantity for each part number? I am ...
0
votes
0answers
14 views

Collating information on two seperate sheets

I have on one sheet (1) two columns: A: Names B: Costs I have on another sheet (2) one column A: Names I want to take the name from Sheet 2 and match it to column A in sheet 1 and have the costs ...
0
votes
0answers
27 views

Displaying images from database in a pivot table

I've got a table with sales data on MySql server. I can connect to it from Excel and generate a pivot table just fine. One of the fields in the table contains URL to an image of a product. Is there a ...
-1
votes
1answer
31 views

Does Excel have the feature to create views similar to Database views?

From Wikipedia: In database theory, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object. ...
-1
votes
1answer
72 views

Dice notation for excel

same question as : http://stackoverflow.com/questions/24260344/dice-notation-in-excel-advanced-mode I was advised to ask here too. so i do. I asked if someone could make me a "User Defined Function" ...
0
votes
1answer
37 views

Find lowest value in a row and switch to column name?

I cant figure out a way to do this, Ex: a b c d e p1 p2 p3 a 132 354 475 p1 b 654 355 476 p2 c 789 356 ...
-5
votes
2answers
1k views

How do I convert a .csv file to a database?

I have an 8GB .csv file with 6 columns and 202,176,000 rows. How would I convert that to an OpenOffice database(.db) file?
0
votes
1answer
60 views

Obtaining Frequency of A Number for Each Sub-Heading

I have two columns, one with people and times associated with those people, and one filled with 0s and 1s. For any given person there is some associated combination of 0s and 1s. We can determine ...
1
vote
3answers
106 views

How can I have a cell flash green or red dpending on whether the updated value is higher, or lower? - In Excel

I am running an excel spreadsheet. Some of the values are being fed in from an external source. In this case, it is the price of crude oil. The cell is updating in real time. I would like to have ...
0
votes
0answers
995 views

Excel 2013 Hangs when loading a number of Files

I have 2 machines: Windows 7 with Office 2007, and a new Windows 8 desktop machine (6GB memory) with 8.1 and office 2013. I have a large project with +- 70 Excel files. They are linked and need to be ...
0
votes
0answers
25 views

How to search comma separated tags in Excel and get results in a column. [duplicate]

I'm trying to tag items in a spreadsheet, and search through them, in a similar way to Nusantara How to Label / Tag Items in a Spreadsheet I've followed Excellll's brilliant advice and managed to get ...
0
votes
1answer
25 views

Basic Input to Output

I am a teacher in the Uk and we use basic curriculum levels, which range from 1 to 8 for KS3. A pupil entering secondary school would be about a Level 4 or 5 in maths. However each level in then ...
0
votes
1answer
560 views

Treating multiple fields as a single pivot table row label and a value source for subtotals in Excel

I have a tabular extract from a DB that has the following fields from orders and order line items: order customer (PK1) order serial no (PK1) order detail 1 order detail 2 ... order line nr (PK2) ...
0
votes
0answers
170 views

PowerView in excel 2013 not working

After enabling powerview and then clicking Insert/PowerView nothing happens. No error, no powerview, nothing. Simply not responding to clicks. I have version 15.0.4615.1000, I have silverlight ...
0
votes
0answers
51 views

Match the value in matrix to further display column name and row name

The table iam having is a matrix of 4000 rows X 4000 columns, sample of it is as given below: TaxonA/B GBCAT-01 GBCAT-02 GBCAT-03 GBCAT-04 GBCAT-01 100 81.1 100 ...
-3
votes
2answers
45 views

how to make a formula which will give the result as i mentioned in my message

A B C D sam 22 sam FORMULA kevin 15 harry 89 ben 45 gary 35 I have the above employee list (employee name, ...
0
votes
0answers
25 views

How can I select a column using a variable?

I am using the formula =LOOKUP(A5,Rota!A56:A81,Rota!I56:I81), where; A5 holds a name Rota!A56:A81 holds a list of staff names I56:I81 is the number of hours worked by that person This is repeated ...
0
votes
0answers
11 views

Use custom undefined color in Excel 2003

I want to change background of the cell. I click the icon in the toolbar to do that, but only pallete of predefined colors is offered: But I want my own, custom color which is not present in the ...
0
votes
0answers
18 views

Opening files with Excel

Every time I try to open any files by, associated with EXCEL , double clicking on it , a pop up window opens showing "There was a problem sending the command to the program." Each time I need to ...
0
votes
1answer
23 views

Need to extract the text occuring between first two single quotes.

610640436 06/10/2014 03:01:05 AM 1 CLOSED Task 'LGSP_J_JOB_GSP_JP_FIN_CO_0000_SumLv3' erred in process 'LGSP_J_SAP_D_D_011' (6534399) From this, I want to get the text occurring between the first ...
0
votes
1answer
151 views

Excel: find the cell that another formula found its “answer” in

I made a formula that searches an array to return a value, and now I want excel to "show its work" and tell me in which cell it found that value. I've been fighting with MATCH and ADDRESS but so far ...
-1
votes
2answers
44 views

Calculations for groups of data

I have 3 columns of data in an excel sheet. The first column represents zip codes, the second represents values in that zip code and the third column represents the frequency of that value in the zip ...
0
votes
0answers
121 views

Automation of solver in Excel by VBA macro code

I'm solving a 3rd degree polynomial equation, e.g., -0.003x3 +0.195x2 -1.087x -180 = 0 in Excel. I can do this by SOLVER of Excel and can find the value of x. The problem is the constant term ...
0
votes
1answer
46 views

Reload spreadsheet in Excel 2010

We have a spreadsheet on a shared drive that one person updates and the rest of use just read. I was pretty sure that when we used Excel 2003, if the author updated the spreadsheet, Excel would notify ...
2
votes
1answer
548 views

How to import Dates from Excel into Access with text in some cells?

I am attempting to import a date column from Excel into Access. The problem is that over the years, users of the Excel spreadsheet sporadically inserted text notes into this date column a few ...
0
votes
2answers
156 views

Strategy for Incremental Datasource fetchings in Excel

I am in an scenario with a table that is refresh by a third app every week. I need to keep accumulating all data in Excel, using an ODBC connection to the database. I am wondering Approach 1: Is ...
1
vote
2answers
2k views

How can I convert prnx file to excel?

I have sales reports with a .prnx extension. I want convert them to Excel format. How can I do this?
0
votes
1answer
83 views

Phone number formatting in Excel 2010

I have so many numbers in so many format like 2123244559, or 364 7890, or 02246802121. I want to write them in the same format like 0 ### ### ## ##, but the "format cell" tab isn't working. I've ...
-2
votes
2answers
94 views

Calculate average gas prices by year in excel [closed]

I have 3 columns, A=Date, B=Price, C=Grade in Excel. I want to calculate the average price of fuel for each year and an overall average of all years by grade. The data table looks like this ...
0
votes
0answers
118 views

Trello Excel add-in not working

I have installed the Trello Excel add-in. I can connect to Trello via Excel and I can see my card. If I click on import card, and it says that it is importing cards, But that's it, the cards don't ...
0
votes
1answer
112 views

Convert formulas in table to structural references

I have converted my range in excel 2010 into a table. However, the formulas which were before like that(see below) stayed the same and do not convert into structural references. ...
0
votes
1answer
61 views

Compare a small string in big string in excel

I have to compare a small string in a string. For example, I have two columns that are A and B A B test_BL_pa.txt 1 test_AL_pa.txt 2 test_BL_pa.txt 3 test_CL_pa.txt ...
0
votes
2answers
40 views

Showing name of row instead of excel cell name

I am having extremely long formulas over an extremely big sheet. At the moment I am tracking the formulas with the Formula Auditing Tool. However, my idea would be to just replace for example in a ...
0
votes
2answers
46 views

Finding trends in multi-category data in Excel

I have an Excel spreadsheet that contains hundreds of rows of data that each represent a single sample in a larger population. Each row is divided into three columns that contain frequency counts of ...
0
votes
0answers
21 views

Excel cannot open preferences

When I open Preferences and chose any of the icons, the following message pops up: "The number must be between -300 and 300. Try again by entering a number in this range." No other prompts or ...
1
vote
0answers
102 views

Combining train trips in a spreadsheet

My student job entails planning the shifts of a number of surveyors who ride on selected trains and count passengers. I would like to know if there is a way to make this task easier, probably in ...
-2
votes
1answer
105 views

Excel - How to count matches in data?

I am looking for patterns in the user journey of converted customers. I have each customers details in a row and then each step of the journey in it's own cell in columns, with up to 12 steps for each ...
-2
votes
2answers
88 views

Excel formula on IF

I am looking for a IF formula with 3 conditions. Request for help. Conditions: If Cell value is less than 10000 the value should be 0 If cell value is greater than 10000 and less than 15000, the ...
0
votes
0answers
18 views

Excel - Filling images using a reference image [duplicate]

I have a spreadsheet that I use to create baseball cards for a tabletop baseball game. There are about 20 cards on my sheet, and I'd like to add a spot where I can set the logo and have it reflect ...
0
votes
1answer
298 views

Excel Help: Search Column A, Sheet 1 for same value in Column A, Sheet 2, return value of Column B, same row in Sheet 2 [closed]

I'm surprised I couldn't find the answer on Google, maybe I am being silly. I want to perform this function:- I have two sheets in Excel, lets say they are Sheet 1 and Sheet 2 In Column A, Sheet 1 ...
-1
votes
1answer
692 views

Compare the value change of data in Excel between two similar sheets without VBA?

I need to match data in the column A's of two different sheets with similar data and then compare the values in column C. sheet 1 features data from this month, sheet 2 from last month. I have column ...
0
votes
2answers
130 views

Excel 2007 “Wrap Text” button won't “de-wrap” certain cells

I have an excel document where after clicking on a cell that is apparently wrapping text, I can't simply click the Home Ribbon's "Wrap Text" button to stop wrapping. Repeatedly clicking the "Wrap ...
0
votes
1answer
86 views

Excel table auto update

So I have a table in Excel with formulas. When I add a new row, the new row automatically fills in the formulas as well, which is great. My problem is that it also changes the formula in the row ...
0
votes
2answers
149 views

How to open CSV file with Russian Excel?

Comma is used as decimal separator in Russian locale. This is probably the reason, why Russian Excel is unable to open CSV files: As you see, all data went to first column.
0
votes
0answers
36 views

Excel: Vertically ordered tables overlap when data changes

I have an excel workbook that has a bunch of sheets in it. One sheet is a rollup/at-a-glance sheet that contains a bunch of different tables in it. Each table pulls data using a SQL query from a ...