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
3answers
40 views

How to calculate the first occurrence of a given weekday in the next year in Excel?

I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the ...
0
votes
1answer
35 views

Using Dynamic Repeating Formulas in Excel Templates

I have an Excel merge template that compares Actions to Results. It is used by many different sales people. For that reason, the length of the spreadsheet can vary. The users have limited Excel ...
0
votes
3answers
37 views

In Excel replacing a column with another column

I have a list of Variables in Column A > list of items another list of variables in Column B > with corresponding Item Codes for >> column A And in Column C > I have list of item codes randomly ...
0
votes
2answers
16 views

Combine two excel documents with imported data and pivot tables

I have two excel documents. Each has a sheet with imported data from web and a sheet that contains a pivot table based on the imported data and chart summarizing that pivot table. I want to combine ...
0
votes
2answers
25 views

How to highlight strings that match pattern in Excel?

I have a large set of data that needs to have some visual formatting cues added for visual review. Essentially the particular matches are phone numbers that have to be matched and when found the row ...
1
vote
1answer
45 views

Excel - Lookup to match varying criteria

I have a list of poles, some with more than one test result. I want to find the latest test result for each pole and then return the result. As we know, VLOOKUP only finds the first. I don't want ...
0
votes
1answer
50 views

How to delete entire row when A1:A100000 columns are duplicated

I have to filter quite big data (102858 rows, 9 columns). The idea is that between these rows (URL addresses) are a lot of duplicates. A1:A102000 contains URL addresses with and without comments. For ...
-2
votes
1answer
33 views

How to calculate monthly sum from the entries for each date in Excel?

I have colums for my workout logging: Date Running (minutes) Pushups Pullups Crunches and the rest of my workout entries. I insert my achievements each day. How can I script Excel to ...
0
votes
2answers
28 views

How do I make a button to add new fields in Excel?

I have a formula which uses a constant. Every time I copy and paste the cells for a new day, I want the constant to update to the new one. I was thinking I could create a button to copy the fields ...
0
votes
2answers
36 views

Formula update no longer working

I have the same formula update problem as others posted on this site. I have a formula =SUM(B1+B20). I'm trying to enter dollar amount in B1 and updating the dollar amount in B20, thus increasing ...
0
votes
1answer
19 views

Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...
0
votes
1answer
12 views

Fixing numeric cell in a formula in excel on a Mac

I would like to use repeat a formula with some constants noted in an assumption table how do I do so in Excel on a Mac. In Excel on a non Apple device the formula would be something like this ...
0
votes
3answers
50 views

Excel documents will open excel with blank window

When opening any excel document it will only bring up the excel window. To open the document I will have to goto file -> open. I am using Office 2013 on windows 7 64bit Only started happening the ...
1
vote
0answers
33 views

Office 2013 can't open office 2010 protected file,vice versa

I couldn't achieve to produce an interchangeable protected file between Excel 2013 and Excel 2010. Excel 2010 can't open 2013s protected one and 2013 can't open 2010s protected one. I think their ...
0
votes
3answers
34 views

One Excel file, multiple editing users, live updates

I have an automated program which is working on Excel workbooks. When someone opens the workbook currently being processed, they will get a read-only message. If multiple users/programs try to open a ...
0
votes
2answers
28 views

How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?

How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates? I also want to limit another range of cells to maximum 24 alpha and "-" ...
0
votes
1answer
12 views

Excel leaving formula when selecting another sheet

I am attempting to reference a range in another workbook in a vlookup. I type "=vlookup(a1," and then go to the other workbook to select the range, but alas, I am no longer in the vlookup formula. I ...
0
votes
2answers
36 views

How to embed or link a text file in Excel?

I have a text file containing a memory dump from an embedded system, which I update after every run (the file is formatted in the Motorola SREC format, but this is not too important). I am using Excel ...
0
votes
1answer
22 views

How can I in a pivot filter detail to show new accounts in current month with sales where all other months show no sales?

I have a pivot table which is huge with raw data has more than 800,000 lines. I have customers in the row labels and month or year in the column labels. Each month this pivot tablr grows adding on ...
-4
votes
1answer
40 views

Have range of numbers and need to find repeats/missing sections contained in two columns

station start station end 0+00 50+00 50+00 100+00 100+00 150+00 150+00 200+00 250+00 275+00 300+00 350+00 325+00 350+00 350+00 400+00 I have two ...
0
votes
1answer
17 views

Attempting to wrap text

I want to prepare a form in excel to be completed by others. The responses will require several lines. I've tried to merge cells and wrap text. Then when I begin to type, the text begins at the ...
2
votes
1answer
45 views

Excel 2013 table formatting

I currently have a table that looks like this: Company | 2013 Total | 2013 Gross $'s | 2013 Gross % | 2012 Total | etc.. | | | | | ...
1
vote
1answer
38 views

How can I stop excel from rounding to .00?

My Excel formulas are producing answers that only give zeros after the decimal place. For example, =QUOTIENT(10.90,0.0450) gives the answer of 242.00, it should be 242.22. How can I keep this ...
0
votes
1answer
24 views

How to prevent all-filtered-out row label values from appearing in a pivot table?

I have a pivot table in MS Excel. For the same of example, suppose the basic data has 3 columns: Name: A string. CountMe valued either 0 or 1. Year an integral number. Tokens the data we're ...
1
vote
1answer
74 views

Unix Command to get number of lines in a csv file

Hi Iam new to UNIX and I have to get the count of lines from incoming csv files. I have used the following command to get the count. wc -l filename.csv Consider files coming with 1 record iam ...
0
votes
2answers
31 views

How do I calculate the number of months between two dates in Excel? [duplicate]

