+ Reply to Thread
Results 1 to 2 of 2

Thread: Fill In rows

  1. 09-07-2010, 02:56 PM #1
    jcy1011
    jcy1011 is offline
    Registered User
    Join Date
    07-29-2010
    Location
    Mexico City, Mexico
    MS-Off Ver
    Excel 2007
    Posts
    16

    Fill In rows

    I've attached a document for your refernce.

    I have a very long list of product numbers in column A and would like to fill in the gaps in the rows like I have in Column C.

    Thanks
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 09-07-2010, 03:04 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    02-15-2008
    Location
    Grappenhall, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    6,566

    Re: Fill In rows

    Hi,

    In C2 and copied down

    =IF(A2="",C1,A2)
    Rgds
    Richard Buttrey

    If this was useful then please rate it appropriately.

    Click the small star icon at the bottom left of my post.
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0