+ Reply to Thread
Results 1 to 6 of 6

Find the last nonblank cell

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-22-2008
    Location
    canada
    Posts
    123

    Re: Find the last nonblank cell

    I have another challenging idea which of course need help from you talented guys.
    Now that it is able to copy everything (from k1 to the last cell). Is it possible to skip the cell (blank the cell) in column K if the cell in column J is blank:

    example:
    if J1:J10 contains value, copy K1 down to K10
    if J11:J15 contains no value, K11:K15 should be blank as well
    if J16:J20 contains value, K16 down to K20 should contain the value of K1.

    Thanks again. Please help.
    Last edited by janjan_376; 08-21-2009 at 12:44 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1