A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

0
votes
3answers
2k views

Excel: How to sum values in a column based on multiple criteria

I have a list of criteria in row 20, like this: A20: "My Company, Inc." B20: "Client Expenses" C20: "Travel" The data is below, like this: B40: "Client Expenses" C40: "My Company, Inc." D40: ...
0
votes
1answer
5k views

formula for exel to calculate how many days from speefic date untill today?

is there is any formula for exel to calculate how many days from specific date until today ? for example if i wrote in column A 31 july so from 31 july until today it's 4 days i don't want to ...
1
vote
1answer
111 views

Extending a range of fractions

I'm trying to fill a range with fractions i.e. 1/3, 1/5, 1/7, 1/9 etc. When i try to drag the fill handle down it gives me all kinds of odd results. e.g.-1/8, -1/5, -2/7 etc. Any ideas on how to get ...
3
votes
1answer
4k views

Is there a way to copy an Excel worksheet without copying all of the cell styles in the source workbook to the target workbook?

The title pretty much says it. I have an Excel document with tons of randomly named styles that I didn't create but that I want to copy a worksheet from. When I do, it drags all of those styles into ...
2
votes
1answer
1k views

What date formats does Excel recognize as dates?

What date formats will Excel recognize as dates? I've been using Jul 30/10 11:41:10 but Excel doesn't recognize this as a date. I don't want to apply a function to the value, I just want to open ...
3
votes
2answers
6k views

Excel: Pie Chart of a Question with Limited Possible Responses

I distributed a survey online and received the answers in an Excel spreadsheet. I would like to make a pie chart out of some of the closed option answers. For example, one of the questions was gender. ...
0
votes
1answer
75 views

Excel 2007: help with a formula

I need to implement the following function/formula in Excel 2007 which would give me the following: for x<0.68 y=0 for 0.68<=x<0.81 y=1 for 0.81<=x<1 y=2 for 1<=x<1.25 y=3 for ...
4
votes
2answers
3k views

Excel Trailing Spaces

I have a column in an excel document that each entry has a trailing space. When I copy/paste the value into another form I have to manually remove the trailing space. Is there an easy way to batch ...
3
votes
2answers
112 views

Reverse-tracing a list of numbered items

Is there a programmatic, hopefully non-macro way to reverse-trace a set of numbered items? Example: The first two columns are ones which data is entered in. You can see that item A has a ...
2
votes
1answer
2k views

Aligning two tables in Excel on unique keys

I have two tables with the same columns. Each table has a "name" column (unique key basically) and two amount columns. Each name may appear in either or both table. What I want to do is align them ...
0
votes
1answer
677 views

Pulling only one piece of data with an Excel web query?

I have a bunch of data in the format: somedata,otherdata,dataparameter in an Excel spreadsheet. Dataparameter combines with a URL to get me to a page that has a piece of data I want to suck into ...
1
vote
1answer
317 views

Pie Chart in Excel

I tried to google this but no luck. It is easy to add a pie chart when you have prcentace data but what if you just have a list of partially repeated data? For simplicity imagine there is a table in ...
1
vote
1answer
920 views

Hiding and locking a column in Excel

We have performance appraisals in Excel format for all of our employees. Employees use one column to rate themselves and their director uses another column to rate them. The idea is to have the HR ...
15
votes
1answer
23k views

Saving a file in a CSV type in Excel always removes the BOM

I've been trying to find a reasonable solution/explanation (unsuccessfully) to find out why Excel defaults to removing the BOM when saving a file to the CSV type. Please forgive me if you find this a ...
3
votes
2answers
3k views

How do I copy a worksheet without creating local copies of workbook-scoped named formulas?

I have a workbook with some workbook-scoped named formulas. When I copy a worksheet that has some (different) worksheet-scoped names, the copy ends up also having worksheet-scoped names that are ...
5
votes
2answers
22k views

How to change font color in Excel based on cell value?

How do you change the font color of a column of cells based on their entered value? I've got a column with the heading at row 1 and the values starting at row 2 going on down. I want to change font ...
1
vote
4answers
4k views

excel / google spreadsheet: count substring occurrences within a cell

