**0**

votes

**1**answer

14 views

### Automatically move data labels outside of pie chart in Excel 2013

I have a pie chart in Excel, my data labels are overlaid directly over each slice in the pie - but I want my labels outside the area of the pie (but within the general chart area).
I can drag them ...

**0**

votes

**1**answer

14 views

### Formula containing Sum and If statements

Please help - I need a formula which says if D9 has a value, then the sum of E9 will be C9*D9, other the sum will be C9

**0**

votes

**1**answer

13 views

### Excel 2010 “sending the command to the program” error

Multiple domain users receive the following Excel 2010 (32-bit edition) error occasionally when opening random XLS files.
There was a problem sending the command to the program
...

**0**

votes

**0**answers

23 views

### How to rewrite this Google Spreadsheet =filter function in Excel

This is a Google spreadsheet function that prints the common values in columns a,b and c. I'm trying to use it in Excel, but Excel doesn't have the =filter function
...

**0**

votes

**0**answers

19 views

### EXCEL: I have a column of single-word strings and would like to see if any of these strings are contained in a column of multi-word cells

Example:
In column A I have a list of words "Apple, Banana, Orange, etc." each in their own cell.
In column C I have a column of multi-word strings like C1="I ate an apple", C2="Bananas are gross" ...

**0**

votes

**1**answer

11 views

### excel 2010 is appending a space to the end of currency field when saving a csv file

Create an Excel spreadsheet with one cell. Put "$1,234.56" (WITHOUT the quotes) in the first cell. Save it as test.csv. Open test.csv file in a text editor, Notepad.exe will work. The file contains ...

**1**

vote

**2**answers

30 views

### Excel save-as CSV options — possible to change comma to pipe or tab instead?

Is there a way to tell Excel which delimiter to use when producing a CSV, e.g. tab or pipe?

**0**

votes

**1**answer

24 views

### Store user's personal Excel column filters in a cookie-like file?

I'm developing a reporting app (how exciting!) that puts out HTML, PDF, and Excel reports. In the HTML version I let the user select which columns they care about, and filter out the others. This is ...

**-1**

votes

**1**answer

14 views

### I want to pull Row Heading along witht the Top 3 values in Excel

Example:
Players AtBats BattingAvg
Dave 20 0.563
Frank 19 0.385
Alex 22 0.500
Chris 19 0.526
Paolo 15 0.571
I want to pull the top 3 batting averages along with the batters ...

**-2**

votes

**1**answer

14 views

### Adding data from two different sheets in Excel

I know this question has been asked a lot but I have not found a reference that works for my specific data yet.
I have two sheets, each with a totals cell. I want a third sheet that will add ...

**2**

votes

**1**answer

28 views

### VBA selecting range in Excel

I can set the range for all of a column such as :
ActiveSheet.Range("A:A")
But I'd like to set something such as
ActiveSheet.Range("A10:A")
but there doesn't seem to be an easy way to do this ...

**0**

votes

**2**answers

37 views

### How to automatically make all entered numbers in a row negative using Excel?

I am making a simple cash flow and would like to set up a column for outflows where it automatically makes any number typed in that column a negative. How would I do this?

**-1**

votes

**1**answer

18 views

### Deleting range of cells based on criterea

I have an Excel file with several macros, used for data processing.
The masterfile reads one or more .csv files and copies all data it needs into a tab (lets call it sheet1) within the masterfile. ...

**0**

votes

**2**answers

19 views

### Excel - Compare two cells and display the larger number?

Can someone tell me how to compare two cells (numbers), and then display the larger cell?
Cell C1 = IF A1 > B1 then display A1 else display B1
Sorry I'm not an excel pro.

**1**

vote

**0**answers

23 views

### How to get formulas to do the calculations [migrated]

I have a column from A1:A398 in a Google spreadsheet. Each cell either has an "f" or is blank. I want to count how many of each there are. In row 399, 400 and 401 I put the following formulas
...

