Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2020, 07:11 AM
el Chiko el Chiko is offline fomula excel vs 2019 Windows 10 fomula excel vs 2019 Office 2019
Novice
fomula excel vs 2019
 
Join Date: Jun 2020
Posts: 1
el Chiko is on a distinguished road
Default fomula excel vs 2019

from a friend I have a excel 365 formula : =_xlfn.SORTBY((B5:B50);E5:E50)




problem: i have excel 2019. how to transfer the 365 formula to a 2019 one
Reply With Quote
  #2  
Old 06-01-2020, 09:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline fomula excel vs 2019 Windows 7 64bit fomula excel vs 2019 Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
you can find a couple of possibilities here


Otherwise, you'll have to search the Net as I did
Reply With Quote
  #3  
Old 06-13-2020, 11:51 PM
Purfleet Purfleet is offline fomula excel vs 2019 Windows 10 fomula excel vs 2019 Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Sortby is only possible in office 365, you cant use it in Office 2019

Last edited by Purfleet; 06-13-2020 at 11:52 PM. Reason: typo
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visio 2019 installation failure on Windows 10 with Office 2019 instwars Office 1 08-29-2019 07:05 PM
What's new in Word 2019, Excel 2019 and Outlook 2019 and Why upgrade to Office 2019 is recommended? einfomail Office 1 07-26-2019 09:44 AM
fomula excel vs 2019 Excel 2019 can’t edit otuatail Excel 2 11-20-2018 10:46 AM
fomula excel vs 2019 IF fomula with dates taryn Excel 3 08-21-2017 04:34 AM
Excel Fomula to search for a string and display value from different column zeeshanbutt Excel 1 07-29-2012 12:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:22 PM.


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