Ok guys..Any help would be great.. What i'm trying to accomplish her
is. Creating a function and/or formula in Excell or access that wil
calculate the check digit value of a 20 digit number. I have see
several sites that have VB code on how to do..however I do not know ho

I want to sort the spread sheet, but the pictures do not remain with their
respective row entries.  How come?

         R/sir
                          i need detail of Excel Function's pleas Gide me

i have this formula (and some others like it) that are basically summing
from the 24th row to the bottom row of a list of items, which in this case
is row 203.
=+SUMIF($A$24:$A$203,A5,$L$24:$L$203)

I need to write a formula that tells me the amount of weeks and days before
the 20th of next month.
Has anyone got such a formula they could pass me? I had a quick look but
it's too hot for my poor little mind to function today!

Got a bit of a complicated prob.....reguarly at work we transfer data from
one program to another.  We have a 'matrix' to translate the data from one
format to another.  Every week I have to update the matrix by running a
spreadsheet from the system and manually converting it ...

I have still tried to make heads or tail out of this, and still cant
get it right.
I have attatched a file, what is it that I need to modify here?  I have
tried changing the ranges, but it seems as if it is 9 rows out.  any

The worksheet I am doing needs to look at cell values, and in another return
the number of decimal places used in the cell.
for example
if A1 contained a number of 34.45,

I would like to know if there's a function or a macro to put the name
of the current sheet in a cell like
="this sheet is called"&<function that returns the name of the sheet>
so that if a sheet's name is "kaput" it should appear "this sheet is

Ive just written a very simple formula to calculate the percentage of
individual values .Can i store it to apply them to other cells in the same
worksheet?  or can i just apply the same formula to all the  cells to get the
result...?

Is there a way to formulate which portion of a day's hours worked ar
overtime hours?  Here is an example.  I'm looking for a formula for th
overtime (col.F) that will sum any hourly values (col.E) over 40 hrs fo
the same week, with Monday being the first day of the week.  I've trie

From a database, I have imported (into Excel) two lists of statistic
by country: (list a) the 20 countries with the largest number of cel
phone users, and (list b) the 20 countries with the highest percentag
of cell phone users.  I want to match these two lists by country s

I have just recently started to use Array formula that return multiple
results.
eg, select a range of cells 1 column x 8 rows and enter
=LARGE(DataRange,ROW(INDIRECT("1:8"))) array entered

I simply need to lookup 2 cells on another sheet and add them together
without producing any errors if one or both of them is blank. I am using:
=SUM(IF(ISNUMBER(LOOKUP($G2,Technicians!A:A,Technicians!BG:BG)),(LOOKUP($G2,Technicians!A:A,Technicians!BG:BG)),"") ...

Dear Sirs,
How may have a validation list depend on other cell?
for example if A1 is 1 then B1 can be: Mike, Jullie, peter; and if A1 is 2
then B1 can be: mary, frank, Jessica.