User Profile
SergeiBaklan
Diamond Contributor
Joined Jul 15, 2016
User Widgets
Recent Discussions
Re: Help comparing 2 different data sets
It depends. Experienced users of this resource are allowed to add attachments, the rest are not. I have no idea what is the logic behind. Anyway, you always could place the file on OneDrive, GoogleDisk, whatever, give access for everyone and share the link here.Re: Forgot Excel Password
You may try to search here what is in title of your post, lot of threads are here Some of them are on many pages as I remember. Perhaps these two could be useful https://techcommunity.microsoft.com/discussions/excelgeneral/remove-password-from-excel-spreadsheet/2936709 https://techcommunity.microsoft.com/discussions/excelgeneral/excel-sheet-forgotten-password/3545763Re: Python in Excel - Missing from desktop Excel but exist in web Excel
At least one thing is wrong - you are to be on Current (Preview), not on Current. You may check build numbers for each channel here Release notes for Current Channel (Preview) releases - Office release notes | Microsoft Learn You may deploy proper channel using Office Deployment Tool or by other way, details shall be on Insider site. Not sure how to do that exactly for consumer or educational subscriptions.Re: Looking for help with a single Dynamic Formula Ranking Points by player and dropping lowest score
Practically the same as Olufemi7 suggested =SORT( HSTACK( REGEXEXTRACT(NameFinishes, "\w*",1), MAP( NameFinishes, LAMBDA(v, SUM( CHOOSEROWS( Points, DROP( SORT( --REGEXEXTRACT(v, "\d+",1),,,1 ),,-1) ) ) )) ), 2,-1)
