Hello there, I'm new to excel but my friend recommended it to me after I
explained to him what I want to do. I want to create something that
keeps track the hours that I complete studying or working. I want to
create 10 basic buttons which represent certain hours, i.e.

I am trying to sort two columns at the same time.  
I understand the basic sorting technique but am having trouble when it
comes to sorting the second column.
I have an x coordinate column and a y coordinate column.  I want to

I am trying to make a budget spreadsheet and want to get fancy with it
I have a macro that converts a figure when i have paid it to add som
brackets around it ie < 10.00 >  
Now I want to only add up the fiqures that arn't in these brackets.

I am having trouble getting my head around exactly how to approach a
rounding issue, and maybe someone can help.
I am converting some prices across currencies that follow a pattern --
multiplied by an exchange rate, then rounded up to .95 (if cents are

Platform / office: Windows 98 / Excel 97
I have two worksheets: WS1 and WS2. In the WS1 I have name as UniName.
If I protect WS1 and copy it (by using Ctrl + mouse), the name UniName
will be copied also. If the WS1 is active, in the Define Name box I can

How can I make the zero stay in a cell in number?
i.e. 0154785256 - the zero disappears
Thanks

Is there a way to have excel auto-sort (cutom) by criteria in 3 columns?
I think it might be easier to explain by viewing the workbook
http://poolgod.zftp.com/predictions.xls.
The picture shows how I need it to sort. I found some information on

I have annoying sheet that has empty lines here and there and I need to
get rid of them. So is there a way to choose every empty line
automatically.
(I'm not looking forward doing this manually to 10K lines :o)

Does anyone of you excel guru's know how to add a meter to a worksheet that
will use the numeric Values in a particular cell?
Digital2k

Someone has given me a UDF which is coded as follows::
Private Function WorkbookIsOpen(wbname) As Boolean
'   Returns TRUE if the workbook is open
   Dim x As Workbook

I would like to enter the letter "Y" in cell A1, and if I enter "Y" in B1,
the "Y" is automatically removed from A1. And if I enter "Y" in C1, "Y" is
cleared from B1.
Is there a formula that can achieve this and allow me to enter data in the

Range1:
A1: apple
B1: banana
C1: carrot

Where to set Excell so the Excell window and file that I am working with
shows the full path (full path.xls) of where the folders are in the upper
left hand side line of the window?

Can I mix the AND & OR functions like this.....
=IF(F5="","",IF(AND($D5<10,OR(F5>(F11+1),F5=0),F11+2,F5)) ???
I can't seem to get it to work.  Is there a better way?  I tried the another
way using all AND functions but I ended up with more than 7 nested IF

I am having trouble with a spreadsheet I am using to select different postal
addresses.
I want lets say cell b2 to have the input of a name and then the cells below
b3, b4, b5 etc to have the address, area and post code.