Excel CHOOSE Function
November 24, 2015
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
The CHOOSE function doesn't get talked about too much, but it is very powerful -- just give it a number, and it will return a result. One way that I use CHOOSE is to show the fiscal month for a specific date.
For example, if a company's fiscal year starts in July, the CHOOSE function could give us the fiscal month number, if the calendar month is 11.
To see how old an Excel file is, and other properties, click the File tab on the Ribbon, then click the Info category at the left. You'll see the properties and dates at the right.
If you want a list of all the files in a folder, and their properties, I've created a macro that you can download. In the sample file, just enter a file path, and click the button to run the macro.
Here are a couple of Excel articles I read recently, that you might find useful.
Create Icons -- Instead of using conditional formatting icons, which can slow down your workbook, Jordan Goldmeier shows how to use custom number formatting to create icons on a dashboard. (Level - Intermediate)
Office 2016 Review -- If you're not sure whether to update, Zack Barresse has been using Office 2016 for a while now, and posted his review of the new features. (Level - Basic)
More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog. And for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets.
There will be at least a couple of Black Friday and Cyber Monday sales for Excel related products. To see the list, go to my What's New page. I'll keep updating the list, so check again on Friday and Monday!
We had a very light dusting of snow on Sunday, and my granddaughter decided that we should go out and build a snowman. I think she has seen the Frozen movie too many times! She managed to scrape together a bit of snow, and it was just right for building the world's tiniest snowman. We couldn't find a tiny carrot for its nose though.
NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser: https://www.contextures.com/newsletter/excelnews2015/20151124ctx.html
That's it for this week! If you have any comments or questions, send me an email.
Last updated: February 4, 2021 3:02 PM