**1**

vote

**0**answers

11 views

### How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows:
Unknown
Very High
High
Medium
Low
Very Low
None
I like the visual cues provided by ...

**0**

votes

**1**answer

17 views

### How to disable specific Excel 2010 add-ins at startup?

I want to disable specific add-ins from loading in Excel 2010 every time I open up a new workbook or instance. How do I achieve this?
When I disable the specific add-ins by unchecking them in the ...

**0**

votes

**2**answers

4k views

### How to make a dropdown list such that… (see details)

I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already.
I want to create a line graph in Excel. One line is fixed and ...

**0**

votes

**1**answer

24 views

### Word document loads incredibly slow

I have a word document (286kb) which takes almost 2 min to load. The document contains a large number of excel objects (as links from the same workbook).
This is what I've tried:
Remove the "old" ...

**2**

votes

**2**answers

21 views

### Dynamic formulas based on other cell formula results

I have 10 years of monthly data for 300 plants. While Excel can do moving averages for various time periods I am looking to do a moving median value for this data set.
I can obviously figure out the ...

**0**

votes

**5**answers

7k views

### How do you add extra value to a cell that already has an existing number in it

I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...

**1**

vote

**2**answers

23 views

### Deleting segments of a text cell value in Excel

I have many lines that follow a similar suit to the below format in my Excel sheet:
JFB001 D (2 Stem Flower Spray Orange Handcrafted Sugar Decorations) Web.jpg
What do I have to do, in order to ...

**0**

votes

**0**answers

14 views

### Excel: Do not open files in multiple instances

How do I open all excel files in the same instance/window by default (happens only when I open from the menu, but not from the windows explorer)?
I have this option unchecked, but is still not ...

**0**

votes

**3**answers

112 views

### How to dynamically populate a filter list with “first match” on a row, using excel 2007

The image is an example of what I am working with. I am trying to write a formula in my leftmost column, just under the listbox cell that you can see, which will find a string/value match in that ...

**1**

vote

**0**answers

13 views

### Feeding Data from SQL Server to Excel Template with visual studio c++ program [on hold]

I started a projet of automatic reporting.
To realize this i am using Microsft Visual Studio 2010 C++ (Ultimate edition)
Right now the project is almost finish, but i am getting stuck at the last ...

**3**

votes

**2**answers

81 views

### Showing a zero in front of a number in Excel

How do you get a zero to show up in front of a number if the numbers in the column are all different sizes, such as bank account numbers?

**3**

votes

**1**answer

259 views

### How to sort time column by value instead of alphabetically

I'm creating a pivot table by connecting to an SSAS tabular model (Data -> From Other Sources -> From Analysis Services) .
The model has a "time" column that I want to sort by. The default (database) ...

**2**

votes

**3**answers

16k views

### Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...

**0**

votes

**0**answers

22 views

### Excel import/ format problems

After clearing out lots of junk and formatting to a legible layout in excel im having problems crossing one final hurdle. My data I've imported is really hard to work with as its in the following ...

**1**

vote

**1**answer

19 views

### Two Columns Sum if

I have an "amount column" and a "Date Vouchered column". What I would like is a formula in a "summary cell" that will show the sum total of the amounts once a date vouchered has been placed next to ...

**0**

votes

**2**answers

29 views

### Shortening an Excel formula if possible

I am unable to shorten an Excel formula I am using in an Excel database. I have googled it, but this appears to be the shortest way already from the first page on Google.
...

**0**

votes

**1**answer

24 views

### Formula Required for Costs to date based on number of project days completed

I am trying to put together a template for project costs and am looking for a way to roll forward daily costs for each account code that avoids the need to change the formula on a daily basis.
I have ...

**2**

votes

**2**answers

16 views

### Excel: Auto-updating chart with changeable starting point

I have hooked up excel to an auto-updating database, but now I want to go a step further and make all essential report items automatic as well. And not only that - I want to make the way report looks ...

**2**

votes

**1**answer

34 views

### How to convert data in Excel to percentages of total?

Is there a quick way to convert all cell values in a table to a percentage of a total listed in a separate column? I tried posting an image of my data as an example, but my reputation here isn't ...

**0**

votes

**1**answer

18 views

### MS Excel : point a cell by concatenating text

In Microsoft Excel 2013, I want to point to a cell with this kind of formula :
=Sheet1!["A"+E1]
Where E1 contains the number of the line, for instance 25.
So the purpose of the formula is to get ...

**0**

votes

**1**answer

13 views

### excel: compare 3 column's numbers, decide on the largest number and place the column header in the 4th column

i want to compare the numbers of three columns, row by row, decide on the largest number and then place the title of the column of the largest number in a fourth column. the fourth column will end up ...

**3**

votes

**2**answers

2k views

### Counting occurences of a character in an excel spreadsheet

Feel silly asking this question, but I need some help!
I want to count how many * appear in a range of 5 cells.
The cells will range from 0-7 * each.
I was thinking of using the ...

**-3**

votes

**1**answer

18 views

### Find and Replace in all excel files

I am no programmer. Is there a macro/vba/tool that allows me to find and replace in all opened excel files, at once?
If not, an external tool that allow me to drag & drop files, because I have ...

**0**

votes

**1**answer

3k views

### Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio.
I have tried using a web query to MSN Money, but ...

**-1**

votes

**0**answers

15 views

### Source code vCard to MS Excel [on hold]

Do you have any source code to convert contacts from vCard to MS Excel? Any type of language such as Java, C# and C++. Thanks in advance

**1**

vote

**2**answers

2k views

### Excel function to remove last two words from a cell

Using operators for simple arithmetic 4m 44s
creating new database 3m 2s
These are the two values in two Excel cells.
I want to remove the last two words, that is, 4m 44s from every cell so ...

