Contextures

Contextures News 2021-09-07

Discover Top Excel Blogs and Videos

September 7, 2021

Hide used items in drop down, top Excel resources, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Thank you for reading the news, and you'll get the next email on September 21st.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Hide Used Items

After you select an item from a drop down list, you can automatically hide that item, to prevent duplicate entries in a column. You can set this up easily with the new SORT and FILTER functions from Excel 365.

There are step-by-step instructions on my Contextures site, and I've made a new video that shows each step. There's an Excel file too, so download that to try it for yourself. There aren't any macros - just formulas.

NOTE: If you're using an earlier version of Excel, that page shows the older functions you can use instead.

queries and connections page docked at side of excel

Assign Players

Whether you’re scheduling players for a golf tournament, or assigning employees for daily shifts, Excel can make the job easier. There’s a Golf Tee Off Times example on my site, where tee off times are hidden, after you choose 1 or more players for that time slot.

Recently, someone asked how to add players to partially-filled time slots. So, I made a new version of the workbook, where the time slots are only hidden when they're completely filled.

In the screen shot below, there were 3 players in the 8:50 time slot. If you choose that time again, those players are highlighted, and you can select one more player to fill the foursome.

zoom to selection command

To get one or both of the Excel workbooks for golf tee off times, and for details on how they work, go to my Contextures website. Both workbooks are in xlsm format, and contain macros.

Excel Articles

Here are some Excel-related links that you might find useful or interesting.

Excel Resources: There's always something more to learn about Excel! If you love videos, check out this list of 22 Excel Experts on YouTube. If you'd rather read about Excel, here's a list of the top blogs. (Level - All)

Formulas: Hjalmar Gislason says Excel formulas are the world's most-used programming language, and the worksheet grid makes it easier to break a process into visible steps. (Level - Int/Adv)

Also see: Previous Newsletter Issues

Canadian Mystery

My current favourite author is a Canadian mystery writer, Louise Penny, who writes about murders in a small Quebec town, Three Pines. Her first book (Still Life) starts on our Canadian Thanksgiving weekend. The second book (A Fatal Grace) has a murder at a Boxing Day curling match -- you can't get much more Canadian than that!

They're similar to Agatha Christie novels, with interesting plots and quirky characters, but there's some strong language, if you'd rather avoid that.

weekly photo

NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2021/20210907ctx.html
I'll also post any article updates or corrections there.

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
dsd @contextures.com
ctxdebra @gmail.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

contextures newsletter info

 

Last updated: September 3, 2021 4:01 PM