I have a long work book that goes something like this
January
Date        Nr.    Balance
01.01.2009    1    100,00   

I am trying to find a simple formula that will calculate week numbers for
'Sunday to Saturday' weeks from the information in two cells.  Because there
seems to be no pattern to when the first week of the year will start, the
Sunday of the first week will be entered manually in ...

the match function gives the index from the top
is it possible to use match from the bottom to the top?
ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)"

Re Excel97 on WinXP pro w/ SR-2.  My keyboard is a Microsoft Brand PS2
connector keyboard that is connected to the computer through PS2 to USB
converter cable.
For years, the up/down right/left navigation arrows moved the active

I had a workbook set up with a vlookup function, but I deleted that and
created a new workbook, with the same sheet names (other things are working
better in this new workbook).  However....when I enter the vlookup function
on my new sheet in my new workbook, it tries to take the ...

Hi...
How can I delete the contains of all unlocked cells in a worksheet in one
sweep?
I have this worksheet with 6 * 13 * 33 cells scattered around the entire

I am trying to create a combination chart in Excel - lines and bars.
nothing complicated. however, "apply to selection" button in chart
menu is disabled. how do I activate it? without it, I get the same
chart type for all the data. would really appreciate if anyone can

I apologize if this question has been asked, but I have been unable to find
an answer searching the topics.
I'm using the following formula in cell C3:
=INDEX(LastName,MATCH(A3,EmpID,0))

the match function gives the index from the top
is it possible to use match from the bottom to the top?
ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)"

I copied 200 rows and 3 columns from an excel spread sheet with 2,000 rows
and 3 columns. Now all my comments are hanging down around 1700 and 1800
row. What can I do to correct this?
Richard

My dear , how can i use more than 3 choices in conditional formatting ,
thanks.

I'm trying to create a validation in a range (like one list, when we
click in the cell appear all possible data). The data are in one field
in one table in ms access.
I have a suggestion that consist in firstly put all data in one column

I found some VBA code in this group which I have modified below.  I
have not been able to get this to work in Excel 2003.
Option Explicit
Sub DelEmptyRow()

I have a spreadsheet; 25 participants for 31 days
each participant must log a catagory (eg PC) the spread sheet count the
number of PCs for the 31 days (eg. formula (=COUNTIF(E10:AI34,"PC")).
Question how can I calculate how many participates have logged a catagory PC

Is there away to have a checkbox in a cell so that all that can be
entered would be an X for nothing?