**0**

votes

**0**answers

11 views

### Adding to ranges within the XIRR function

The following (left side) is the standard example from the help on the XIRR function.
The 37.43% is the XIRR.
Now, assume that the initial row values are from somewhere else and I want to somehow ...

**1**

vote

**1**answer

61 views

### Setup Excel 2010 sheet that automatically popluates bi weekly dates

I'm trying to set it up where if I fill in a date it will automatically fill in the next column and on down. For example:
A1= 10/06/14 B1= 10/19/14
I want A/B 2 to be 10/20/14 and 11/02/14. I found ...

**0**

votes

**2**answers

144 views

### Create Excel pie chart from choice placement

I have a table like the following :
Choice 1 Choice 2 Choice 3
Person A 3 2 1
Person B 1 2 3
...

**1**

vote

**2**answers

29 views

### Excel - Pick Top 3 Choices

I exported a Qualtrics survey which had users rank 6 options. I want to then take their top 3 options and list them in the row.
Example:
Choice A Choice B Choice C Choice D Choice E ...

**2**

votes

**1**answer

3k views

### Split Text into Columns Function in Excel

I have an excel spreadsheet with rows of data as shown below. There is a code with the product name and then a number.
QA32 Product One (Large) 23
AZ63 Product Two 96
PR65 Product Three 149
How do ...

**1**

vote

**2**answers

10k views

### How can I create matrices of data in Excel?

I want to create a 4x4 matrix in Excel 2007 by taking three or more columns or conditions, for example:
Column index Row index Name
1 2 x
2 3 y
...

**-2**

votes

**1**answer

25 views

### Compare two rows and two columns and sum the 3rd row of the common value

I want to compare two rows and two columns and have to sum the third row of the common value.
I have two sheets. In one, I have the work the students made, ordered by date. In the same sheet, I have ...

**0**

votes

**1**answer

40 views

### Compare Excel Columns A & B and return C

I am a High School Principal and I need help figuring out how to use excel to create a class tracer for my students. A tracer is a spreadsheet that tells you what classroom a student is in during a ...

**0**

votes

**1**answer

15 views

### Running Excel Line Graph?

I have a spreadsheet that automatically scores a questionnaire into 10 different subscales in the first worksheet. What I would like to be able to do is plot each data collection point on a line ...

**0**

votes

**1**answer

225 views

### Hiding a column from a pivot table without removing it from the chart

I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates.
I want to visualize the ...

**0**

votes

**1**answer

17 views

### LO Calc / Excel - Dropbox change another cell

I am creating a simple Point of Sale System for a store using an excel/libre office spreadsheet.
The spreadsheet has a sheet called "Inventory" which has the following columns:
Name
Price
This ...

**0**

votes

**1**answer

42 views

### Lookup Values Based on Values in Other Cells

I have an inventory list that contains a manufacturer name and product category for each product. I want to look up the code for the manufacturer and the category code for the product and place the ...

**1**

vote

**1**answer

2k views

### probable cause of excel files getting corrupted

how to find out the probable cause of corruption of excel files...here i m not saying of a single file...files are getting corrupted one after the other...can
1)using windows 8 with excel 2007 and ...

**0**

votes

**1**answer

2k views

### Cells are not showing date as per Format in Excel 2010

In my excel sheet, I have selected date in Format Cells as 3/14/01 (which is M/DD/YY)
Some cells in DATE column are showing date in correct format like 5/31/12 (M/DD/YY), while some are showing it as ...

**2**

votes

**2**answers

4k views

### Efficient approach of selecting large amount of rows in an Excel file

I have an Excel file which have large amount of rows.
Is there an efficient way to select say 100,000 rows other than dragging my mouse?

**1**

vote

**2**answers

31 views

### How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date).
The chart is printed or worked on at ...

**2**

votes

**1**answer

31 views

### Can I sort in excel but read the cell values from right to left?

I have an excel worksheet list of names and email addresses. Some of the email addresses, however, are cutoff on the right and have "...".
For example: some email addresses are "test@test_user...". ...

**1**

vote

**2**answers

2k views

### MS Excel: Can I link images using a relative path?

I am working on an MS Excel document that contains a lot of (around 200) images. They are currently saved within the document, so the file becomes huge and working gets very slow.
Linking the ...

**-1**

votes

**2**answers

43 views

### Use Excel VBA If value in column a is not in column b then add value to column c

Dim i As Variant
'For i = 1 To 5
For Each i In rngWatch
Dim c As Variant
c = rngWatch.Cells(i, 1).Value
If i <> rngReconcile.Cells(i, 1).Value Then
MsgBox i
...

**0**

votes

**0**answers

11 views

### How can Excel add-ins be managed in an environment with multiple version of Office?

I have both Excel 2010 and 2013 installed. COM add-ins appear to be shared by all versions of Office. This is problematic because the whole point of having multiple version installed was to be able to ...

**0**

votes

**1**answer

47 views

### How to make Excel treat days/dates as starting at 8 p.m. rather than 12 a.m

Our 24-hour day is 8PM to 7:59PM. That's considered 1 day, not 12AM to 11:59PM. For times after 8PM, I need the entries to be considered part of the next day. For example:
Actual Date/Time ...

**-3**

votes

**0**answers

23 views

### Password protect excel sheets [duplicate]

How Do I password protect excel spreadsheets? I am making dashboards for employees and I would like to assign each employee a certain password to access their worksheet.

**4**

votes

**9**answers

38k views

### Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel:
How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...

**3**

votes

**1**answer

2k views

### Excel: Why does double-clicking in a cell jump to a different cell?

Normally, when you double-click a cell, you enter in-cell editing mode, right? This works most of the time, but occasionally on random cells, a double-click instead moves the focus to a different cell ...