Min Max Editing

[Guest]

I have a worksheet where I pick about 20 colums that will give me my Min and
Max of that row. I then move down to another row and need the same thing just
in the row I pick. I copy and paste each time and then change the colum
nuber. Is there a way to change the colum nubers in a faster way. What I mean
is instead of deleteing the number then puting in the new number for every
colum, something like A2,b2,c2,d2,e2,= a4,b4,c4,d4,e4. a quick change of all
the numbers at once?

Thanks

 

[Guest]

Hi bkj,

Not knowing all the particulars: Short of hovering the mouse so you get a
cross, and then clicking and dragging...

You could also single click on the cell that is holding the formula, ctrl+f
(find 2), and replace (with 4).

That's assuming you want the row changed, and not the column.

 

[Guest]

I think you need to become familiar with Relative vs Absolute references.

In Excel, a dollar sign ($) in a reference "locks in" that part of the
reference.

Examples:

A1: =$C$1
Copied to B2, stays: =$C$1

A1: =C1
Copied to B2, becomes: =D2

A1: =$C1
Copied to B2, becomes: =$C2

A1: =C$1
Copied to B2, becomes: =D$1


Am I on the right track here?
Does that give you something to work with?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

Hi,

Let's suppose that the data are in columns A thru T, and that they start at
Row 2.
In cells U2 and V2 enter the following formulas.

=MIN(A2:T2)
=MAX(A2:T2)

Select both U2 and V2, move the cursor to the bottom-right corner of the
selected area, i.e., U2 and V2 (you will notice that the cursor changes into
a "+" shape), hold the left mouse-button, and drag down the rows
(alternatively, you can doble-click the left mouse-button when the cursor
changes into a 'plus' sign to achieve the autofill).

Regards,
B. R. Ramachandran