**0**

votes

**1**answer

20 views

### Compile Form Data In Excel [on hold]

I've created a form in Excel which has been filled out by many people. Now I have ten files containing this form which have been filled in and I'd like to compile all the results into one Excel file. ...

**0**

votes

**1**answer

33 views

### Common values in three columns of data in Google Spreadsheets

I have three columns of data in columns K, M and O in a Google Spreadsheet and want to find out (with results printed in column H) which values are common to each of K,M and O.
To make it simpler, I ...

**0**

votes

**1**answer

9 views

### Excel: Subtotals by year value

I have a table in Excel-2013 containing some data similar to this:
Year Month Electric Gas Water Monthly Totals
2012 Feb 115.49 40.15 82.13 202.70
2012 Mar ...

**0**

votes

**1**answer

25 views

### Excel 2013 Averageifs

I want to calculate the average of time in a column of cells if the time falls within a range in another cell.
E.g. If a patient comes in between say 6 and 8 pm I want to average data in another ...

**2**

votes

**0**answers

27 views

### In Excel, Can I have two rows of (worksheet) tabs for my workbook? [duplicate]

I'm using Excel (2013). I have a workbook with numerous different worksheets, and would like to have them take up two rows of worksheet tabs rather than just one. Can I achieve this somehow? I can't ...

**0**

votes

**0**answers

14 views

### New items in drop down validation menu aren't showing in Excel 2010

In Excel version 14.4.2, I have a drop down validation menu and I have added more cells with new menu items.
However, these new items are not showing on the drop down menu on all the cells of the ...

**0**

votes

**1**answer

26 views

### How to join neighbor cells in Excel

