The 2003 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

38 views

### Excel 2003 - Matching and summarising data across multiple worksheets

I am looking for help regarding my roster calculations.
I have built a roster over 13 worksheets plus a calculation worksheet.
On each sheet column D has a list of names populated from an offset ...

**0**

votes

**1**answer

32 views

### How to fill up gaps in excel

My data in excel has for example the following data in columns A and B:
A B
1 4
2 6
5 88
9 67
12 45
and so on.
I would like to transform it as following:
A B
1 4
2 6
3 0
4 ...

**1**

vote

**1**answer

125 views

### Checking column for value. If true, check same row in another column and count if not blank

I have a spreadsheet of employees. Column A is a list of Dept types (sales, HR, payroll, etc). Column B is the date their appraisal is completed, or blank if incomplete.
I would like a function that ...

**0**

votes

**1**answer

44 views

### How does the user make a selection in MSExcel that contains only those cells that contain data?

Got an MSExcel question for you.
he specs for my computer are: Intel Inspiron laptop i3-2.20ghz , 8GB DDR3, 400GB HDD, Win 7 Prem.
And the version I am using is MSExcel 2003.
My question has to do ...

**0**

votes

**2**answers

38 views

### Excel: Getting #NUM on calc

Why am I getting #NUM error in Excel when trying to input:
=((171757/-201011)^(1/4))-1
It works fine on Wolfram Alpha..

**1**

vote

**0**answers

42 views

### How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel ...

**0**

votes

**0**answers

30 views

### Vertical line excel chart

How is possible to draw in MS Excel (starting from 2003) charts like this
Seems incredible that basic things like this be hard to do in Excel
I read this article but it involves other 2 helper ...

**0**

votes

**0**answers

16 views

### LWD, WTD and MTD Split

All,
I have a list of data and I would like to do a summary table that automatically calculates entries for the last working day, week to date and month to date. Sample below. So in my summary ...

**1**

vote

**1**answer

785 views

### Pivot table 'page fields' usage

In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts by pressing Alt, D, P. In one of steps there is one ...

**0**

votes

**0**answers

57 views

### How do I format numbers with abbreviations in Excel 2003?

In Excel 2003, is there any way to format positive numbers with abbreviations (specifically K, M, & B) while displaying all decimal places but not trailing zeroes like so:
878.1K
100M
1.478B
...

**0**

votes

**0**answers

33 views

### Cannot use Buttons with VBA in 2003 but can use buttons from same sheet in 2010 Excel

I have excel 2003 and 2010 installed on our computers. I reinstalled both, did a system restore. I manually uninstalled all updates from the past month (this started happening 1-1.5 weeks ago) I am ...

**0**

votes

**0**answers

119 views

### Broken ActiveX in Excel 2003

I hope this is the correct forum to post this, I believe this to be an Excel issue.
Ever since I upgraded to Win 7 (64 bit), whenever I try to add an ActiveX control to a worksheet in Excel 2003, I ...

**0**

votes

**1**answer

27 views

### How do I copy list to another spreadsheet only if items have been paid?

I have a list of invoices. I want only the invoices that have been paid to be copied to another worksheet. My column headings are:
Inv. # / Date of Inv. / Amount / Customer Name / Date Paid / ...

**0**

votes

**1**answer

164 views

### VBA Code for changing background text for any text within a cell

I'm trying to make a row change colour to yellow based on if any text is within the D column. I have already set up 5 different colours for another cell, however need this to over-ride those ones. I ...

**0**

votes

**1**answer

682 views

### formatting date time as 01/01/2015 in excel 2003

If I enter 01/01/2015 into an Excel column it gets translated into 1/1/2015. I right click and click on Format Cells... and see that the format is *3/14/2001.
I have some other cells in this ...

**0**

votes

**0**answers

48 views

### Excel Validation Feature to Return Items from a List

I have a list of bank code and bank description in spreadsheet. i wanted to select a bank code from a list and then display the bank's description. How can i perform this ? Sorry im new with excel ...

**0**

votes

**1**answer

35 views

### Microsoft Excel 2003 Sequence numbering

I am in need of working out how to have sequence numbering in the excel database I'm creating.
I am trying to have the following
001/15,
002/15,
003/15...
I am having no luck in getting this to work ...

**0**

votes

**0**answers

75 views

### Show Excel column filter information in cells - Not working

I am on a W7 64bit pro edition, on a Lenovo T420
With regard to Show Excel column filter information in cells, is there a reason why it is not working in Excel 2003?
Thanks in advance
Gilberto
PS
I ...

**0**

votes

**1**answer

186 views

### Import external data connections into Excel 2013 for use in Excel 2003

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...

**0**

votes

**0**answers

14 views

### Excel experiencing one-time delay during saving and quitting

On my work machine I have Excel 2003. The first time (per instance) I try to save a file or quit, there is a noticeable delay. For saving the delay is somewhere around 10-15 seconds and for quitting ...

**2**

votes

**2**answers

87 views

### How to extract remainder of a match of 5 digits in 9

I am trying to extract the "remainder" (the non-matching portion) of a search using Excel 2003. I tried using various combinations of functions but it seems that there's no specific function that can ...

**0**

votes

**1**answer

98 views

### How to extract reminder of a match in MS Excel 2003

I tried using various combinations of functions but it seems that there's no specific function can return non-searched/matched values. Doing it manually takes days cause of the large amount data that ...

**0**

votes

**0**answers

38 views

### Query priority .xls VS .mdb

Hello to all the superusers!
My new question regarding conflict problem betweend an access application ad a excel wookbook/worksheet
I have a worksheet where using "Get External Data" on the "Data" ...

**0**

votes

**1**answer

112 views

### How to replicate an anchor tag in Excel

I have an Excel (csv) like this:
column1 link
yahoo <a href="www.yahoo.com">Yahoo</a>
google <a href="www.google.com">Google</a>
Is there any way to make link ...

**2**

votes

**1**answer

49 views

### How did I hide a Microsoft excel 2003 formula?

I have a problem with a spreadsheet that I have had for some years and cannot recall how I managed to set up the condition that the formula takes.
I keep a record of fuel costs whereby I enter the ...

**2**

votes

**2**answers

84 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

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

**-3**

votes

**2**answers

190 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

**1**answer

488 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

331 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

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

**3**

votes

**0**answers

317 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

248 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

**1**answer

436 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

218 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

156 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

38 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

525 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

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

**1**

vote

**1**answer

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

42 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

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

**3**answers

130 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

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

**1**

vote

**1**answer

247 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

52 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

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

58 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

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