My boss wants to be able to make data continually flow from one column to the
next INSTEAD of going to the next page. I told him it wasn't possible, but I
wanted to make sure it isn't? He doesn't want to copy and paste to the next
column, he wants to be able to insert a row ...

I know conditional formulas, but can't seem to program an average into an IF
formula.

Hello,
I am revamping a timesheet in Excel and was wondering how to make all values
in a list box equal 8.
For example,

I have a formula running down 80 rows - the formula is the same just the cell
references change.  When I get to row 50 and 51 I get a value error - but
there is no error for the other rows.  What am I missing?
=Clinical!C50+Logs!C50+Vehicle!C50+DQ!C50+'Trip

Please help i am importing lots of barcodes into excel they have an R
in front eg.R80255112 and excel automatically converts them to rands
eg.R 802,551,12 which is unsuitable.When i change it to text it cuts
out the R. I am also importing a datestamp which is meant to be

For example, the cell I need to repeat is A1 ie MS, the number of times to
repeat is 20 times ie B1 and the result in column C, ie automatically filled
with 20 cells of MS.
Is there any formula to do this?

I'm making an attendance summary sheet.  And here is what I want to do:
What can I do if I need to have some certain "letter" counted, or some
number calculated
depend upon the person age?

    Hi, I would like to ask you whether you know an excel addin for
interpolation a missing maturity in the yields? For example I have the
5 and 7 years and would like to interpolate the 6th year. Many Thanks

I've try associate IF OR AND      all toghether
like
IF  cell A4 >1     AND   ( cell A5 = "AAA"  OR Cell A6  = "BBB" )   Then ...
but not with sucess

if i make a constant amount of deposit on a periodical basis for a
certain period at a given rate of interest what would be the final
amount i get.?
for example

Is there an option to hide or cancel the format painter?

Complex functions like VLOOKUP need better examples.  Specifically, all
examples shown use a multi-column cell range reference for the table that
start with a cell in column A, and the 3rd operand is the column number of
the value to be returned.  If my range is c5:e18, and I ...

How can I disable excel when copying from exp. Cell C4 and past special
formulas into C5 that copy the same cell number exp C4 and not C5.
p.s. – I am trying to link the same cells from couple of worksheets into 1
column (exp. In column A, I want to link all C4 cells from all ...

example data:

I have 13 spreadsheets on one workbook and i would like to have all of them
on one spreadsheet. How do i do that w/o copying and pasting?