The 2003 version of Microsoft's spreadsheet application.

**2**

votes

**2**answers

30 views

### How to find the last value in a column in excel?

I am tracking rooms booked in a hotel on a daily basis in Excel. Every day I input the number of rooms booked in a column to show a trend of pick up over a period. I'd like to return the value of ...

**0**

votes

**3**answers

44 views

### How do I stop a mail merge from adding zeros to the end of amounts of currency?

I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. When I complete the merge, the amounts have ...

**-2**

votes

**2**answers

27 views

### How do I convert list to table in Excel 2003

I have a list:
date item name quantity
1.7.2014 A 5
1.7.2014 B 2
1.7.2014 C 10
2.7.2014 B 5
3.7.2014 A 1
...

**0**

votes

**0**answers

20 views

### How do I pull rows from one sheet to another sheet automatically as data changes?

I currently use excel to create a shopping list to make it easier at the store. All rows have an item name, cost, and total based on the qty entered in the A column. Is there any way (with little to ...

**0**

votes

**1**answer

36 views

### How to display particular workbook of Excel file on TV and no matter what i do on the computer the TV displays the workbook [duplicate]

I have a computer and a TV.I want to display particular workbook of excel file on the TV ( monitor 2 ) and when I work on my computer monitor ( Monitor 1 ) nothing happens on Monitor 2.I need that ...

**1**

vote

**1**answer

46 views

### Retrieve previous version (backup file) of Excel file?

I made some incorrect changes and clicked 'Save' in MS Excel. 'Undo' failed.
Excel does not have an option to create backup files, like MS Word does.
The AutoRecover option saves files in ...

**0**

votes

**1**answer

31 views

### Search from bottom with multiple criteria

I am trying to search a data table in excel and find the bottom most row that meets a specific criteria. I thought I could use this LOOKUP trick but it only returns a #DIV/0 error. This is what I ...

**0**

votes

**0**answers

29 views

### Why is the maximum row height in Excel 546px?

The maximum height of a single row in Excel 2003 is 546 pixels, or 409.5 points:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx
I'm curious as to why ...

**0**

votes

**1**answer

108 views

### VBA Lookup by Multiple Criteria - Then Copy & Paste

Currently I have a 2 way database with 10+ fields and 1,000+ rows. Some fields are customer name, car model, year of model, price, date of purchase.
I would like to lookup rows of data by multiple ...

**0**

votes

**0**answers

9 views

### Use custom undefined color in Excel 2003

I want to change background of the cell. I click the icon in the toolbar to do that, but only pallete of predefined colors is offered:
But I want my own, custom color which is not present in the ...

**0**

votes

**0**answers

29 views

### Excel 2003 Issue: Row Height Issue After Autofiltering

I'm using Excel 2003 right now, and have constructed a spreadsheet that features merged and unmerged, multiple cells in each row. Each cell, merged and unmerged, has their row height manually ...

**0**

votes

**1**answer

60 views

### Spread Sheet Formula for Time Study

I need to create an excel spread sheet. I am doing a time study. ( The time a project was started to finish) I will be entering in times frequently in military time. I havent used excel for years and ...

**1**

vote

**0**answers

107 views

### Extracting and collating data from multiple columns in Excel 2003

First of all I have tried a lot but failed to get a solution for the following problem and I hence request all the superusers to help me with their best if possible....
I tried unpivoting but it did ...

**1**

vote

**1**answer

79 views

### Excel: INDEX and MATCH on rows matching criteria

I want to write a formula that will do the following:
Search for a POS in column C in rows where ID=ID. If a POS is found, output "yes" in the haspos? column, otherwise output "no".
Here is ...

**0**

votes

**0**answers

27 views

### Why does Excel 2007 change 13 to 14 when typed in?

Every time my co-worker types 13 into an excel cell, excel changes it to 14.
She was using excel 2003 and this was happening. Our tech installed 2007 and it is still happening. We have to use a ...

**1**

vote

**1**answer

191 views

### Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...

**-1**

votes

**1**answer

39 views

### Format of Row in VBA based on 1stCell and also Compare to above row?

I was wondering how would i through VBA conditionally format the whole row or a row in a range based on the first cell in that row? Also it would require a comparison to the previous row to current ...

**0**

votes

**0**answers

28 views

### Excel - Assistance automating the copying of data within Worksheets query

I have an Excel 2003 spreadsheet that contains two worksheets, one contains the following data:
Name#1 (In Column A)
Month-Year (In Column C) Amount (In Column E)
Jan-2011 £12.00
...

**1**

vote

**1**answer

1k views

### How to create an Excel SUMIF formula that can compare different date formats

For my source data I have a column of dates in the dd/mm/dddd format, and a column of values next to it.
eg
03/02/2014 5
17/02/2014 4
03/03/2014 5
17/03/2014 4
On a summary sheet I have a ...

**0**

votes

**1**answer

32 views

### Creating custom autofill with numerical values

Each day of the year has a value which I would like to consolidate by day of the week, i.e. all 52 Mondays consecutively, all 52 Tuesdays consecutively etc. They are recorded chronologically on Sheet ...

**-1**

votes

**1**answer

305 views

### IF clauses with SUMPRODUCT

I'm having trouble understanding the following:
This works:
=SUMPRODUCT(N(A1:A10="Some text");B1:B10)
This doesn't:
=SUMPRODUCT(IF(A1:A10="Some text";1;0);B1:B10)
The N() function converts the ...

**0**

votes

**0**answers

17 views

### Excel 2003, network drive, using hyperlinks to a new drive path

using hyperlinks in Excel 2003 to our G:\ drive where most of our company files are located have always worked but we now have a new drive (N:) and when I try to hyperlink to anything located on the ...

**0**

votes

**3**answers

73 views

### Excel Using Reference for Worksheet names [duplicate]

I've looked around to try and resolve this, however I am unfamiliar with the coding.
Here's my line of code,
='[WorkBook]BOM'!G6
What I want to do is make the Workbook call to a cell so I can mass ...

**0**

votes

**1**answer

24 views

### Excel 2003, How do I sort with spaces?

How do I sort with spaces? I have spaces between my numbers and dates and names and would like to sort without using a VBA formula.

**0**

votes

**0**answers

20 views

### Need solution if cell “A” then show cell “B” from a Dropdown list

My query is,
I have a Cascading dropdown list of types / Sizes -
Types -
Concrete,
glazing,
lining,
Sizes of each
Concrete - 100,200,300 etc
Glazing - 90,110,150 etc
Lining - 75,92,110 etc
All of ...

**1**

vote

**1**answer

118 views

### How to create a two column pick list in Excel

I want to be able to have a pick list with two columns setup in a worksheet and pick from that list in another worksheet to populate two columns.
Pick List Sheet would look like this
A Item 1 ...

**0**

votes

**0**answers

43 views

### MIcrosoft excel 2003 auto populate cells

What I would like is input text into a cell say A1 and I want that text to then be duplicated in cell D1. But I can not type the formula into D1 itself i.e. no =a1.
Is this possible? Thanks

**2**

votes

**1**answer

993 views

### Is there an Excel formula that can conditionally sum rows based on column headers?

I need to be able to put a formula into the last cell of a row (shown by = in the image) that totals the values in that row that don't have a cell with the text 'Done' at the top of the relevant ...

**2**

votes

**1**answer

42 views

### Excel - can't concetanate a concetanated cell

Cell A displays: general20130903.txt
Cell A formula: =CONCATENATE("general",YEAR(TODAY()),TEXT(MONTH(TODAY()),"00"),TEXT(DAY(TODAY()),"00"),".txt")
Cell B is pure text of value: \\asimple\uncpath
...

**0**

votes

**1**answer

40 views

### Data entered into cell replicates in all sheets unneccesarily?

Example: I enter data into sheet 29 cell 7, then cell 7 from 1-31 shows the same data.
How do I undo this? It was not a problem yesterday. There is no formula in the cell.

**0**

votes

**1**answer

391 views

### Excel - compare names in two cells in different order

I need to compare the following
Cell 1 John Peter henderson
Cell 2 peter John Henderson
Result Match
Cell 1 Anne jolie ...

**2**

votes

**2**answers

698 views

### Lost VBA when downgrading from Excel 2013 to Excel 2010

I am on Windows 7. In the past I was using Excel 2003. I installed Office 2013 and found that my Office 2003 was intact and I could run both versions. I made updates to some worksheets using Excel ...

**1**

vote

**2**answers

1k views

### Changing line insert default formatting

When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the ...

**1**

vote

**0**answers

408 views

### Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003.
We are now migrating to Excel 2010, and have encountered the following problem.
When the workbook is opened in 2010 ...

**2**

votes

**0**answers

96 views

### Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003.
We are now migrating to Excel 2010, and have encountered the following problem.
When the workbook is opened in 2010 ...

**2**

votes

**1**answer

193 views

### how to determine which values in a given set of cells will add up to a numerical range

In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers:
1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16
26 ...

**1**

vote

**0**answers

255 views

### Macro to copy and insert rows by variable number

I have an Excel 2003 worksheet with names and addresses, unique per row, to be used for shipping monthly magazines.
Some members receive more than one copy of the magazine, which will be indicated in ...

**1**

vote

**1**answer

180 views

### How do I create a list of phone numbers for people whose reference numbers appear in two columns?

I have two sets of data in columns A & B and also in columns C & D. Some of the content in column C & D does not appear in columns A & B:
A = reference numbers
00001, 00002, 00003, ...

**-1**

votes

**2**answers

156 views

### How to disable exponential format?

My application is generating some Excel sheets from values fetched from a database. Some of the Excel cells with numeric values (more than 6-7 digits) are displayed in exponential form like ...

**0**

votes

**1**answer

76 views

### Close Full Screen window does not go away in MS Excel 2003

I have a problem or bug in MS Excel 2003 where the close full screen mini window does not move or go away. No matter what I do, I cannot move the window or even click any of the options.
I'm ...

**-2**

votes

**2**answers

276 views

### Nested IF formula

I have:
in *Column F* in *Column S*
F2 Monday S2 Orange
F3 Tuesday S3 Mango
F4 Wednesday S4 Grape
F5 Thursday S5 Pawpaw
F6 Friday ...

**0**

votes

**1**answer

8k views

### If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it?

I work with Excel 2003.
If cell B1=1 then DELETE cell A1,
and if cell B=0 then UNCHANGED.
How can I do this?
Example:
http://oi33.tinypic.com/mwsm03.jpg
Many thanks :)

