I need to find the correct formulation for the following:
In worksheet 1: I have several colums-
Type   Level  Status  
A        1      M

I am developping a simple survey with Excel. For each question in column A,
user has to answer on a scale from 1 to 5. For visual and usability
purpose, I prefer not to use form and use 5 columns (B to F) to receive the
answer. If any character is entered in column B, than the ...

I have no idea how I did this but I cannot figure out how
to delete a duplicate workbook.
I have a workbook called Money.xls and somehow I created a
duplicate.  Now when I open the Money file it opens

In an exercise log, I have some data arranged in the following columns: Date, Location, Duration, Distance, Speed.
At the bottom of the data, I'd like to automatically reproduce the row with the max speed, for example.
I found the max speed with: =MAX(E1:E30)
Then I tried to use the ...

I've got a spread sheet which i want to use as an annual leave plan and
what i've got is a column for each week in the year, a column detailing
what shift they are on and a column detailing if an employee is Full
Time or Part Time, in the weekly columns if someone is off on a Monday

I am working in Mac OS 10.3.2 and Excel X: When we have a cell with txt that
has a comma in the string like:
The dog, cat and mouse
And export as a tab delimited text file, excel puts quotes around the cell

I understand that data on certain web sites is "dead" in the sense that
numeric numbers are actually text or image and when you download and copy
this this info and paste it into a spreadsheet, while you can see the
numbers there, you cannot do any calculations whatsoever with them ...

I am using
If Target.Address="$C$11" Then
blah blah, etc
But how do i select a group of cells?

I'm in the process of converting a monster Excel sheet.
There are thousands of addresses with:
Mr. and Mrs. First/Last Name
Part of the process is breaking these into separate

I have one spreadsheet titled "Collections" and another titled "Customer
Service."  The last spreadsheet is titled "Resources."  Each
spreadsheet has every day of the year listed in column A1 down.  My
goal is that if any entry (like the name Chuck) is made into any

It does not seem that the CRITERIA can be a cell
reference, such as "<$b9".  If so, this is a shame.  Is
there a way to do this, say using some other indicator
rather than quotes around it, to tell EXCEL it is a cell

I am trying to put in a function into a cell so that it
pulls just the last name.
For Example:
"John Smith" is in Cell B1 and I want just "Smith" to come

Instead of moving the highlight from cell to cell, when my
customer uses an arrow to move cells, it moves the whole
page. Is there a setting I need to change? This is XP.
Thanks

I have an worksheet with lists of data, like this:-
A            B    C    D    E
6767      10    5     6    7
6868         1  10    5    4

hello friends,
Does anyone have a ready-made formula to convert XL
date/times(GMT+5:30) to Unix timestamps  ?
Thanks in advance