Any help/advice much appreciated...
I have a numerical value produced as a result of an existing formula
and need to find the closest higher value from a predefined list.
Does anyone know how to perform this sort of lookup, with the match

I want to be able to calculate how many working days there are between an
issue date and a completion date, but, if there is no completion date I want
to know how many days have been worked to date, iknow how to do this part
=networkdays(a1,if(b1="",today(),b1))

I have a holiday sheet where a number of the cells are locked but some can be
accessed to put in holiday requests.
The person inputs their holiday request in cell C15, the manager then
unlocks the worksheet and puts "Yes" into cell G15.

First, allow me to express my deepest thanks for all of the help y'all have provided me over the years while working and figuring out my absolutely FAVORITE application - Microsoft Excel!!  Hopefully I can add another notch on the "solved" column after this one..
Following this ...

I am nesting tables in a worksheet, but the inside subtotals keep appearing
under the outer subtotals.  In fact, the first nested table subtotal is
properly placed, but then all the others are reversed.  Does anyone know what
is going on?  Thanks.

I'm doing a search of a table with a unique transaction code (column
A) and its corresponding description (column B).   The table doesn't
have all of the transaction codes in place yet, when compared to the
actual transactions in use (which I'm trying to populate with the

I have a workbook with lots of validation drop-downs,  it works fine
for me and some of my colleagues, but some others cannot see the
arrows?
I have sent a mail to ask

Got two sheet with the following data:
Sheet1            Sheet2
A         B    A
0010711463    29    0010711463  sumif(

Help please.
I have cell C2 as an option of either less then 1400cc, more than 2000cc or
a number in between.
I have cell D2 as 'Petrol' or 'Diesel'.

How do I get a cell to round up by $1.00 without changing the sum total?  I
know how to make it round up by one or two places.  Example:  Cell (A1=
$1,333)+(A2=$1,333)+(A3=1,333).  Cell A4 is a sumtotal which equals $4000.  
When I sum these cells, the total is 4000.  However, If ...

Can anyone advise how to create an alert when sheets inadvertently remain
grouped, (after the purpose for grouping has been completed) so data is not
unknowingly changed across all worksheets.

I am trying to set up a worksheet to calculate a storage cost according to
date recieved. Ex. 200 cases recieved before the 16th charged at $0.50 per
case. Recieved o or after the 16th charged at $0.25 per case. I can get it to
work with just numbers but not with a full date. Any ...

Good evening group! I am trying to use the DGET function to return one value
from a group of cells. My table structure looks like this:
     Temp pH Cl2 Min
     4.90 5.90 0.4 137

Referring to the post in General Question
There is a list of numbers
1,1,1,1,1,2,2,3,3,4,4,5,5,5,5,5 from cell A1 to A16
Mode(A1:A16) = 1

I have 5 plus variables. See below for types of criteria. If the criteria
meet certain conditions then it needs to sum all the appropriate values for
that case:
One criteria could be risk, another size and a third time.