I've been scratching my head trying to figure out a way to count the number of occurrences of a substring within a cell. For example: | | A | | 1 |John,John,Tom,David| What ...
0
votes
2answers
5k views

How to have sequential numbers keep writing themselves?

At work, we use Microsoft Office 2003, and we have to write many numbers that are sequential, e.g. 2590, 2591, 2592, etc. These numbers are either in Excel or in a Word table. How can I ...
1
vote
1answer
3k views

Getting VBA error when opening Excel 2007 on new computer

I have a user with a new computer that whenever Excel is opened gives the error message Opening the VBA project in this file requires a component that is not currently installed The message is ...
2
votes
1answer
981 views

Embedded Excel table in Word doc is getting blacked out when printing to PDF

I am working with a client that has a Word doc that has an Excel table in it. When the user tries to print to PDF using PDFcreator or Acrobat the table gets blacked out in the PDF. Does anyone know ...
3
votes
1answer
3k views

Hyperlink in Excel

I am using MS Excel 2007 (previously familiar with Excel 2003). I create a simple hyperlink in cell A1 (in sheet Sheet1) so when I click cell A1, the cursor moves to cell B10. It's very easy, no ...
0
votes
2answers
521 views

Excel: counting unique phrases, separated by slashes

I have some Excel data that looks a bit like this: John / Tim Upheld Sam Upheld Tim / Dave Upheld Sam / John Not Upheld Tim Not Upheld Dave / Tim Upheld ...
7
votes
1answer
20k views

Count number of rows with conditions met in two columns

I have some Excel columns that look like this. 1774 David Not Upheld 1770 James Upheld 1771 David Upheld 1772 Sam ...
10
votes
2answers
88k views

What is the difference between function and formula in Excel?

What is the difference between those two when speaking of Microsoft Excel?
2
votes
1answer
2k views

Parse Excel Column, First Name (<optional>)Middle, Last name into 3 columns?

How do you parse Excel Column, First Name ()Middle, Last name into 3 columns? Ivan P. Freely Jordan Smith How would you parse the above Excel column list of full names into 3 distinct columns with ...
29
votes
17answers
130k views

How to make cells perfect squares in Excel?

In Microsoft Excel, I want to make the height of first three rows and first four columns (12 cells in the top left corner) such that these cells are squares. How can this be done? Surprisingly, ...
0
votes
1answer
108 views

How do I ensure only integers and with no duplicated values can appear in a column in Excel 2007?

How do I ensure only integers with no duplicated values can appear in a column in Excel 2007?
0
votes
4answers
1k views

Difference between CSV in Excel and CSV in OpenOffice.org

There are different implementations of Comma Separated Values; two of them are Microsoft Excel and OpenOffice. Is there any difference between these CSV implementations? For example both can open ...
1
vote
3answers
5k views

How to input only unique values in a column in Excel 2007

I'd like to know the easiest way to make sure that only unique strings are entered in a particular column in MS Excel 2007? I know I have to put a formula in the Data > Data Validation, but I don't ...
3
votes
2answers
3k views

Microsoft Excel - Copy Pasting while maintaining reference to a single cell

Let's say that I have a value in cell A5 that is being used to calculate a value in A3. Example: A3 = (A1 + A2) * A5 When I copy paste cells A1:A3 and paste onto B1:B3, I'd like the resulting ...
1
vote
1answer
3k views

Excel or open office calc how to remove last white space? [closed]

Excel or open office calc how to remove last white space?
-1
votes
1answer
1k views

How to make this formula to work in Excel 2007?

How would one make this formula =MAX(LEN(A2:A9)) work in Excel 2007? I want the value of the longest field in A2:A9 range. I found this link: http://www.mrexcel.com/td0021.html, but it's old now.
0
votes
1answer
1k views

Small but full featured xls (Excel) reader for Mac OS X?

Is there a program that allows me to not only read the contents of an Excel spreadsheet on a Mac without being a large download? I presume OpenOffice does it, but I don't have the bandwidth to ...
1
vote
4answers
10k views

Does Excel have a row filtering function (more general version of SUMIF/COUNTIF)

