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 "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
14 views

Excel Cell formatting recall

Is there a way to enter new data into an excel cell, but still have the cell remember the previous entry? i.e Cell A1 was 100K, now I enter 80K. But need to know what the prior entry on the cell ...
1
vote
3answers
2k views

Automating data from an Excel file and interacting with browser

How can I automate copying records from an Excel file or CSV and interacting with a browser? Example Task: Extract or Copy record(s) from an Excel file row Go to a URL (probably using Google ...
7
votes
4answers
35k views

How can I obtain the year quarter from a date?

In Excel, how can I obtain the year quarter from a date, using a worksheet formula? I have a column with dates spanning multiple years. Jan-01 to Mar-31 = Q1 Apr-01 to June-30 = Q2 etc... Bonus ...
1
vote
0answers
10 views

How to find and replace the character “*” in excel text values in cell, but NOT formulas

Very similar to this question: How to find and replace the character "*" in excel But I need to leave formulas untouched. I've got about 50+ sheets that have two types of cells with "*" ...
3
votes
2answers
5k views

Create data matrix from three columns in MS Excel

I have three columns with data, for example: A B C D 1 [From] [To] [Total] 2 Vancouver Shanghai 100,000 3 Vancouver Melbourne 50,000 4 ...
-3
votes
0answers
26 views

Can someone help me decipher this formula. It deals with a life insurance policy where there is an annualized cash value interest rate of 4.00% [on hold]

Here is the formula the "administrator" of the policy gave. (((1+i)^(m/12))-1)*P They gave only the following information. i=interest rate to yield m=number of months p=principal Background - The ...
1
vote
2answers
22 views

If/then formula in excel

I am trying to created a formula in my spreadsheet in which if a certain cell has the text value of "enrolled" then the spreadsheet reflects the difference of two cells. I entered this formula but it ...
0
votes
1answer
16 views

Using value of cell to search text of another sheet and highlight cell if match is found

Scenario is a workbook with two sheets. I need a way for cells on sheet 2 to search sheet 1 and highlight themselves if they find any text on sheet 1 that matches. So cell sheet2!a2 with value of ...
0
votes
3answers
29 views

Excel: Cannot get Custom Number Format to work for specific date and time

I've been going over this for a while and for the specific date + time format I have, I cannot get the Custom Number Format to pick the date up properly. I have these dates (several examples): ...
0
votes
0answers
8 views

How to create a 100% stacked column chart if I have total

I'm trying to create a 100% stacked column chart using Excel 2013 Pivot Table to show what % of Column A is of a Total Column B. However the 100% stack column chart doesn't seem to work if I have a ...
1
vote
4answers
32k 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
0answers
14 views

Change an excel formula in one culture to a different culture [on hold]

I have an excel formula in One culture and i need it to be converted into a different culture. Any API's available for this ?
0
votes
2answers
8k views

Copy drop down list from excel 2007

How can i copy a entire drop down list from excel 2007 one document to another excel document, i have tried copying and pasting special, some forms told me to copy it through data validation process ...
5
votes
4answers
26k views

Copy/Pasting data from SQL Server to Excel splits up text into multiple columns?

I've got a problem pasting data from the result grid of SQL Server 2005 to an excel 2007 spreadsheet. I have a query in SQL Server that returns 2 columns (a number column and a text column) On one ...
0
votes
0answers
25 views

Is it possible to share a hyperlink in outlook email to a specific excel worksheet?

I have an Excel workbook which I can shared by sending a hyperlink to this file by e-mail. But I do not just want to share the file, but link specifically to a certain worksheet. I know that linking ...
12
votes
6answers
52k views

How to open xlsx files with Excel 2013 by default on windows 8?

My xslx files open systematically with Excel 2010 when I'd like them to use Excel 2013. Everytime I right click select open with point to C:\Program Files\Microsoft Office ...
0
votes
0answers
6 views

Excel, Kutools, Hide Select Interval Rows

Utility data I'm working with was collected every 15 minutes for a year, 8/6/14-8/5/15. I want to compare it to data from another source, however, that data is provided in one hour increments. Using ...
1
vote
1answer
8k views

Excel Help: Fill Tool - Drag to the side (across columns) but increase the formula by Row Number

There are answers out there to this question, but all of them have been under explianed so hence to difficult to coprehend and use them to my advantage. I want to do the seemingly simple (but not) ...
6
votes
9answers
24k views

Changing bounds of excel file embedded in powerpoint

When I embed an excel files into powerpoint, I'm having two issues. On some of the spreadsheets, empty columns are displayed on the right hand side of the powerpoint slide On other spreadsheets that ...
0
votes
0answers
15 views

Populate information from on spreadsheet to another on same excel File

I am creating two sheets for one excel file for business conferences . One sheet will be an inventory list of items being sent to conferences, the other a sheet that contains details of the ...
0
votes
1answer
3k views

Sort doesn't work properly for cells with references to other cells

I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table: For instance, the value of the first cell in the ...
0
votes
1answer
19 views

How to extract part of excel cell?

I need to extract a part of an excel cells, but the starting chars is not always in the same position. The rule is that I need to extract the text at the right of a determined char. For example I ...
0
votes
0answers
8 views

How to show the header and adjacent cell values of two lowest values in a row in Excel 2013

I want to make a comparative statement in excel 2013 of a rate inquiry for purchases. The top row contains the name of the vendors, below each vendors name there are two columns, first showing ...
0
votes
1answer
18 views

Count matches between two arrays

How can I count the number of entries two arrays have in common, using just standard excel formulae (i.e. no VBA)? Can't find an answer anywhere. e.g. A B +------------- 1| 1 10 2| ...
0
votes
1answer
18 views

Excel 2013 rounding error

A B C 2.55 3.80 2.54 3.81 2.49 Average 3.81 2.53 % Difference 33.59580052 Trying to get the % diff between avg of column B ...
2
votes
1answer
69 views

How to convert number to words?

Is there any formula / procedure to convert number to words. e.g 25371.34 to be converted as "Twenty Five Thousand Three Hundred Seventy One and paise Thirty Four Only".
3
votes
2answers
141 views

Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column? Let's say I ...
1
vote
1answer
19 views

can I save a view of multiple worksheets in excel 2013

The image below is a view of two (2) worksheets in the same excel 2013 workbook. I made it using View--> View Side by Side, and the sizing each sheet, etc. Is is possible to save this view so that ...
1
vote
1answer
124 views

Excel 2013 opens files slow in Windows 10 (when not in Safe Mode)

This is a problem that has come up on Google and superuser in the past, although the solutions I have found haven't worked for me. If I run Excel 2013, it opens instantly. If I am in Excel and open a ...
0
votes
0answers
19 views

Excel: Storing a Path to Access a Closed Workbook

I have a workbook (let's call it A) which accesses another workbook (let's call it B) which is closed. From A, I need to access data on B which may be on different worksheets. However, B contains a ...
1
vote
1answer
28 views

Error Adding new row

When I am trying to insert a row in excel sheet, I am not able to add a new row in a particular sheet say Sheet 1. where as I am able to insert a row in sheet 2 or sheet 3 of the same excel sheet. I ...
3
votes
1answer
19 views

Checking a range of dates

I would like a formula that will return Yes only if a range of cells in the same row all have dates in the future, and if five other cells in the same row have the value "Yes". I tried to just check ...
31
votes
4answers
3k views

Get rid of all ##### errors at once in excel [duplicate]

In Excel, I usually solve ##### errors by double-clicking offending column headers. However, this can get a bit tedious when there are multiple error columns. Is there a quicker way to solve this?
1
vote
1answer
2k views

Excel 2010: Combine Two Tables in Pivot Table

I have two named tables on separate Excel worksheets in the same Excel 2010 workbook. These tables contain the exact same header items. I could get the results I want by copying the data from one of ...
0
votes
2answers
2k views

Exporting Attachment File Name + Email Metadata from Outlook to Excel

I am looking to do analysis on all of the file types that I have received in a folder in Outlook. I have tried using the Export functionality in Outlook, as well as importing Outlook directly into ...
0
votes
0answers
20 views

Excel 2013 custom vlookup method

I have a workbook with over hundred worksheets that has monthly bonus calculation requests submitted (one for each employee) as well as a few other sheets that have the current monthly data such as ...
0
votes
2answers
26 views

How do I get nothing to print when using ISBLANK nested formulas?

I have 6 columns and 3 equations : E*F=G, H*G=I & G+I=J I don't want zeros to print if a cell in F or H is empty. Currently I have these equations and everything is dependent on the F & H ...
1
vote
0answers
26 views

Performance Gain From Excel 2007 to 2010/2013 for modern PC

My work recently upgraded my department’s computers to shiny new spiffy i7 ssd 16GB RAM boxes. I spend most of my time in excel/access and the company still uses the 2007 versions of this software. ...
1
vote
3answers
95 views

How to keep history of data changes in one excel workbook or sheet to another workbook or sheet

good afternoon, I am working on an excel sheet where I have a table of data. This data represents several metrics that my department wants to keep track on. Whenever someone wants to populate the ...
1
vote
1answer
28 views

Spreadsheet autofill increase in middle of text (Lotus 123 could, Excel cannot?)

I could drag a series in Lotus 123 (25 years ago!) and it was intuitive about what should increase. For example: xyz1abc xyz2abc Would drag to: xyz3abc xyz4abc Etc. Excel seems to be able to ...
1
vote
4answers
34 views

Adding Quotations and Brackets to format of cell conditionally

I have three columns: Word | Formatted Word | Type Chicken |................| Noun Running |................| Verb If the word in A2 is a Noun, I would like B2, the formatted word, to look like ...
0
votes
0answers
46 views

.XLSM file has sharing violation when saving during remote desktop use

I have a large (~5mb) multi sheet excel macro file *.xlsm stored locally on my laptop. While using the file I occasionally connect to my office via remote desktop to do unrelated work. If I make a ...
12
votes
1answer
23k views

Allow two possible values in an Excel cell

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell. How could I do this?
0
votes
4answers
7k views

How can I sort my data while keeping paired rows together?

How can I pair two rows on a spreadsheet, so that for each data entry I can sort the matrix but the pair of rows moves as a single list of data, retaining the structure of the two rows? For example: ...
2
votes
1answer
32 views

How to open the Save As dialog and save as PDF

I have the following code, which gives the option to the user in the end to "Print" the worksheet I wish to modify it. The user should be asked if we wants to "Export it to PDF", if he selects "Yes", ...
1
vote
3answers
39 views

How to count occurences of strings in a cell using VBA

Sub Test() Dim countMe As Integer countMe = Sheets("Data").Range("B1").Formula = "=LEN(SUBSTITUTE(B1,""|"",""""))" Sheets("Data").Range("C1").Value = countMe End Sub What is ...
0
votes
0answers
31 views

Delete duplicates and keep the row with more data

I have a spreadsheet with duplicate IDs in Column A. In columns B, C, and D, I have consent form dates. One duplicate will always only have a date in column B whereas the other duplicate will have the ...
-1
votes
0answers
21 views

Excel table / form data transfer

(Sheet 1)I have a table with tons of lines. (Sheet 2)Data is entered in a cell in a form that looks for a specific line in the table on sheet 1 using Index/Match and fills in lines in the form. ...
0
votes
1answer
5k views

How to customize Paste Value Excel Short Cut

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code. I would like to set the keyboard shortcut to Ctrl d but Excel pops up an ...
1
vote
0answers
24 views

Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...