I have some data which I recorded in a bad way, see the picture :
How can I format this into something like this:
Error 1 Error 2
(3.2 ± 1.97) E-04 (3.7 ± 1.3) E-03
(2.2 ± ...

**0**

votes

**1**answer

16 views

### Chart not showing all data

I have created a very simple spreadsheet with data by half an hour for every day from Mon - Fri.
I have then created a line chart and in the legend every day is shown, however the data for Monday is ...

**0**

votes

**2**answers

23 views

### Excel Formating - How do I compare 2 cells and highlight one of them based on the date in 1 Col being further out then the date in the other?

I have a spreadsheet tracking multiple dates for about 150 people. I am having a problem however getting dates in Col I to highlight if they are going to be past the date in Col P.
I want Col I Row ...

**1**

vote

**0**answers

16 views

### When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.?

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.??? I need to convert 16.329.932 back to 1.6329932. the table has a lot of values and all have changed ...

**1**

vote

**0**answers

22 views

### How to recover some missing data in Excel?

I have two versions of an Excel file, one from before I did a lot of work on it and one from after. The after-version, despite a lot of productive work, also includes the results of a catastrophic ...

**2**

votes

**2**answers

48 views

### How do I show only the print area in Excel and grey out the rest?

I'm trying to replicate an Excel spreadsheet that someone sent me and I can't figure out how. The print area is set, and all cells outside the print area are greyed out. The cells aren't simply ...

**1**

vote

**2**answers

30 views

### How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be ...

**0**

votes

**1**answer

29 views

### sumif(s), sumproduct for many to many relationship

I am looking for a formula/function that will allow me to essentially SUMIF(s) across a BOM. I know my part to FG relationship (Part, FG) and I know how many FG's I need(FG, Qty).
How can I ...

**1**

vote

**1**answer

40 views

### How to plot complex data as a radar chart in MS Excel?

I have some data from an experiment (which I did not design) that I'm supposed to analyze. After looking through the possible options for displaying the data to visually analyze, I believe that a ...

**0**

votes

**0**answers

11 views

### Is the Excel “Last Modified” time adjusted to my timezone?

I'm looking at a Last Modified time stamp in an Excel Workbook:
I got the spreadsheet from China, and I'm sitting in Denmark. These two countries are in two different time zones, and I would thus ...

**0**

votes

**0**answers

24 views

### Using Query Function in Google Spreadsheet where {data, query, [headers]} is determined in another cell

For example in cell T2 contains the following text generated with the =CONCATENATE function
DW004!$A$11:$H, "select H where (C contains """&$E2&""")", 0
This was created with the format
...

**1**

vote

**0**answers

13 views

### Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone.
Form example:
09:00 EST 06:00 PST
Is there some sort of custom format ...

**0**

votes

**0**answers

22 views

### Excel value of the digit or alphanumeric formula

How to convert a price or value of the digit which is taken as a formula to an alphanumeric?
Example :p o l i c e m a n w x y
1 2 3 4 5 6 7 8 9 10 ...

**0**

votes

**0**answers

17 views

### Make an Excel Graph Axis Show Two Time Zones

I have an Excel graph that displays the time of day in 24 hour HH:MM format. I need to also show the time with an offset for another timezone. How can I do this? I've attempted to use a custom ...

**0**

votes

**2**answers

36 views

### Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...

**1**

vote

**1**answer

54 views

### Excel: Different background colors on condition

The problem
I have a Excel sheet that contains a status column.
Number Status Name
-------------------------------------
1 not implemented feature 1
2 completed ...

**1**

vote

**1**answer

30 views

### How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100).
In cell G2 is criteria from column A.
With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...

**0**

votes

**1**answer

16 views

### Error outputting a string to cell

I am using a vba macro to automate part of an excel spreadsheet. The following line keeps giving me a runtime error 1004# application or object defined error
Sheets("Material").Last.Offset(0, ...

**0**

votes

**2**answers

39 views

### Pulling out data from a spreadsheet

I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made ...

**1**

vote

**1**answer

36 views

### Excel custom auto-complete

I have a long list in a sheet in my Excel file:
Number Value
123 Text 123
127 Another text
131 Yet another text
... ...
On another sheet, I need to input those numbers. But as ...

**0**

votes

**2**answers

35 views

### How to perform sql query on sheets of excel

I have two tables in excel(sheets) . One has 10,000 entries , another has 1000 entries . Both of them have account number column in common . I want to select only those row in 10,000 entries which ...

**0**

votes

**0**answers

8 views

### How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...

**0**

votes

**0**answers

15 views

### MS Excel: Send Data from PowerView to PowerPivot

I have an Excel workbook with two sheets: a PowerView sheet and a PowerPivot sheet. They both show the same data; the PowerView sheet shows data at a high level, and the PowerPivot allows users to ...

**1**

vote

**2**answers

24 views

### Apply VLOOKUP to multiple sheets and ignore blanks

I would like to do a VLOOKUP on multiple sheets (for which I am able to define a strict priority order) but where I want to ignore the answer when it is a blank. I have found this answer:
Apply ...

**0**

votes

**1**answer

15 views

### Excel Table Row lookup

I need help in populating cell drop down, and table value lookup.
Sample data in a worksheet. I have created a table and given it a name.
Sample Data (Table Name: Products):
Category Product ...

**2**

votes

**1**answer

28 views

### Week of the month given week of the year

How would someone go about finding what week of the month a given week is knowing only what week of the year it is? I was going to try something like MOD(cell,4), but I know this will only yield an ...

**0**

votes

**1**answer

20 views

### How to automatically delete rows that contain certain numbers in the ID column

I have a column of numbers in another workbook and I would like to use that set of numbers to delete rows in the main workbook. I will give an simplified example of what I'm talking about below. My ...

**0**

votes

**2**answers

29 views

### VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter:
Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String)
Dim mlook As ...

**1**

vote

**1**answer

37 views

### Windows 7 Excel 2010 annoying personal.xlsb message

I'm running Windows 7. Each time I run Excel I get this message popping up.
Excel cannot open the file '~$PERSONAL.XSLB' because the file format or file extension is not valid. Verify that the ...