I have two columns on Microsoft Excel: F is the column with the date service ended; E is the column with the date service began. How do I calculate and report the number of months served for each ...
1
vote
1answer
16 views

Microsoft Excel - Formula query

I need to create a formula as follows: IF SUM of Columns A2:D2 = 0, then excel should populate in column E, the value of "NO", else it should be a default "YES". This is what I've tried ...
1
vote
0answers
19 views

Make Excel 2007 pivot tables default to Classic View

When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be: New view (not Classic view) Autofit column widths on update = on Subtotals = on (top of group) I end up ...
0
votes
4answers
32 views

Convert letter grades to number

In Mac Excel 2011, how can I convert a letter grade in one column to a gpa number and place it in the column next to the letter grade. I have about 70,000 grades I need to do this for.
0
votes
1answer
18 views

Formatting an Excel date without space between elements

I am trying to format a Date in Excel (Office 2010 for what matters) in the following format: <week day><day>/<month> (e.g. "Wednesday14/3"). I came up with the format dddd_dd/m ...
0
votes
1answer
35 views

excel - if value grater than, use that value

I am having problems with my excel function. I want to: if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell. ...
0
votes
1answer
27 views

Excel dates formats

when users enter a date in excel using this format 19.03.2013, i need the cell to automatically change the format to Wed 19 Mar'14. Please advice! Please check in the attached image, where I copied ...
0
votes
0answers
41 views

Excel test generator inserts extra data. VBA

I build a random test generator for Excel using VBA. It will randomly pull questions from a test question bank. It will also add the answers in a different cell. However, I found that occasionally ...
2
votes
1answer
22 views

Is it possible to specify the decimal separator on Excel refreshable web queries?

When you create an Excel Web Query that points to a text file located in a web server, Excel doesn't ask for the decimal separator as it commonly does when using the Import Text File or Text to ...
0
votes
1answer
17 views

Excel Chart from Multiple Sheets

I have a bunch of sheets and each one has a value in cell K15 and call K20. How do I make a stacked column chart that shows these values stacked for each sheet? Forgive my crude drawing, but ...
-2
votes
0answers
42 views

Looking for formula in Excel to take the set of cells in the row and check for a match in a column

For each row in my spreadsheet I want to use a formula to check the values in the 17 columns B:R for a match in a smaller vertically oriented table and then check to see if the corresponding value in ...
0
votes
3answers
36 views

How to add progressive 'count' in rows

How do I format cells such that when entering data, formatting automagically add a number before the text such that the number is equal to a number+1 from a an adjacent cell (in my case from above)
0
votes
3answers
53 views

How to use =VLOOKUP under these circumstances?

So I know how to use =VLOOKUP when you are searching for a single value within a cell, but I'm not sure how to do it when I have a range, ex. say the cells value is 1-5, the next is 5-10. This is ...
0
votes
1answer
34 views

Run Command to open csv file in excel

My first question on the site, so hopefully I'm doing this right. I use file juggler on my windows machine. The program can watch for new files and trigger run commands. When a new csv file arrives ...
2
votes
2answers
32 views

Excel: Select the cell to the left that is greater than/less than some value

I have a data entry form that is used to input data from image analysis. I take segments of images of membranes in ImageJ which I then paste the intensity values into an Excel spreadsheet. A graph ...
1
vote
1answer
171 views

Excel TEXT function does not work properly

Let say I have the following values in the cells A1 : `=Now()` which displays 17.03.2014 13:45 A2 : 12.03.2014 Both are in date format and I have the function in another cells like this: B1 : ...
0
votes
1answer
24 views

Formating data to fit report?

A friend needs to turn the few sheets she has in an Excel file into a report. Before I learn about how to use Word's mail merge feature, I was wondering if there weren't a good solution in Excel to ...
1
vote
3answers
47 views

,“>”&0),“”) at the end of a countif formula

I have the below formula, but don't understand why the last part of it ,">"&0),""). Can somebody clarify pls? ...
0
votes
1answer
21 views

VLOOKUP with string returning #REF

I have the following set up in Excel, and I am attempting to lookup the first column in the range A5:A7, and return column 8 (the rate) plus the custom rate. This is the link to the current setup I ...
0
votes
1answer
38 views

Excel - How can I highlight duplicate cells in near-matching worksheets?

I'm running a March Madness bracket tournament using Excel spreadsheets. I have one sheet where I will input the actual winners. I have an additional sheet per participant that is near-identical, only ...
0
votes
0answers
30 views

Keyboard media keys (play, pause etc) don't work while Excel 2013 is active

Excel 2013 appears to "swallow" these keys: whenever it's active, play/pause and similar keyboard keys don't work at all. Activate any other application and they work again. Is there a known fix? ...
0
votes
2answers
42 views

Index and Match to a file posted on SharePoint returning #Ref Error

I have two Excel files posted on SharePoint. With the master file, I've created INDEX, MATCH array formula, referencing the other file. I've entered the entire NUC, and the formula works fine while ...
1
vote
1answer
17 views

custom conditional formats in excel 2013

my goal is to format an entered text if a certain condition is met e.g. user enters "5" in a cell format detects that it is greater than 3, appends "/a" [result: "5/a"] user enters "2" in cell ...
0
votes
1answer
22 views

Ctrl+[ not working in Excel 2013

The keyboard shortcut Ctrl+[ (trace precedents) is not working on my new laptop. I am using Excel 2013. Can anyone explain how to set it to work?
0
votes
1answer
21 views

Relative cell reference in Excel using different axis

Is it possible to make a relative cell reference that extends downwards when I copy the value to the right? Consider this example: 10% 100 150 200 250 300 15% 20% 25% 30% I would like to ...