**0**

votes

**1**answer

18 views

### Countif incorrectly matches long number

In Excel 2013 or 2010, if you put this value in column B1:
2014022701000400
And then this formula in column C1:
=COUNTIF(B1,"2014022701000409")
The formula will evaluate to 1. But the numbers ...

**-1**

votes

**2**answers

25 views

### Comparing two columns and extracting the entire row data in excel

The names from a column in sheet1 has to be compared with names from a column in sheet2, and the if a name matches, the entire row data of that particular name from sheet2 has to be displayed in ...

**0**

votes

**1**answer

20 views

### Copy formatted tabbed table trimmed in excel

I have a texteditor logbook and need also to copy the contents into an excelsheet.
Logbook content:
01.01.2000
----------
Entry One.\t\t\t\t\t8 Hours
Entry Two.\t\t\t\t\t20 Minutes
...

**1**

vote

**0**answers

15 views

### Looking up the same value in a row and returning multipe corresponding values

I am trying to lookup value 1 in the example below and return corresponding column name. When I use index match, it only looks up the first column which corresponds to 1 in the below example, it looks ...

**0**

votes

**2**answers

28 views

### Excel - How to compare columns for equal values

I have an Excel sheet which has two columns. Both columns have numbers. The first column contains more numbers than the second column. I want to find which all numbers in the second column are there ...

**0**

votes

**1**answer

37 views

### Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule:
If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. ...

**0**

votes

**2**answers

21 views

### Populate one column with data from a list and match other column data

I have an Excel 2013 Workbook that has a worksheet (sheet 1) that contains two columns (one column for number and the second column for description, they are separate columns, but 1:1).
On the other ...

**-1**

votes

**0**answers

16 views

### Excel 2007 function keys not working

In Excel, the F function keys are not working. I am looking for "toggle" for this function.
For example, F4 will not cycle through absolute and relative cell references.
How can I troubleshoot/fix ...

**0**

votes

**0**answers

5 views

### How can I select that element from a vector of Gnumerc / Excel of which the difference of a given cell is minimal?

I would like to do a goal seek in gnumeric / Excel. I would also like to make a column of data, which values are selected from a vector (range) based on minimal difference to a given cell. What ...

**0**

votes

**1**answer

11 views

### Excel developer list box dimensions are not preserved

I used the Excel Developer Tab to create a List Box for a macro. Every time I open the file my List Box is in, the list box has shrunk. I need help fixing the width and height of the List Box such ...

**0**

votes

**1**answer

35 views

### Shifting Formulas When Copying in Excel

Is there a way to have Excel move an entire table containing formulas and shift the formulas to account for the new cell positions? Whether I use paste special or regular paste I'm finding that the ...

**-2**

votes

**1**answer

22 views

### How to show share of total number of procedures?

G&G hi!
I have a table of data which shows numbers for every procedure of year 2013. For every procedure i have a number and at the end the sum/total of all procedures.
I have to get two ...

**0**

votes

**2**answers

38 views

### Combine Multiple Values into Rows with Blanks

So I researched this for awhile, but I seem to be hitting a wall. I will admit- I successfully did this once, made a tutorial for my coworkers- then I nor anyone else was able to replicate the ...

**0**

votes

**1**answer

20 views

### Embedding hundreds, even thousands of pdf files in excel?

Would it be possible and efficient to insert - object about 1000 PDF files to an excel document, or will it start running extremely slow/other problems?

**0**

votes

**0**answers

15 views

### Hyperlinks to documents have changed

I have several hundred links to documents in a folder on a network drive embedded in my excel so that if I click the link, the pdf document opens.
As of today, a lot of these documents do not open ...

**0**

votes

**1**answer

17 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

15 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

21 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

12 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

31 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

29 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

26 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

17 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

53 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

31 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

41 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

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