Im wondering if you could help me out as im trying all kind of trick
to make what i want it to work, i have tried =if(or(a1>b1,a1<b2)
"x","y") function, (b1=01/01/2005, b2= 31/12/2005)  it will work but i
no date has been input then it I

Hi, I am using the following formula to look up records on a worksheet
within the same workbook:
=INDEX(STUDY,MATCH(1,(Monday!B2=PART)*(Monday!C2=OPS),0))
STUDY, PART and OPS are named ranges.

From reading other threads, I learned how to reference or link a sourc
column to a destination column on a different sheet within a workbook
ie. =Sheet1!A:A
My question is, How do I link multiple source columns to a singl

I am wondering if someone can help me with a custom Macro using the
VLOOKUP logic.
I need to do something like:
VLOOKUP(lookup_value1,lookup_value2,table_array,col_index_num,range_lookup)

Hi Folks - I have data that looks like this:
     Identity Crimes Seminar - 04/13/2005 16 27 43 13 99
    16.16% 27.27% 43.43% 13.13% 100.00%
     Internal Affairs Course - 11/08/2004 3 15 6 1 25

I was wondering how do I go about linking the numbers in various excel
templates together so that a change in one template will be reflected in
another.
Ex.  I have a income statement template and a balance sheet template, if I

Im wondering if you could help me out as im trying all kind of trick
to make what i want it to work, i have tried =if(or(a1>b1,a1<b2)
"x","y") function, (b1=01/01/2005, b2= 31/12/2005)  it will work but i
no date has been input then it still show x

I am creating an attendance database for my company.
There are 19 different departments in the company and each manager
tallies
his/her own employee attendances.

can anyone help me to unprotect a protected cell in Excel sheet.
Thanks/Greg

I am new at this, I need to create 2 different types of randomness, one of
numbers and one of text selections.
#1 a range of numbers, i.e, 134-2807 that allows repeat of numbers with a
return of only 25 numbers. This random option is use daily so I need to be

I'm wondering if it's possible to invert data so that what is up at th
top will now be at the bottom and what is at the bottom will now be u
at the top.  This would be easy if I had only a few rows o
information, but I have hundreds.  Thanks in advance.

In the cels are only formules shown instate of their values.
I tried Ctrl ` but this only solves the problem for that moment.
How can I solve this problem?
Kees

Hi, I have a table similiar to this:
ColA                                         ColB
6/06/2006  9:58:16 AM    6/11/2006  2:33:25 PM
I want to calculate the difference between ColA and ColB, excluding the

I've been doing some ad-hoc analysis at work today and as a quick fix (and
because I don't have the Access query skills) I ended up with 2 sheets:
Sheet 1 - Contains 21,000 rows of data, 10 columns with the first column
being a concatenation of 4 cells from each row

I have a problem with a macro which has been created on Excel in English.
When it runs on an English station it's ok. When I launch it on a pc with
Excel in French There is an error. Have you any idea about this ? When I
just change the language parameters from french to english, ...