Results 1 to 7 of 7

Thread: PQ: Formula Sort Only Not Blank/Rows Data

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-18-2022, 01:32 PM #1
    muhammad susanto
    muhammad susanto is offline
    Member
    Join Date
    Sep 2013
    Posts
    37
    Rep Power
    0

    PQ: Formula Sort Only Not Blank/Rows Data

    hi all..

    how to sort data exclude blank/empty rows based on column C "name of city" .
    data empty in column C till BU, the other column are contains formulas.
    how to make formula in PQ to fix this problem. my target in sheet "buku register"
    i have 5 excel files to combine them with criteria above.
    here attachment file & capture before & after
    anyone help, thank in advance
    .sst

    note:
    i have use filter but after when refreshing data the filter is gone
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by muhammad susanto; 02-18-2022 at 01:40 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sort Data In Excel Using Formula
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 1
    Last Post: 07-08-2014, 10:01 AM
  2. VBA to Copy Rows Until Blank Row and Paste Data on First Blank Row
    By melissa1113 in forum Excel Help
    Replies: 2
    Last Post: 03-08-2014, 02:49 AM
  3. Sort Range Using VBA And Ignoring Or Discarding Blank Rows
    By analyst in forum Excel Help
    Replies: 18
    Last Post: 02-12-2014, 10:47 AM
  4. Sort Data By Multiple Columns And Delete Some Rows Based On Criteria
    By valesilver in forum Excel Help
    Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  5. How To Remove or Delete Blank Or Empty Rows After Data Is Transferred
    By jeff in forum Excel Help
    Replies: 5
    Last Post: 07-11-2013, 07:31 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