# Tagged Questions

**0**

votes

**1**answer

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

**0**

votes

**0**answers

14 views

### Exporting Survey Sheets to a registrar in Excel 2003

I would like to create a Survey Template that gets filled out, and when saved, exports to a different folder, under a name based upon entry number. How do I go about doing this?

**-1**

votes

**0**answers

23 views

### Why Excel autofills only from T1 to T4?

I have the text T1 in a cell. If I select it and drag the fill handle over multiple rows, then it fills in T2, T3, T4, and then resets back to T1, T2 and so on.
With other text like A1, W1, or Q1, it ...

**2**

votes

**2**answers

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

**-2**

votes

**2**answers

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

**1**

vote

**1**answer

54 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

34 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

**1**answer

153 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

10 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

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

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

502 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

79 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

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

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

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

**2**

votes

**2**answers

745 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

420 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

99 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

195 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

**1**answer

189 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, ...

**0**

votes

**1**answer

77 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

288 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

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

**1**

vote

**1**answer

152 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

99 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

451 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

407 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

**2**answers

876 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:
...

**4**

votes

**2**answers

4k views

### Restrict and validate date format in Excel

I'm trying to put together a 'Data Validation' formula which restricts the user to entering a date in the following format: dd-mm-yy.
From the research I've done, I've come across what I thought ...

**-1**

votes

**2**answers

155 views

### I will need a formula showing counts, totals and sub-totals for data set from different sheet

I am using MS2003 EXCEL. I have a cell in Sheet 1 with a color value and totals, with sub-totals. On sheet 2, I have a data set with 3 columns (colors, dress, type). On Sheet 1, I will need a ...

**-1**

votes

**1**answer

281 views

### Macro to count the number of text strings in sheet in Excel 2003

I have a worksheet for scoring.
I have a list in the first sheet that will be for data entry starting with a2 and going down the sheet, this is for Player names.
I have a summary sheet named "Place" ...

**1**

vote

**1**answer

470 views

### Automatically select last row in a set in Excel

In Excel 2003, I am trying to keep track of some petty cash, and have it set up with the denomination along the top row, along with a sub total and difference column. I want a small section that shows ...

**0**

votes

**1**answer

435 views

### Create or Open an .xlsx file having >256 columns in MS Excel 2003 with compatibility pack installed

I'm using Microsoft Office 2003. I have installed 'Microsoft Office Compatibility Pack for Word, Excel, Powerpoint 2007' to support new xml based formats (.docx, .xlsx, .pptx).
Now given that I have ...

**0**

votes

**2**answers

333 views

### How to clear all value cells in an entire 2003 Excel workbook by one go?

How can I clear all value cells in an entire 2003 Excel workbook by one go?
I could do one sheet by going to special functions, however, if a file is composed of many sheets, it would take a lot ...

**1**

vote

**2**answers

56 views

### Hide a number that comes before the text of a column in Excel?

I have a column like this "2;#Vendor", I want to display only "Vendor".
How can I do this?

**1**

vote

**0**answers

865 views

### How to Search For Excel (2003) Files which Contain Macros on Server?

How can I search for Excel files that contain VBA code, are there any efficient ways to do this?
The way I'm thinking of would be to use vbscript and recursively search through the directory, open ...

**7**

votes

**6**answers

10k views

### Excel's date format without a year

I'm putting in employees' birthdays, but they come without years for sensitivity reasons. But when I put the month and day in, Excel automatically adds 2012 as the year! Obviously this is not right. I ...

**0**

votes

**2**answers

640 views

### Excel 2010 formula conversion to Excel 2003

I am by no means overly proficient with Excel, I know enough to do the basics.
After much forum and soul searching I had come up with the following formula, which I will discuss what it is supposed ...

**3**

votes

**3**answers

5k views

### Move to end of selection in MS Excel (2003)

I have a large set of data that I update regularly by copy/pasting and overwriting old data. I do this for 10k-15k records at a time. Once I have pasted, I manually scroll down to the last line of ...

**5**

votes

**3**answers

2k views

### Converting decimal number of hours into time

I need to convert number of hours, such as 156.90 to 156:54 in excel 2003.
All of the conversions I found did this incorrectly. The number of hours shouldn't be changed, only the decimal.

**0**

votes

**2**answers

156 views

### Compute the first digit of an integer in Excel

I have a spreadsheet with column B having integers. I want to get the first digit of each entry in column B in the corresponding row of column C.

**1**

vote

**1**answer

422 views

### Microsoft Excel 2003 - Merge by Column

I'm trying to merge two excel files, here is the structure of the files:
[A] [B]
I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...

**0**

votes

**2**answers

417 views

### How can I speed up my macro in Excel 2003?

I have a macro that copies data from one cell to another and uses a VLOOKUP formula, among other things. My spreadsheet contains nearly 2000 rows.
When I run it in Excel 2003, Excel starts to slow ...

**1**

vote

**1**answer

340 views

### Why has Excel stopped offering to sort adjacent Columns?

Xp3.
Excel 2003 (11.8346.8341) Sp3
In the past, whenever I selected a columns that was next to another column and selected "sort", Excel would offer to sort the adjacent columns well. This was very ...

**0**

votes

**1**answer

82 views

### Copying and pasting in Word and Excel

I recently started having problem with pasting tables between Word documents and from Excel to Word. For some reasons it pastes table without frame, just disorganized text. It is very annoying because ...

**6**

votes

**2**answers

14k views

### Why is Excel removing leading leading zeros when displaying CSV data?

I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell 2A attempts to display "01" as a ...