The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
12 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
1answer
41 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
0answers
7 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
0answers
23 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
1answer
21 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
0answers
45 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
1answer
51 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
0answers
25 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
1answer
53 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
1answer
31 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
0answers
22 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
1answer
348 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
1answer
30 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
1answer
65 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
0answers
14 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
3answers
59 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
1answer
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
0answers
19 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
1answer
96 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
0answers
41 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
1answer
569 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
1answer
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
1answer
34 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
1answer
358 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
2answers
533 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
2answers
840 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
0answers
357 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
0answers
76 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
1answer
161 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
0answers
178 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
1answer
154 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
2answers
142 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
1answer
72 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
2answers
248 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
1answer
6k 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
1answer
951 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
1answer
166 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
1answer
137 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
2answers
93 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
1answer
221 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
1answer
53 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
1answer
304 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
1answer
222 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 ...
1
vote
0answers
82 views

How to validate formulas easily in Excel 2003?

When reviewing Excel spreadsheets done by others, I have to do the work of validating all formulas contained in the workbook. It's a frustrating, time-consuming process to trace the quoted cells, ...
0
votes
0answers
28 views

Windows Xp, Excel 2003 automatic start on bootup and yes to update

I need to start an excel file on startup. However when opening the software always ask if the user wants to update the files. How can I get Excel to automatically do this every time?
0
votes
2answers
610 views

excel conditional formatting AND isnumber

I'm trying to get my format sentence to work, but it just won't I want to format the cell green if the cell is greater than the cell before it (and that cell contains a number) I'm trying: ...
0
votes
1answer
475 views

can't select the shape in excel

I have a problem today that is the first time I meet it. I have opened an old file (this file from 2005), then this contain of flowchart which made from excel's autoshape. Then I want to make some ...
1
vote
1answer
124 views

Excel membership list

I have a membership list like this in Excel | A | 02-02-1994 | B | C | D | 04-10-1998 | E | F I want to change it, so it can be ordered by age (the 2nd column) or by name (the 1st column) As you ...
0
votes
2answers
139 views

Incorporate VBA and Copy and Paste

I wonder whether someone may be able to help me please. I'm using the code below to autopopulate a number of columns with pre-defined text when a value is entered into column "B". Option Explicit ...
3
votes
2answers
565 views

How to prevent users to change cells but allow VBA to change them

I'm using a Excel spreadsheet to record staff resource. In column B, there is a value of "Enter your name", which instructs the user where to start entering their information. Then, when the user ...