FORMULA FOR DUPLICATING COLUMN CONTENT

[JO]

I wonder if anybody could help me with a short cut
formula?
I have compiled a database by highlighting particular
columns from three separate databases and copying into
one larger database. Each of the rows has an identity
number attached. Therefore, because there are three
different databases, when I sort numerically, there are
at least three rows with differing columns containing
data for each number entry.(One of the databases contains
multiple entries for some identity numbers) I need the
information in columns C-F on all of the rows for each
numerical entry. Is there a formula that anyone can
suggest that will copy the info from rows C-F down onto
the following rows when the identity number in column A
is the same?
Many thanks.

 

[Bernie Deitrick]

JO,

The easiest thing to do is select your data table, then sort ascending based
on column A, and descending based on column C. This will group the like
identifiers in column A, and put the blank values in C - F below the filled
in values. Then select C:F and use Edit | Go To... Special... Blanks,
press OK, then type an equal sign, press the up arrow key once, then press
Ctrl-Enter. This will fill all the blanks with formulas that reference the
cells above.

Then re-select columns C:F and copy, pastespecial values to convert the
formulas to values.

HTH,
Bernie
MS Excel MVP