Is there a way to concatenate cell-vaues by a given range without using
VBA of external add-ins, like:
=CONCAT(A1:A3000)
instead of

I have recently made a list with drop downs for order analysis.
I have the date price department and account for drop down titles.
I already have all the data.  The dates are numerical
example(6/28/2006).  When I go to my drop down menu to organize all the

How can a number of hours be added to a cell and both the time and date
increment correctly?
For example, A1 = 25, B1 = 0:00:00.  I want to add A1 and B1 to get C1.
The Custom format for C1 is yyyymmddhhmmss.  Both the time and date

I need to make an Extract area how do i do that.also i need to make a
criteria area to

I have a master workbook that I SAVE AS each day as a new workbook.  The
person who fills in for me didn't create a new workbook and made a big
mess--I'm still finding formulas and cells that were changed.  I formatted
the date cell to be bright pink if it remains empty, but I ...

Here's what I'm looking at:
I've got a data set which pairs a customer with the dates that customer
has ordered, looking like this:
Customer #                Order date

Date    Description    Debit    Credit    Balance
01-01-2005                0.00
07-01-2005    Cash Receipt Voucher        33,000.00    -33,000.00
12-01-2005    Cash Receipt Voucher        59,000.00    -92,000.00

A                                                                            
                                Q
91%    93%    95%    92%    99%    97%    99%    4                    95%    95%    3
95%    95%    95%    96%    95%    96%    95%    5

VLOOKUP and the like return the next lowest value when the exact
search value cannot be found.  I need to be able to return the next
highest value.  For example, I want to return 112000 when I search the
following table for the value 760 (in cell A2, say):

i have a list of hours and want to add teh total in which it has to be
124:10:00
but when using the SUM function it comes as 4:10
i am using hh:mm function

I am using an excel worksheet and when I enter the cells across and hit enter
it just goes down to the next line in the cell.  I have excel on another
computer at a different job and when I hit enter it goes back to the cell A
of the next row and I wanted to know if there is a ...

how do I insert a symbol "&" in a footnote in excel without it disappearing?
ie: peanut butter & jelly

I data in a column with the date and time like this:
1/3/2006  7:30:00 AM
I need to have the date in one column and the time in the next.
Thanks!!

I am trying to have one Excel file pull up a price from another Exce
file. In cell B3 I type in my part number, B4 is going to be the price
I want B4 to look through column A in another workbook to find the par
number (from B3) and then look in column B of the same row to find th

This seems simple to me, but is so far baffling me on a way to
accomplish it without spending hours manually writing formulas.
So here's the problem. I essentially have a very large sheet of hard
numbers. They are presented in a table format but are read diagonally,