Dynamic Named Range "Results" spans 5 Columns and many Rows (starts at Row 19)
.  Each cell
houses Numeric single-digit or double-digit values.
I require a Formula to calculate the INTERVALS (the number of Rows between

I am trying to create a grade book. I know thee is a way that I can function
the total amount of points to a letter grade ( A-F).

I am creating a spreadsheet for my dad's check cashing business. I have three
cells: "AMOUNT", "FEE", "CASHED".
He charges an average of .012 or each check. so I enter the formula
"=PRODUCT('AMOUNT*.012) into the "FEE" cell. then I calculated in the

I am using =index,match,match to extract data from an array which I
don't control. It worked fine whilst the entries in the left-most
column were sorted (descending) but with new lines being added by other
users, the formula is now returning garbage. I've tried a number of

Can anyone assist me in creating a couple of custom VBA functions that
will convert liters to Imperial Gallons & Vice Versa.
I got a shock on my car fuel consumption until I realised that the
inbult Excel CONVERT function was operating on US Gallons

excel2003
i wanna count cells in a coloumn that contain a specific letter like "X" or
whatever

I have taken over a new position at work.  This person who I replaced had
created a worksheet that calculates revenue recovery for specific units of
time then also calculates the aggregate revenue recovery over a period of
multiples of these specific units of time. Below is an ...

I separated a long list of emails using test to columns separating them using
the @ separator. I have two columns now and have corrected the emails but
there is no @ sign. I was going to put a column of @ signs but I still can't
combine all the columns. I have over 2000 personal ...

i was wondering if someone could help me with a problem. i need to creat a
lookup that returns more than 1 result, for example. if i have a table with
dan dave and duncan in, i can type d into a cell and it will bring up dan
dave and duncan, if i type in da it brings back dan and ...

I work for a restaurant that uses a point-of-sale system and a liquor
control system to keep track of sales and inventory. My problem is how to
reconcile what was ordered in the pos system with what was actually poured
in the lcs system. Since the liquor system dispenses potion ...

I SENT A FILE FROM THE OFFICE USING EXCEL, AT HOME I HAVE XP HOME, HOW CAN I
READ IT WITHOUT BUYING FURTHER SOFTWARE.

I used to type enter time manually as under in coloumn B and D
Clients     Check In      Clients     Check out
15           12:24 PM       23          2:34 PM
Then i used this as a time stamp.

Sheesh, just experience having trouble enough articulateing your excel issue
to MVP and having to layout a spreadsheet on a Word program in hopes that the
example you spent so long putting together doesn't fold when posted to the
site.

I have 3 worksheet fuctions that show errors eg:
=AVERAGE(LARGE(Z32:Z36,{1,2,3,4,5}))  returns #NUM!  when cell "Z" is blank
=SMALL(AE32:AE300,2) returns  #NUM! when cell "AE" is blank
=VLOOKUP(AH39,AE32:AG300,3,FALSE) returns  #NUM! when cells "AH" contains

I need the lookup fucntion to return a null or a zero when it cannot
find the value required?  Currently it is returning the next nearest
value!!
For example: