# Tagged Questions

**3**

votes

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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 ...