Let's say I have 2 sheets ... sheet1 has 5 stores (A2:A11), with a
number (0-5) in B2:B11.  The value of B2:B11 is based on a formula and
is (of course) dynamic.  On sheet2, I'd like a list of ONLY those
stores with a value greater than 0 and the value assigned to that

On Mar 5, 7:05 pm, ranjan.k...@comcast.net wrote:

it's a spreadsheet of names and addresses
the addresses column has both the street number and address.
like 1233 LAKE ST
What I would like to do, is sort them on the street name AND THEN the number

For many years, when we were helping a customer select a model size, we had a
preprinted form that would guide us through the multi-step process of
gathering the hard data from the customer and plugging that data into the
various formulas. In addition, there are four different ...

I have a very simple spreadsheet. The only 'advanced' feature it has is a
small lookup table that is an external data reference to an Access Database
Table. This external reference is set to auto-update on sheet open.
Problem is, as part of a failed experiment, I created a macro, ...

Just a quick question to the group - I often have columnar data that
has nonzeo values in the x-column and was wondering how I can generate
a line or scatter chart that doesn't keep jumping back down to zero
every time y(x) = 0.  Is there a way to "skip" the zeroes or only plot

I have the following data in colums A - D with the headings below.
(There are 1000s of rows of data, but only the 4 columns)
PhoneNumber_____Status____________________BillableTime_____Transfers
9588_____________Delivered to Answ Mach_____15_____________

I'm trying to set up a macro where each time it runs, it inserts a new
worksheet with a hyperlink from the initial sheet to the new one. However,
when I run the macro, the hyperlink always takes me to the worksheet I used
when recording the macro. I think the problem is that the ...

new to excel-using excel 2003-xp-pro-sp1
want to convert a saved excel sheet that has been saved in an html
format, to tiff or jpg.
purpose-is to open in ps, and then print with a large format printer

Hello, I have an worksheet where I want to change the colour by de value of
the number wich is in the cel.
Example, when a cel contains the number 1-5 the cel must be the colour red
but when it contains the numbers 6->5 (5-10) the cel must be having the

I recorded a macro that inserts the following formula in cell R2:-
Range("R2").Select
   ActiveCell.Formula = "=IF(ISBLANK(P2),"""",1000-P2)"
I then wanted to insert another formula in R3 and the macro recorded it as :-

Have 2 pairs of cells representing two events -- a date and time for each
event stored as text with the date cell in form mm/dd/yyyy and the time cell
in form hh:mm xM. Need to find the elapsed time between the two events in
hours and minutes placed in separate cells.

Some setting of Excel has suddenly changed:
when I have multiple Excel files open, I no longer have multiple buttons on
the taskbar. There is just one window and I need to browse between the Excel
files by clicking on Window in the Excel menu toolbar.

You guys gave me the clue on how to change Text to Columns.
Now I looked through the help file
I can't figure out how to sort the address numbers
even/odd

I found my worksheet couldn't be maximized no matter how many time I click
the "Max.Button".
P'se advise how to get it done. I'm running Excel 2002.
Surfer