SUMIF and COUNTIF functions are handy for simple SUM and COUNT operations on only some of the values in a range, but is there a more general version that would allow me to plug in any other function I ...
3
votes
1answer
17k views

Embed Excel sheet in Word 2010

I wanted to know if there is any way of doing the following in Word 2010. I want my sheet the whole Excel sheet to be able to paste it into Word document. Whenever I modify the data in the Excel ...
0
votes
3answers
1k views

How to open text files in excel

I have a large text file and I want to open it so that it appears as columns in excel 2003. When i open it though the columns are lost and its all one horizontal line? Help
0
votes
3answers
550 views

how i can put last column contain value in 1 cell in excel

how i can put last column contain value in 1 cell in excel? i have figures from F4 to F83 ( each week the last figures will be in different cell between 4 and 83 - for exp this week it's was 82 rows ...
3
votes
5answers
31k views

Excel - Delete specific word in each row?

Is there a way to have Excel delete a sepcific word in every row? For example, each row says Mr. and Mrs. {first name} {last name}, and I want to delete the {first name} from each one. (Or ...
2
votes
1answer
868 views

Divide pivot table data by an arbitrary column in another table

I have this data from a pivot table: Countries P1 P2 Total Country 1 10 69 Country 2 36 2 92 Country 3 21 24 100 Country 4 22 77 Country 5 13 79 Country 6 12 1 ...
7
votes
3answers
33k views

Import json data into Excel

I have a text file in json format and want to read it into Excel. A very simplified example of the json file has the following structure: { [ { 'a': 10, 'b': 20 }, { 'a': 20, 'b': 22 }, { 'a': ...
63
votes
4answers
144k views

How to expand all columns in Excel spreadsheet?

I have a spreadsheet with many columns. The columns are all a small standard width. Double-clicking the partition line between columns will expand the column width to encompass the longest string in ...
1
vote
2answers
4k views

Excel how to reference a list

Say if I have a list A1:E5 and I want have reference 2 columns of the list, say B and D. So it will looks like: A B C D E G H (reference to B1:B5 and D1:D5) 1 a b c d e b d 2 ...
0
votes
1answer
1k views

Excel : How to display a list if value not equal to zero from another list

Say source data is like: col1 col2 a1 2 b1 b2 2 c1 1 d1 d2 2 d3 I want to make another list that looks like: col1 col2 a1 2 b2 2 c1 1 d2 2 How ...
1
vote
3answers
14k views

Excel bar chart - how to make axis as time scale

My data has column 1 = date (date format), column 2 = quantity (number format). The data looks like: date qty 1/3/2010 5 2/3/2010 2 2/4/2010 3 2/9/2010 1 4/13/2010 5 5/31/2010 5 ...
0
votes
1answer
7k views

Excel 2007 - Can you give groups names?

I want to group a set of rows then hide them. Once hidden can you make it display some sort of text message. Like right now it just hides the rows. It is not very obvious that the rows are hidden. ...
1
vote
1answer
152 views

How to set the focus on a comment in Excel 2007?

In Excel 2007, is there a way to "focus" on a comment? In an IDE, you would do this by pressing F2 for those familiar. One example of the issue is with Freeze Panes. Say for example: I have ...
0
votes
1answer
199 views

Excel formula - sometimes array formula, sometimes not

I want to write some data to an Excel file, and I want the first page to show a summary of the data that are spread all over the sheets. The individual data items on a sheet can be included or ...
2
votes
3answers
3k views

Excel 2007 using web services (specifically Google Finance)

Can Excel 2007 access web services, specifically Google Finance or Yahoo Finance? I'd like to be able to have my workbook automatically update share/fund prices from either of these sites. I know ...
1
vote
1answer
4k views

Excel: Filter on column merged downwards

I have an excel spreadsheet with 3 columns. The first column is merged downwards to be the length of the other cells and contains a document name. The other 2 columns contain an id and some text ...
3
votes
4answers
2k views

Export to csv options using Numbers

I'm using Numbers on my Mac at the moment and exporting to a CSV file. Is there a way to enclose every value with ""? For example I'm getting the csv file like this: 1,2,3,4,5,6,7,8,9 When I ...