Results 1 to 4 of 4

Thread: Order multiple texts in "row.cells" in columns

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 02-11-2021, 05:09 AM #1
    p45cal
    p45cal is offline
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    13
    You can also do this with Power Query (Get and Transform Data). See attached, table at cell D2 of the OutputB sheet. Right-click and choose Refresh to update.
    It doesn't show anything from entirely blank columns.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Excel and XP Operating System Tests (proc entry pt "GetDataFormEX" not found in the DLL "KERNEL32)
    By DocAElstein in forum Test Area
    Replies: 3
    Last Post: 11-17-2019, 11:08 PM
  2. VBA Versions of my "Get Field" and "Get Reverse Field" formulas
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 4
    Last Post: 06-02-2017, 06:15 PM
  3. Inconsistent "greater than" and "less than" calculations
    By wpryan in forum Excel Help
    Replies: 1
    Last Post: 02-10-2015, 09:41 AM
  4. how to equalize the value of an "alphabet" to "zero"
    By kernelx in forum Excel Help
    Replies: 4
    Last Post: 09-09-2013, 05:13 PM
  5. Ordinal Suffix (i.e., "st", "nd", "rd" and "th")
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 0
    Last Post: 03-20-2012, 03:46 AM

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