Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Orange Cty New York
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    repetitive data in colums (2000)

    I have columns which have the same data as about 7 columns apart. Is there any way I can input the data once and have it also go into the other column

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: repetitive data in colums (2000)

    If the columns are A and H, then put the formula below in H1 and fill it down the column. Then enter the values in A.

    <pre>=IF(A1="","",A1)
    </pre>

    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •