I used Column D to store our cost of materials then I referenced it in some
formula's in Columns G & H but I screwed up.
I hid Column D before generating a hardcopy and then I quit Excel with
Column D hidden!

I have a street database that contains 9 columns. Not all of them will be
used on each record.  Here's my problem.  I have a column named ST_NAME and a
column named OID that have all my information in them.  It's set up like this:
ST_NAME           OID        STREET_2      ...

In work sheet4 and work sheet2 in col A is list of names.
In work sheet2 in Col D are $ amounts and
in cell F4 is a two letter codes. Down colF will be the number 1
occasionally.

Hi Group,
  Maybe another dumb question from a noob, but I would like to be
able to enter data from selected cells in another worksheet when I
enter on sheet1....I know I could go to the second worksheet, select

I am trying to enter $ in a13 have it add to b13 for day 1 in month then
enter day 2 in a13 have it add to b13.  ie jan 4 sales $2-running month sales
(b13)
then jan 5 sales $5 ads to b13 running month sales

Having several columns of values and under each its MIN cell, if there are
more (like the minimum value for a column is 12 and it appears in 10 rows out
of 200), how do I go about showing each of them with its respective row
number in the MIN() result?

once i filter the data in a given list, the row numbers change from
1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been filtered. i
want to know if there is a way to count the amount of rows data there are
after i filter?? Thanks!

How do I get to the row and col reference of a cell whose value I obtain via
calling MIN (I need to input this referece to OFFSET...)

I need help.
I want my formulas to have name cell but not sure how to do this.
The formula is:
=LOOKUP(C22,Suppliers!$D$5:$E$8,Suppliers!$E$5:$E$8*'Summary '!C22)

I have an Excel worksheet that lists the chapter of a document, i.e.
the first column looks like this:
1
1.1

Haveing a bad excel day - I am sure I have done this before but
racking my brains and can't remember!!
I have a list of scores for various tests listed by agegroup. I am
trying to summarise the data on a seperate worksheet to list who

Hello, looking for some help with the following:-
I have a list of names within Column A, some of which are repeated
numerous times.
What i require, is to list in Column B each of the names shown in

I created a time sheet which contains the following field: Time In (column
c), Time Out (column d), Time In (column e), Time Out (column f).  The second
time in and out is for lunch out and lunch in.
The next step is calculate the hours.  There are 5 columns.  First column to

Is there a way to lock the adjacent cells in a row, if "contractor" is
entered into the cell?
Kind regards
Dylan

I know the 'rand()' generates a random number.
Here comes a dumb question.
I need one from exactly 1 to X, how do you do this?
thanks....