I have a spreadsheet that tracks the value of my stock portfolio.  Calendar
quarters are across the columns, the investments are down the rows.  Every
quarter I have entered a formula in every row down that quarter's column that
looks like this:

I'm trying to create a list from the following data (Names are in column 1
and color values are in Column 2 and separated by commas):
Adam    | Blue, Green
Eric       | Red, Yellow

Using Excel 97
7018 kbps (857 kB/s)
13043 kbps (1592 kB/s)
Above is an example of lines of data I get generated from a speed

I need to report figures from different worksheets into a summary tab within
the same workbook (i.e.  data from Jan, Feb, Mar tabs into 1 'Summary' tab).
The figures need to be summed and are dependent on product codes from a
spreadsheet for each month containing data of expenses:

I was wondering you anyone could help me out with my issue...
I have a column in one worksheet that contains either blank fields, or
time in [h]:mm format. I am trying to count in a new worksheet the
number of times time exceeds 5 minutes:

Dear Experts,
In sheet 1 A1, I typed "See details". I want when this wording is pressed,
it will then go to sheet 2 B3 and this cell is selected. This action is just
like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two cells

i have created many worksheets in my excel workbook, my first page lists all
the worksheets and i want to be ables to click on one of the worksheet titles
in my list and be taken straight to it.
i am currentley looking at my list and then looking along the bottom for the

Esta função no Excel 97 e 2002 não funciona para somar múltiplas colunas,
mesmo que adjacentes. Ele só pega a primeira coluna especificada. Esse erro
já foi relatado por outros e a sugestão foi usar múltiplos SOMASE.
Ou o função está com erro de programação ou a instrução da ...

I have learned how to show just the left info (ex. - Jane instead of Jane
Smith) and right info (ex. - Smith instead of Jane Smith), but if there is
three or more words, how do I show just the middle info?
ex. - I'd like to change Jane Sue Smith to show just Sue

Hi, I would appreciate help in copying a formula across a row that includes
the previous cells results. For example, assuming that the formula in cell
A30 is, +A22*A50, cell B30 would be +B22*$A$50+A30, and cell C30, it would be
+C22*$A$50 +$A$30+B30, I would like to do this for ...

I am using Office XP and I was wondering how to delete duplicates.  Is there
a procedure in Excel where I can do this in one key stroke?  My list consists
of 14,000 lines, so as you can see it would be quite cumbersome to go through
manually to delete them.  Any help would be ...

Is there anyway by which i can make one cell to continously show numbers
running from 0 to 100,000 and then again start from 0.
I have sheet where I refresh the external data and by the time data is
refreshed I want one of the cells to show the pattern of running numbers.

Please help me.  I have created a schedule that I would like to filter by
date.  Is there a way to filter the dates in order?  I can filter by the
month, date or week... for example if I filter by the month of May, all of my
May dates are returned, however, they are not in order. ...

High you all,
I need a single formula that gives me, for a rectangular area, the
number of rows that have at least one non blank cell.
Say, for example, that in A1:M20 all the cells are blank except

I have been trying to count blank colored cells in 2003.  I have tried
several VBA and other threads listed here.  Especially  Chip's cppearson
site.  none of the formulas direct or macroed are working.  It seems that
anything related to color is not a recognized name.  I am not ...