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

268 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

**4**answers

13k views

### Cell colors change when copy&paste in Excel 2010

We have a 3rd party tool that creates an Excel file (xls, 97/2003 format) and formats some cells in different colours. When I copy a range of cells into a newly created file (xlsx, 2007/2010 format) ...

**2**

votes

**1**answer

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

54 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

83 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

227 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

99 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

75 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

69k 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

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

25k 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

13k 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

33k 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

271 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

864 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

713 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

273 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

54k 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

45 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

35 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

157 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

56 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

444 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

88 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

202 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

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

**0**

votes

**1**answer

874 views

### Excel: identifying if all values in a row are not equal

I am comparing setting files between devices and have loaded all the settings into an excel sheet.
I want to see if any setting is deviating between the devices.
Example:
Setting1: ok ok ok ok ...

**0**

votes

**1**answer

923 views

### How to combine values from multiple rows into a single row using module?

I'm looking to combine multiple rows into a single row based on a value in the code column.. I've noticed other questions on here similiar to my question but I cannot seem to extend the range..
Code ...

**0**

votes

**2**answers

94 views

### How can I filter data based on items in a list?

How can I filter entries containing any specific word in a list of words? For example, I have a list of road names in Singapore.
Amoy Street, Singapore
Ann Siang Hill
Anson Road
Arab Street
Armenian ...

**0**

votes

**1**answer

77 views

### Conditonal sum in Excel

I would like to write the formula (in OpenOffice, but I imagine it won't be any different than Excel) to perform the following calculation:
-> Go through the values in column B from B1 to B30 and add ...

**0**

votes

**1**answer

142 views

### Associate a file type to a specific Excel workbook

I have a special extension (.dia) for storing electricity diagrams. Inside these files are binary, created by an Excel library (.xlam). For fast viewing of a diagram, I would like to bind the .dia ...

**0**

votes

**3**answers

3k views

### Excel: how to count number of distinct values in a range with condition?

I read and tested quite a lot, but I still not able to come up with a solution for my problem.
The close solution I found is the second one proposed in article below:
Excel: how to count number of ...

**0**

votes

**1**answer

82 views

### Excel gives error whenever I paste a code with “,”

My excel is refusing every code that I paste that has "," (comma) (like to separate arguments). What could be the cause, could it be because my PC region is Brazil and excel is in english? It seems to ...