Dear fellows
I'm struggling with my hyperlinks.
Do anyone know the hyperlink-code/reference to a specified sheet and
cellreference  in another workbook?

how can I use the countif function to count the number of star (*) in a
range ?
If I do =COUNTIF(B1:B8;"=*"), I have the number of cells because * is
understood as a wild card...

I only just discovered the possibility of conditional formatting.
Apparently, only three formatting rules can be set. What is the way around
this limitation if I want to make it more complex. Some formula I guess?
Thanks.

I've tried to insert a formula to cell,but it seems
I can't figure it out.I want a formula that results
like below
If cell C7 = 0  it result is 0 , if C7 is 1 untill 6 it result 1,

Every time I open my excel I get "Compile error in hidden module :distMon"

I'm trying to create a spreadsheet to automatically perform staff rotation
around rides in an amusement park.
I have a list of staff (A3-A30)
I have headings of rides along D-N, and the dates that they were last on

I am test bedding Vista and Office '07 with our legacy programs.
As our main databases reside on an AS/400, we extract considerable data for
reporting by way of the iSeries Access for Windows Excel Add-in.  This has
always worked fine in previous versions of Office.

I have a club logo in my spreadsheet with members names. The logo is a
normal jpeg file, in colour, but when I do a print preview and print it I
keep getting it in graytone, no colour !
Does anyone know what the problem is, please ? ... Roger

I've search on how to do this task and found things similar but
nothing exact.
What I would like to do is create a 'list' of entries in one worksheet
and then in another using a dropdown box select any entry from the

How do I Lookup values from another sheet, knowing that there will be
multiple occurances of those values, and sum the offset cells?
For example:
Lookup value is:

I need an Excel file for the "Professor Teaches" training program.

Hello all,  please forgive my ignorance, but i created a excel spread sheet
wth the data I want to use to create shipping labels either in the msworks or
msword program and i thought i knew how to do this but i  don't.  the info i
get from the help menu is like greek to me.  can ...

Howdy all.
OS: XP,   Excel 2002 SP3
I have my music stored in the My Music directory. I have Artist, Album
Title, etc. attributes turned on. What I'd like to do is to take all of this

How do I format a number as in 1,2,3,4,5,6 without zeros or decimals? I tried
the General but I get 0.01 instead of 1
I am using Office 2007.

Can someone show me the code which would allow me to search through a
number
of rows and columns, to identify a criteria.  Each time the criteria
is