**0**

votes

**1**answer

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

**3**answers

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

**4**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**4**answers

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

**0**answers

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

**2**answers

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

**4**answers

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

**0**answers

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

**6**answers

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

**0**answers

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

**1**answer

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

**9**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**4**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**3**answers

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

**1**answer

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

**4**answers

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

**0**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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