Here's a question for you all.
I have an excel sheet that is produced via an export of data from
Crystal Reports. One of the columns holds a list of all different codes
that are all in my autocorrect list. Now if I were to just type these

I am trying to setup a work sheet so that when we weigh cattle, I can enter a
number into a cell and this then matches to a breed, eg. Enter '1', this
should be 'Murrey Grey female'.
I have setup the page and on another worksheet I have listed the breeds and

My worksheet (part of a workbook) records the amount of time spent flying,
relevant columns are shown below, items in () are how the cells are currently
formatted
B date (ddd dd-mmm-yyyy)

I intend to create three scenarios with each scenario incorporating two sets
of variables (asset price and daily rate for example), and then use Combo Box
to select a scenario. How can I do this?
Thanks!

I have a series of values growing exponentially over time. I'd like to
project the values in the next 5 years, but I can't figure out how to
use the related functions. For instance:
    A    B

I want to make a report on a separate sheet based on a non-null colum
on another sheet. Example:
sheet 1:
name telephone

Please i need to know how to enable these negative values from teh lcm
function because all i get is 0 and its obvious that its not

I have a list of dates in column A. These dates are when the next
safety check will (or should) take place. In some cases the safety
checks have been missed and are overdue.
What i would like is some kind of function in column B to state whether

I am trying to find a formula that will look at a list of team names an
returns how often a particular team is in the list.
What i am exactly trying to do is this. I have 16 teams in a sport
tournament and each has to vote for their 1st 2nd & 3rd choice of mos

I have the following SUMPRODUCT formula that sums tha values in th
range B6:AF6 based on the date in AL3. It takes the date in AL3 an
returns the sum of the values starting with the Monday before the dat
in AL3 up to and including the date in AL3. B5:AF5 is the date rang

how do i total my phone bill amounts so that i can get a total in a "total"
cell?
or how do i add multiple figures to gain a total?

I need to refer to a range of cells in a function. Same function is used in
different worksheets of same workbook. The name when used in a specific page
should refer to the cells from that page.
ie.,

I have a list of extensions I want to count or sum their respective sizes.  
However, the SUMIF formula treats:  .0    .00    .000  as  0.  I need each
one to be counted or summed.  I have tried to force the issue with TEXT() to
no avail.

I have 2 sets of cells.
Set 1.      C7,D7, E7 this is for start DD/MM/YYYY
Set 2.      G7, H7,I7  this is for to end  DD/MM/YYYY
The above represents weekly rental for property eg start 26/06/2006 end

Hello to any who can help... and thank you.
I am converting from another application into excel, and the column for
time includes the seconds.  I would like to be able to truncate the
seconds in order to perform a VLOOKUP.  I can include every minute of