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)

0
votes
1answer
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
2answers
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
1answer
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
0answers
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
2answers
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
2answers
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
2answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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 ...