**2**

votes

**2**answers

960 views

### Excel - Sum values if their row meets more than one criteria

I have a spreadsheet of my bank account transaction history in this format:
| A | B | C | D
1 | Date | Amount | Balance | Category
2 | 2013-03-10 | $ -10.59 | ...

**2**

votes

**3**answers

17k views

### Excel ran out of resources while attempting to calculate one or more formulas

I received the error message
"Excel ran out of resources while attempting to calculate one or more formulas"
on ONE of my computers (Out of 2).
My worksheet contains: (Inside a single worksheet, not ...

**2**

votes

**3**answers

20k views

### Count unique names in excel column range

I have an excel spread sheet that contains a list of server names in column B.
The server names appear multiple times in this column.
I would like to count the number of unique server names in a ...

**2**

votes

**1**answer

9k views

### Compare 2 text cells and show difference in the third cell

If cell A1 = abcd, cell B1 = abcdefg, then what formula to use in order to get the text difference efg?

**2**

votes

**1**answer

2k views

### Using Excel Linest function with blank cells

I need LINEST function to be applied with blank cells to get the slope parameter as well as the associated standard error. I can get the slope parameter with a normal function that may resolve the ...

**2**

votes

**3**answers

9k views

### Ctrl + Shift + Arrow stopped working

When I work with a big amount of data, I introduce formulas in Excel by using the shortcut: Ctrl+Shift+arrow. That shortcut allows me to select a whole set of data to the left, right, up or down. ...

**2**

votes

**6**answers

32k views

### Missing Paste special options in Excel 2010

I have a weird problem with the Excel. Every time I copy and paste only the text is copying and the format is not copying as shown in the below figure. There are no paste special options available ...

**2**

votes

**9**answers

22k views

### Excel freezes when copying / cutting to paste elsewhere

When cutting/copying some cells to paste them into another sheet/page, sometimes Excel freezes/locks up and fades out. At the top toolbar it says in brackets "not responding".
Eventually, I must ...

**2**

votes

**2**answers

8k views

### Export to CSV From Excel

I frequently use Excel to prepare data to load into a table. I create a CSV file from it and use that file for data loading. I generally find myself creating the CSV file multiple times.
My current ...

**2**

votes

**1**answer

3k views

### Excel count coloured cells

If i have 500 cells filled with red, 500 filled with green and 50 filled with yellow, is it possible to do a countif sorta formula where i will have a cell which will count the number of red cells, ...

**2**

votes

**1**answer

273 views

### Is Workbook.FileFormat available to the Excel UI (specifically when the file type can't be saved)

As a programmer I eventually located the file type of a .d extension file loaded successfully by Excel 2007 by interrogating Workbook.FileFormat via VBA, but can a normal user determine it is a DBF4 ...

**2**

votes

**1**answer

8k views

### Strip out all HTML Tags from an excel file

I have an excel file that has cells with text that includes HTML tags.
The data was exported from a database and the HTML tags were included.
The HTML is stored as text, but I need it gone.
Is ...

**2**

votes

**2**answers

6k views

### How can I change a cell's background color based on the cell's current value?

I have a column with function values of True or False:
=IF(ISNA(A1), false, true)
from row 1 to 5000+ rows. I would like to mark all the False as red background color or text as red. Is there any ...

**2**

votes

**4**answers

11k views

### Filling cells with sequential numbers in an Excel (2003) macro

I need to fill an excel column with a sequential series, in this case from -500 to 1000. I've got a macro to do it, but it takes a lot of lines for something that seems like it should be a single ...

**1**

vote

**1**answer

56 views

### Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...

**1**

vote

**2**answers

131 views

### I need todays date to auto fill in cell when data is entered into another cell

I would like to have cells C5-C39 auto fill the date when data is entered into cells B5-B39. I have tried to get it to work using =TODAY() but don't how structure the formula.
Thanks.

**1**

vote

**3**answers

243 views

### How to split numbers into columns with negative and positive values, without empty cells?

Given positive and negative values in column A of an Excel sheet, I want column B to list the positive values from column A, and column C to show the negative values, in the order in which they appear ...

**1**

vote

**1**answer

32 views

### can someone help me with my Formula Excel need it show blank

=IF(NOW()-B4>=15,"OK","Warning - Time to Renew")
that is the formula, but can it stay Blank until a date is put into cell B4
thanks

**1**

vote

**1**answer

107 views

### Dropdown, multiple values in dropdown

I'm trying to make something for my hobby, and for that I was wondering on how to do it:
These are my input values:
And via dropdown you can choose one player and it autofills the other values:
...

**1**

vote

**1**answer

81 views

### Excel autofill problems

I am an advanced novice at using Excel and I have a problem.
I am using 2 worksheets and want to refer cells from sheet1 to sheet2.
In sheet1 (named "Aktuel") I have a list of all my costumers' ...

**1**

vote

**3**answers

1k views

### Excel function working like SQL group by + count(distinct *)?

Suppose I have an Excel sheet with below data
CODE (COL A) | VALUE (COL B)
==============================
A01 | 10
A01 | 20
A01 | 30
A01 | 10
B01 | ...

**1**

vote

**3**answers

1k views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**1**

vote

**1**answer

75 views

### How to create multiple rows combining data sets

I have three tables and i need an out put which has data from two tables, i would like to create the same using macro.
Table A
A
B
C
D
Table B
Apple
Orange
Pears
Table C
Americas
Asia
Europe
...

**1**

vote

**3**answers

73k views

### How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...

**1**

vote

**2**answers

20k views

### Looking-up the values of one worksheet in another worksheet

Basically, I could do this manually, but as the data is huge, it would take a lot of time. I am sure there must be a formulaic way of doing it.
I have two worksheets in Excel.
Worksheet 1.
Column-A ...

**1**

vote

**1**answer

4k views

### How to get relative worksheet references when copying formulas in Excel?

I have a workbook containing two types of worksheets. One type is 12 worksheets, each referring to a month (JAN, FEB, MAR, etc.) Then I have another type of worksheets referring to employee's time ...

**1**

vote

**4**answers

27k views

### Extracting Data Between two Characters in Excel

I have the following format in Excel and I am trying to extract the data between the characters:
First Last <flastname@xxxx.com>
I need to extract the email address between < and > into ...

**1**

vote

**2**answers

14k views

### Excel Date Formula - Return the next specified day of the week

I need a formula that will always return the next specified day of the week.
For instance
IF(A1="A",RETURN NEXT FRIDAY, IF(A1="B",RETURN NEXT TUESDAY.....ETC
The reason I need this is because I ...

**1**

vote

**2**answers

34k views

### If an Excel row contains particular words, return that row, highlight that row, or give Y/N for that row

I have a sheet containing thousands of cells in a column. These cell contains names of different securities.
Some names of these securities contains a particular string such as "C/O".
How can I use ...

**1**

vote

**1**answer

1k views

### Excel array formula for max with multiple/ variable criteria

G'day there,
I have a sheet that contains 365 rows, representing dates from a referred Start Date (for the following year). There are about 30 columns each of which has an agency name.
The cells in ...

**1**

vote

**2**answers

3k views

### Excel: Merge two tables based on one column

I have two Excel 2007 sheets A,B with the same columns.
B contains less rows, but has a column with updated data (i.e. data in this column is newer than in the same column in A). I want to take every ...

**1**

vote

**2**answers

2k views

### View linked Excel 'Windows' on separate screens

A colleague had a problem where he couldn't link a cell in his destination workbook with a series of cells in a source workbook. The problem was that in order to link workbooks, he had to open them ...

**1**

vote

**1**answer

7k views

### How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X

I have a CSV file which I can open and view the column with Chinese letters normally with TextMate.
However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...

**1**

vote

**2**answers

9k views

### Text values in a pivot table?

I have a table (in MySQL) with 3 columns:
Location Category Supplier
A Computers Company X
A Printers Company Y
B Computers Company X
B ...

**1**

vote

**3**answers

7k views

### COUNTIFS does not seem to count blank cells

I am trying to build a COUNTIF statement in Excel 2010 using a total of 4 sets of criteria. I would ideally like it to look something like this:
COUNTIFS(range1,value in a1,range2,value in ...

**1**

vote

**1**answer

275 views

### conditional formatting of entire row from a cell's value in that particular row in Excel 2007

I have viewed the answer for a similar question. If I have several rules for a particular row, (e.g. if cell A2 is 1 then the row is red, if 2 then row is blue, if 3 then row is green, etc...). Having ...

**1**

vote

**2**answers

875 views

### Excel conditional formatting of row

Can someone please tell me how to highlight multiple cells in a row based on some values in any one of a given number of cells?
For example, if in Row 2 any of the cells from D2 to L2 have value "A" ...

**1**

vote

**1**answer

723 views

### Spreadsheet formula to count consecutive values in a column

I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this:
Y
Y
Y
N
Y
N
Y
Y
the desired result would be 2
Y
Y
...

**1**

vote

**2**answers

275 views

### I have a sheet that has 2 cols; in one is the name, in the other there are one or more emails, separed by comma

I have an Excel worksheet that has two columns, in one is the name, in the other there are one or more emails, separated by a comma.
Now, I want to get two columns with repeated names but unique ...

**1**

vote

**2**answers

55k views

### Excel - Formulas that total across multiple sheets?

I am trying to make a spreadsheet to handle my monthly budgets. I have very little experience in Excel 2011 and I know there are pre-made templates already but what I need is very small in comparison.
...

**1**

vote

**1**answer

1k views

### Delete Duplicate Rows?

I have a column in an Excel spreadsheet with several hundred entries, and some of these entries are duplicated.
I would like to remove all duplicate entries from the column so that each entry ...

**0**

votes

**1**answer

50 views

### How to preserve custom number formatting after closing a workbook?

I have created a custom format ##,##0.0,,, CTRL+J %% in Excel 2010 to display
10000 as 0.1
100000 as 1.0
1000000 as 10.0
10000000 as 100.0
100000000 as 1,000.0
and so forth.
The problem I am facing ...

**0**

votes

**1**answer

37 views

### Select text to display based on matching a symbol in another row

How do I write this excel cell formula?
In Row 1 is a list of words and they each correspond to an "!" or an "X" in Row 2. Only one word is given an "!".
[A] [B] [C] [D] [E] ...

**0**

votes

**1**answer

195 views

### How to fill down formula so that range references are offset by 5 rows rather than by 1 row [duplicate]

How can I get Excel to increment ranges arguments by more than one row when I fill down a formula?
For example, if I want Excel to keep averaging the next five numbers in a column, how do I set the ...

**0**

votes

**2**answers

60 views

### How to assign rows in multiples of a number (Excel/Google Docs)

For example, I want the first entry in Column B (B1) to show A5, then B2 shows A10, then B3 shows A15.
How would I go about doing this?

**0**

votes

**5**answers

474 views

### Pivot table - Summarising multiple independent data columns

I have a large table containing daily inputs into a system, which has the columns as shown:
Day Itemname1 Itemquant1 Itemname2 Itemquant2 .....
The item names and quantities are independent of each ...

**0**

votes

**1**answer

93 views

### Clever way to connect multiple images to on-click macro - VAB Excel

I have asked this question before, but admittedly in a terrible way, so I am asking this again. So here I am once more.
I am making a program in VBA Excel - or better, combining a certain worksheet ...

**0**

votes

**2**answers

214 views

### Calculate date and time differences in Excel

I am trying to use Excel 2013 to put together a workbook for timesheet tracking. As an example, time worked yesterday needs to be entered by 10:00 AM on the next business day. Weekends become ...

**0**

votes

**1**answer

230 views

### Excel count all rows that contain certain values for certain fields

I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of ...

**0**

votes

**1**answer

2k views

### Indirect function for worksheet names in Excel?

I am wondering if there is an equivalent to the indirect function for worksheets or workbooks instead of cells. What I mean by that is I am updating a rather large and unwieldy workbook for payroll ...