Hi'
From columns A and B I would like to show on col C,
C1=A1
C2=B1

I know there is a way to do this I just can't figure it out.
Below is the lookup table.
I would like to enter a Hexidecimal number and have the program return all
the Fault descriptions that are applicable.

What i am trying to do is to make a formulas on the master sheet that will
change weekly the Handicap of the teams...
Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take
that different at a 80% value and giev it to team 2 score....

I need to do  sort function automatically,
Ex: Team 1 = 10200 pinfall and 450pts
     Team 2 = 10245 pinfall and 413pts
I need when i made a sort that the Team2 become 1st since he had more

i have 100 records of different employees. running for 3 years of weekly
payroll enlistment. Some are intermittently employed for multiple times yet
are considered under one (1) ID No.
in my spreadsheet for all employees, as one example of one employee, it

I am trying to copy cells from one worksheet to another but I want to
transpose them so that the same data shows horizontally rather than
vertically on the new sheet.  I want the data to be linked to the first sheet
so that if I change the info on the first sheet it will ...

I have a listing of about 200 data points that includes 2 columns with test scores from 2 different years (2006 and 2007). I would like to generate a table similar to what is shown below to show how many students fall in each of the cells. This would be the total number of ...

How to put sheets in alpha order

Can someone please help me regarding a formula which will enable me to
highlight upcoming birthdays on a spreadsheet.
I have no problem creating a formula to highlight, say, a date which falls
in the next 30 days. However, in this case the dates in question are my

Hello all: I have a list of names I need to match with another workbook.  I
also want to count how many times these names appear, including duplicates.  
For example, the list in the report would be:
Joe Smith

I am running Office 2007 and I am trying to find a formula that will allow
me to keep track of my current stock of craft materials.
The workbook is set up as follows.
Sheet named "Stock"

I am running Office 2007 and I am trying to find a formula that will allow
me to lookup the amount of stock used and subtract it from the starting
amount.  
It must be noted that the stock used does not appear in alphabetical order

I am trying to make a cell produce a value baed on the curent value entered
in a cell..
i.e.        Cell A2 can have 4 possible numbers 1,2,3,4
            Cell A1 should be either 20%, 40%, 60%, 80% depending on the

I have inherited a spreadsheet which for some strange reason has literally
thousands of small text boxes scattered throughout the sheets.  I know how to
delete one at a time but I was wondering if there was a way to SELECT ALL
text boxes in a sheet and hit delete once.  

How do I delete a text box from an Excel worksheet?