Ok I have a worksheet that alot of info is input daily.  Each day it is saved
with a new name and there is a macro recorded to delete the previous days
info and then we put in the new info.  In some blocks there are numbers that
are copied and put in another block, ie dates and ...

Has anyone successfully used the Case statement in a select query using MS
SQL within Excel , looking at an excel file as a datasource?
I'd love for you to post a sample query that you got to work. I've followed
the syntax every which way and it doesnt seem to work on this ...

I have the following pivot table:
1              2               3              4              5              
Totals
S                     (188.14)

I want to enter a formula that will change that will allow be to change the
value of a cell to 0 if the sum is les sthan 0 or a minus figure if it is a
plus figure then I want it to stay the same. I have used a formula of:
=(IF(G4<0,0*(IF(G4>0,)))  this will change the cell value ...

I have set up a holiday planner to add up holiday entitlement, etc and have
put in box SL when they have a day off sick.   How can  add this to my
running holiday or get to add up???

I have a problem that I can not figure out how to handle.
I have this DCOUNT function: =DCOUNT(Database;DATA!$L$10;(B79:B80))
It works but now I want to add another criteria range at another plac
in my workbook.

I am trying to edit an array in validation - custom screen but once is
done it returns to the its original settings. I would like to have the
modifications. Any suggestion?

I am trying to count the number of cells in a row that contain 1 to 5 but I
cells are not adjacent.  I am counting from every 3rd column cells which
contain 1, 2, 3, 4, or 5.  I tried using the
=COUNTIF(A1,A4,A7,A10,A13,A16,"1:5") but that obviously didn't work.  Any

I am working on a spreadsheet and I want to enter a number from a table and
have the associated values from the table transfer with the number into my
spreadsheet.  What functions and formulas should I use? (Below is the Table,
the PTM# is the one I would query for.)

Hi TWIMC
OK, I have the following test data in an Excel workbook and I want to be
able in a pivot table to count the number of clients for each employee.
A   B    C

doing a spreadsheet in which I have an IF statement that compares tw
numbers.. for example C11=1500 while E77=e76(2058)-c77(558) whic
equals 1500 as well but when I make an IF statement that looks lik
=IF(E77>C11,"A","B") I keep getting a result of an A when 1500 i

Is there a way to access all the excel tips and print them. I find them to
be very helpful and would like to have them handy
Thanks  

I currently have a spreadsheet that contains cost prices in columns. I want
to increase these prices by say 35% but don't want to have to insert columns
and formulae  to recalcuate each column. I know that there is a quick way of
doinf this by highlighting the column but can't ...

I have a long list of calculations of which i need to find the nearest
match.
I can find the nearest elow with VLOOKUP but not the closest.
Have

Sorry if this has already been answered but I couldn't find it among the
posts.  I have some data that I am transposing using an array formula.  One
of the columns contains dates. When I transpose rows into columns, this date
appears as a number. Is there anyway of making the ...