I have two items I would like some help on, to try and create suitable
functions.
1. I have data in a worksheet (10 columns and approx 5000 rows). I would
like to be able to find the last cell with valid data (this is not always row

My sheet looks as follows:
ID# | NAME | SIGNUPDATE | ORDER# | ORDER DATE | BLANK COLUMN | $$AMOUN
I have a formula that will give me the # of new signups by checking th
signup date that looks like this:

My wife is using the goal seek function in Excel.  We are trying to figure
out how we copy this function down the column.

I need to put this information into my spreadsheet, aaaa 10%
bbbb 8% and so on but I haven't the slightest idea how to do it can anyone
out there give me a hand please?

What formula could I use to include all of the following condtions?
If < 1000 then Semi Annually
If >1000<2000 then Quarterly
If >2000 then Monthly

Where do I find the Multiple Regression add-in for data analysis in Excel
2002 (Office XP) ?

We are using Excel 2002.
We have created a Pivot that contains a column with dates:  9/21/05.
When the Pivot Table is created, it groups by a field name called Defect
Description but it willnot Sort the by Dates.  We have tried using "Data",

I have three columns: a, b & c and need sum the figures on c if a = week1
and b = empty.  Can someone suggest a formula to resolve this issue.
Thanks,
Ray

I am using this VBA code (created by Bob Phillips - Thank You Bob). I am
trying to use it an a 4000 row column. It appears to have a limit of 75 rows.
Is there a way to modify the code to handle the larger task ?
One of the paticipants in this discussion has mentioned that the ...

Please help. I used the following formula
=IF(B6<=15.4,B6/56,(100-B5)/84.5*B5/56) in the DRY BU column in the
table below. The formula in WETBU just divides the NET column by 56.
The formula is working when the WETBU is 15.5 or above but when the

How can I get a row # to stay when I delete a row? I have a company roster
set up but, every time I delete a person from our roster it changes the order
of the #. Example:  1
              2

Working with excel in accounting, I used to just highlight the data (numbers)
and would see a quick sum of the highlighted data on the very bottom gray
area of excel.  It dissapeared.  How do I retrieve?  
Thank you so much!

I have an excell file with 2500 urls in it that were saved as plain text...i
need to hyperlink all of them but i don't want to do it 2500 times....does
anyone know a way to mass hyperlink several lines

There is a tasklist spreadsheet that I would like to configure so that when
someone clicks on a cell in a row, the background of that cell changes to a
specified color.  I am guessing this would take buttons to accomplish this?  
Can someone help me or point me in the right ...

I am trying to use a wildcard function (*) in a sumif function, e
SUMIF(B:B,A1*,C:C) but excel converts the A1* to "A1*" rather that th
content of cell A1.
If for example the content of A1 was "smith" and i want to find the su