**0**

votes

**1**answer

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

**2**

votes

**0**answers

11 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

**0**answers

27 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

23 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

**0**answers

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

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

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

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

**0**

votes

**0**answers

16 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

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

**0**answers

10 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

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

**1**answer

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

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

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

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

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

**1**

vote

**0**answers

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

**0**

votes

**0**answers

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

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

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

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

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

**0**answers

32 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**

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

**1**

vote

**0**answers

18 views

### Excel converting data entered to 10% of correct value

I am having a problem with all of my ExcelWorksheets. Any number that I Type into a cell is converted to 10% of the value I typed. For instance, if I type in 100 into a cell, the data displayed is ...

**0**

votes

**1**answer

11 views

### Nested Ifs for personal accounting sheet

I have a personal accounting sheet with 5 columns. C is Debit, D is Credit and E is Balance. I want to do 3 things but I've been confusing myself for the past hour.
If C5 and D5 are both blank, ...

**0**

votes

**0**answers

23 views

### ISO Weeknumber formula explanation

can anyone breakdown this ISOWeekNumber formula and explain to me in detail how it formula works?
=INT((A1-WEEKDAY(A1,2)-DATE(YEAR(A1+4-WEEKDAY(A1,2)),1,4))/7)+2
and this one?
...

**0**

votes

**0**answers

8 views

### Sort a pivot table according to % of Row Total

My pivot table compute the sum of sales amount of products in different regions (row field) according to product type (column field). The values which we want is the % of Row Total (so that we can ...

**-1**

votes

**1**answer

24 views

### Why the excel file of xml sized large ,is it there any way to reduce it?

i am trying to open 9 MB excel file in open office calc,it takes lot time ,so i opened it with archive manager to find whats wrong with the excel file
While opening it with archive manager i could ...

**0**

votes

**2**answers

30 views

### In Mac Excel 2011, how to format cell as percentage or currency based on content of another cell?

As far as I can tell, the Conditional Formatting feature doesn't support percentages. You can format styles (color, font, etc.), but not the actual content presentation itself.
I have two columns, ...

**1**

vote

**3**answers

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

**-2**

votes

**0**answers

17 views

### why doesn't auto row height work in excel? [on hold]

I type some text into a cell and hit enter, and part of my text is hidden. This is extremely evil because I write procedures that can cost a fortune if you do half the step. So I select all the rows ...

**3**

votes

**1**answer

38 views

### Excel — Tell whether a string contains any value in a table column

Background
I'm using Excel 2013.
I have an Excel table named SiteCategories, with a number of Category columns, and then sites in those columns, like so:
So we could get to those values using ...

**0**

votes

**0**answers

12 views

### Creating Excel range given start cell and row/column offset, in Applescript [migrated]

I am trying to use Applescript to insert values into cells in an Excel worksheet. The values are held in an Applescript variable as a list of lists (see example code). I've already worked out that if ...

**0**

votes

**1**answer

28 views

### Special format of date in excel

A customer wants a special format of a date column in excel.
What he wants is that the date (for example 02.06.2014 and formatted as short-date) changes to a number (41792) when the format changes to ...

**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", ...

**0**

votes

**1**answer

30 views

### Excel T88 error

When a client opens an Excel 2013 file she will get this error.
I have tried to reset Excel and also an Office 2013 Repair but to no avail. Any ideas on what creates this?

**2**

votes

**3**answers

79 views

### How would I increment an alpha field in a table

I would like to increment an alpha field in a table.
a000001
a000002
a000003
a000004
etc.

**1**

vote

**1**answer

23 views

### How can I run a macro changing the value of the cell (no carriage returns)?

I can run a macro whenever a value is changed in a cell. However, I have to press the carriage return button to change the value of the cell. Is there any way to run a macro whenever I press a single ...

**-2**

votes

**1**answer

26 views

### How to transpose range in Excel through insertion of new lines?

My data looks like this:
a 1 2
b 1 2
c 1 2
I want to reorganise it so it looks like this:
a 1
a 2
b 1
b 2
c 1
c 2

**1**

vote

**3**answers

34 views

### How to find average of first difference in one set of column excel/google docs?

I have one column with numbers eg. 130, 131, 135, 140, 120.., I would like to find the differences eg. 131-130, 135-131, 140-135.. and find their average without using another column to find the ...

**0**

votes

**0**answers

13 views

### Excel SQL Sort Greyed out

I have an excel sheet with multiple Teradata connections. I am trying to sort/filter the data by description, but I am unable to as the sort/filter button is currently greyed out. I need to keep the ...

**0**

votes

**1**answer

20 views

### Excel 2010 adding to an adjacent cell

I want to add B3 to C3 leaving the answer in C3, I have tried =C3+B3 in C3, a message regarding circular references, I continue and the result becomes a zero

**0**

votes

**2**answers

24 views

### Copy multiple cells (not in range) from one sheet to another sheet

I've searched all over, and I'm unable to find anything regarding copying multiple cells from different rows & columns to a single row in another sheet.
Eg, Copy Cells, A10, F2, F3 & F34 from ...

**4**

votes

**1**answer

33 views

### How to customise labels on a secondary axis to show student progression as a flight path in Excel?

I am trying to create a line graph in Excel that plots a student's actual progression against their predicted grade. The type of graph is called a 'flight path'. This is represented as two lines on ...

**1**

vote

**1**answer

12 views

### Replace the value of a column based on the a matching value of a adjacent columns

Basically I want to replace the values of the 4th column with the numbers on the second one based on the matching country names.
Country Name Country Code Country Name Country Code
...

**1**

vote

**1**answer

23 views

### conditional formatting based on another value

I need a way to conditional format cell B based on the values of cell A.
Basically I need B to be:
Green if the values are in the same day and within the same hour of A.
Yellow if its one hour ...

**1**

vote

**1**answer

9 views

### How do I use Excel 2011 Personal Macro Workbook?

I realized I asked about excel 2010, but that only covers Windows OS. How can I use the Personal Macro Workbook in Excel 2011 on OSX?