**0**

votes

**1**answer

1k views

### Excel Time Subtraction

I think there is a way around the time subtraction issue I have in Excel. The problem is that when the time in cell F (for example 11:29am) is less than the one in cell A (for example 11:30am), the ...

**0**

votes

**1**answer

183 views

### Excel 2003 Macro runtime error 1004 application-defined or object-defined error

We are using a macro to remove rows of data from our excel 'database' that have been tagged as being completed/done. this is the coding ...
Private Sub cmdRemove_Click()
Dim varResult As ...

**1**

vote

**1**answer

146 views

### Referencing the sheet name is not working [duplicate]

I'm trying to get the sheet name into a cell. I've tried using:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
but my Excel 2003 displays an error when I try to enter the formula. ...

**2**

votes

**2**answers

98 views

### Why is this simple Excel calculation not netting Zero?

It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end.
Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx

**0**

votes

**1**answer

373 views

### Unable to add, create, or remove drop downs on an Excel 2003 spreadsheet

In Excel 2003 the Validation option under Tools is grayed out for a specific workbook. The sheet is not locked or protected, but it is shared. Even the author of the sheet has the Validation grayed ...

**0**

votes

**1**answer

57 views

### Add time to current-row by previous column in an excel column?

I am trying to add 20 minutes to the time in the previous column on the same row, using Excel 2003. Is this possible? I'm having trouble figuring out how to get the current row. I can just use D to ...

**0**

votes

**1**answer

378 views

### MS Excel 2007 Warning Significant loss of functionality

I have created a template in MS Excel 2003. In MS Excel 2007, when I save it in MS Excel 1997 - 2003 format, it gives a compatibility warning;
Significant loss of functionality
This workbook ...

**0**

votes

**1**answer

243 views

### Scatter diagrams with group labels for X/Y coordinates

I'M trying to create a map layout from an Excel spreadsheet in Excel 2003.
I have x and y coordinates in columns as well as group name and place name. I tried using a scatter chart but I can only ...