Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-15-2019, 02:50 AM
AydanAr AydanAr is offline Sorting an excel datasheet Windows 10 Sorting an excel datasheet Office 2019
Novice
Sorting an excel datasheet
 
Join Date: Mar 2019
Posts: 4
AydanAr is on a distinguished road
Default

You're right, I haven't read them all, but didn't do it knowingly either. I did get an answer, however:



9_11_did_bush:
First I would make a helper column that with =IF(B2="", A2, B2) that transfers over whichever column is not empty. image

Then you can sort using the helper column and sku: image

source: 9_11_did_bush from reddit
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting problem in Excel nrsmd Excel 2 10-08-2017 11:54 AM
Sorting Excel Spreadsheet jmattingly85 Excel 2 08-17-2017 01:53 AM
Sorting an excel datasheet Excel Searching/Sorting Options ShaunO Excel 1 09-20-2016 09:50 AM
Sorting larg Excel file cause windows hang tasuooooo Excel 1 07-17-2012 07:23 AM
Sorting columns in Excel - please advise Jonre Excel 2 08-21-2009 02:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft