God morning everyone,
In column D (d15:d20) I have some data - fixed values (numbers)
In Colum BL(BL10:BL5000) I have some other data - calculated values (numbers)
I want to order these data in one colum based on their values. (No Macro) as

I am trying to put numbers in the cells that have a dash in them.  For
example 9-1, or 4-6. Everytime I do it it changes to a date or some other
random number.  I tried every format and can't figure it out.  HELP??  
PLEASE??

Not sure I'm on  the right list - but
When I select Side-to-Side to compare, the default arrangement is
horizontal - one page above the other.  Is there a way to get the default
arrangement to vertical, (which frankly seems to be implied by the

When using Vlookup to copy dates from one excel file to another, is there a
way to copy the font color of the date to the new sheet while still using the
Vlookup function?

How do I figure the percentage between two columns and then sort the columns
by the highest percentage first?

I have a summing question.  I want to, by day, sum the values in the 4th and
5th rows respectively based on the Machine #.
For example: for the 28th the sum for 179 would be 85 Actual, the sum for
216 would be 271 Actual etc.

I have two lists (List A and List B) wich are full of barocde numbers. I want
to comparison them with each other. I want to see, if a barcode number (which
is in list A), takes part of list B too. The excel program must be showing
them to me. But ı could'nt find the true formule ...

I'm trying to show on one worksheet the # of times a duplicate item # has
shown up on another worksheet. This is to be used as a visual "warning" that
the same item number has been placed on the worksheet, to possibly prevent an
overload of product.

I'm doing a project where I need to insert hundreds of defined names
into Excel.  I have the names and the info that goes into the "refers
to" box listed in a table.  At the moment I'm laboriously copying and
pasting them into the "Define Name" dialog box one at a time.

Is anyone else experiencing sluggish performance when performing
everyday tasks in Excel 2007.  I have both Excel 2003 and 2007
installed on my machine (2 gig processor, 2 gigs or ram) and Excel
2007 moves like cold treacle compared to 2003.

Is there a way to have contents of row A placed in row B without the blank
cells and without sorting?
Example:
    A    B

I tried the move or copy sheets option, but the formatting doesn't copy. I
have to highlight and paste the format. is there a solution or setting to
change? Excel 2002

Every day I receive a list of Zip Codes covering Sales Leads. The as-received
format includes regular 5 digit zips, 5+4 zips, and 5 digit zips with the
leading zeros omitted, but I need to change it to 5 digit to process further.
Routinely, I use the command ...

Hi Friends,
I need a formula to look at a date and return a date 2 days later - easy,
right?  Of course, but I also need it to ignore weekends and holidays and
only propose weekdays.  I think I need to use the NetWorkingDays, but I don't

I got into excel and went into Microsoft Visual Basic I pasted the code in
VBAProject
in Sheet 3(Code) But my spreadsheet did not change.  What am I doing wrong?