I am using the nested functions below
"=if(vlookup(1, GRID, 3,false) = 0, (1, GRID, 4, false), (1, GRID, 3,
false))"
i.e for the row with the digit one in its first column return the value in

I don't want to put several lines in my comments due to different
information, but I'd like to have several comments on my cell.
Is that possible ?
thanks ;)

Is there any way to change the location of the comment arrow on the
cell: for example in the middle of the cell ?:confused:
thanks

Can Excel print to an Avery label?  If so, how do I do this?
Thanks, Andre

I've been racking my brains on designing a pro-forma income statement
that can suggest a level of revenue required to attain zero net income
after COGS and expenses.  The way this spreadsheet works is that the
user establishes three kinds of financial information:

Could anyone tell me how to make cells increase by a single number, and
repeat the same number (i.e.: for a bar code) [the same number] as well?  We
need to print a number, and its bar code on a sticker, then a new number and
its new bar code on another sticker. etc., etc, ...

I use 2003 and make use of the Lists feature which does not seem available
for another user on Excel 2000.   Is there anyway that in Excel 2000 you can
add a total, but that when you filter the list by eg Town, it will produce a
total for just those records in the filter please?

hello again, i'm trying to get this to work:-
A1 = date ( changeable )
A2 = £ ( changeable )
B1 to B100 ( if B1 has £ in it move to next cell down without over righting

How does one define a Name that automatically updates its rang
reference for a Lis
--
RJB0

Situation identically reproduced on two PCs, both running WinXP SP2 and
Office 2003 all fully up-to-date.
I have several Excel files stored in a subfolder.
If I create a shortcut of this subfolder on my desktop and click on

When I type '11/12' for example in Excel 2003 it automatically changes it to
'12-Nov'. How can I remove this function? I tried endlessly to change thing
in 'options' but nothing seemed to work!
Thanks for any help

I need to create an a/r aging workbook using the following information:
Col A  Acct #
Col B  Name
Col C  Date

I am trying to add and subtract weekdays.
Example
I must schedule the delivery of the printer two days prior to the scheduled
7/10/2006 training date.

I'm new to Excel and would like to know if it's possible to do the
following:
Define a table(2 dimensional array) of fixed data like this:
              Tom    Dick    Harry

I want to input a number into a cell
say for example: 1,515,199,455
and have Excel automatically truncate the last 6 digits off
so the number ends up: 1,515