I recently modified a friend's spreadsheet to make it more functional.  As
usual, it was a "learn as you go" process.
I learned about the validation and lookup functions this time.
No problem with validation - I created a nice little drop down menu with 32

I get this error as I am trying to query in excel from access database. The
query works fine in access that is use to break down the data. Why will it
not come down to excel? I have all of the date particulars ( screen prints in
outlook and could send to someone wher you can see ...

I have a cell that generates an age in years from a date of birth in
another cell. 1, 2, 3 etc,
The age is displayed in L7
In another cell I need one of three prices based upon that age in

If I have 16 sheets and then I have a summary sheets....now in Cell B2 of
summary sheets I need to take the average of cell B2 in all the
sheets......what is the easiest way?
if the sheet tabs are named as Agent 1........Agent 16, can it be something

An issue I have is that in Columns D and E (E is dependant on D).
At the moment in D the options are Analyst Summer, Associate Summer,
Analyst Full Time, Associate Full Time & Summer Quantatitive. Column E has
the respective Locations where each of the option in Column D are listed ...

I am trying to write a function that is "=SUM(LARGE(C2:C12,{1,2,3}))" for
excel mobile but keep getting error.  Does anyone have a function to take the
sum of the three largest numbers in a column?  Or a way to modify my function
to achieve this in excel mobile.

I've got a query in excel from which I need the unique values in this
query. I've managed to find the way to find the total unique numbers
from this query (with the formula SUM(IF(INTERVAL(RANGE;RANGE)>0;1)),
but I also want to find the unique numbers within a couple of groups

Hi
I would like some help with a formula that i am trying to create on my
spread sheet.  The formula needs to countif a specific set of data is reached.
So far i have an array formula working that counts if 2 specific names are

Hello,
Can anybody tell me about calculation of inventory in FIFO(first in first
out menthod) to be calculated in Excel only.....
Thanks in advance.

I have used some formulas in Visual Basic which have worked very well, but I
have come across a small, but still irritating problem.
I have a column M which has different statuses (Offer Accepted, Offer
Declined, Offer Outstanding, 1st Round Offer, 2nd Round Offer, Assessment

I have a Named Range called "Data" that spans 8 columns and 7 rows. A Numeric
Value will appear only once in a row. Each row's Numeric Values are in
ascending order. A unique consecutive duplicate MUST be in the SAME column.
I would like to Return across a single row unique ...

Data:
 A          B            C             D              E              F      
    G              H
      Season    Ratio

I am trying to identify rows in a worksheet that have duplicate values in a
combination of three cells that should be unique in the worksheet.

Hello and good morning everyone,
I have been asked if it is possible to create a formula which will take
dates from various worksheets in a workbook and place the oldest on another
worksheet.  e.g. sheet 1, sheet 2, sheet 3, sheet 4, will all have a date in

variables (accounts): 14000; 14100; 14200; 14410; 14480
for each one fo them there are 3 hypothesis: Contracts (C), contracts with
external trainers (NH) and Invoices (F)
for each account there are different budgets for Contracts, Contracts with