+ Reply to Thread
Results 1 to 2 of 2

Formula to up the code to the desired place

  1. 05-10-2018, 08:13 AM #1
    reimar_rem
    reimar_rem is offline
    Forum Contributor
    Join Date
    11-21-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007,2013
    Posts
    159

    Formula to up the code to the desired place

    hi,

    Can any check my file, I dont know how to explain this but i have attached simple file before and desired.
    Attached Files Attached Files
    Click * below if this answer helped
    Reply With QuoteRegister To Reply
  2. 05-10-2018, 11:09 AM #2
    tim201110
    tim201110 is offline
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Formula to up the code to the desired place

    autofilter, all except empty and the next formula
    =INDEX(C:C,AGGREGATE(15,6,ROW(C5:$C$9000)/(LEN(C5:$C$9000)>0),1))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ 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)

Similar Threads

  1. Code not browsing the desired folder path to open file
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2016, 03:14 AM
  2. [SOLVED] VBA code to place formula at last row of matching segregated data
    By Sonny Crockett in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2015, 06:42 PM
  3. VBA code that will get the desired data using datas on a column with diff. sheets
    By richzter in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 05-19-2014, 09:54 PM
  4. Printing data from cell in desired place on paper
    By pic2pic in forum Excel General
    Replies: 5
    Last Post: 01-11-2013, 09:09 AM
  5. VBA Code not limiting itself to desired cell rangs
    By GordonPSmith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2011, 06:26 PM
  6. [SOLVED] Look up the part code having end with desired character
    By PRADEEPB270 in forum Excel General
    Replies: 1
    Last Post: 08-21-2010, 02:25 AM
  7. Code for copying a code into a specific place in an outlook template?
    By VoodooChild in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2010, 10:08 AM

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.6.0 RC 1