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)

2
votes
2answers
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
3answers
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
3answers
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
1answer
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
1answer
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
3answers
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
6answers
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
9answers
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
4answers
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
1answer
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
3answers
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
3answers
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
1answer
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
3answers
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
2answers
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
1answer
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
4answers
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
2answers
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
2answers
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
1answer
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
2answers
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
2answers
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
1answer
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
2answers
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
3answers
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
1answer
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
2answers
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
5answers
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
1answer
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
2answers
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
1answer
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
1answer
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 ...