May is Here!

Welcome to May! This past Wednesday, May 1, was May Day. To many people that may not mean much, as it is a holiday that barely merits a passing nod--at least in the United States.

I remember, though, that the holiday was my mother-in-law's favorite, as she would often recount fond memories of things they would do on that day in her childhood. (And she lived in rural Utah at the time, which made her memories of May Day all the more amazing to me.)

I hope that you are enjoying the warmer Spring weather and that you find the tips in this week's newsletter helpful.

—Allen
     

ExcelTips (menu) for 4 May 2024
Conditional formatting
Counting Colors from Conditional Formats

Conditional formatting is a great way to make sure that your information looks a particular way, even if the information changes. If you want to determine the color of cells whose color is based on a conditional format, then you are in for quite a bit of work.

Read this tip »

 
Worksheets
Identifying the Last Cell Changed in a Worksheet

When someone changes a cell in a worksheet, Excel normally goes along its merry way of keeping everything up to date. It does not, however, keep track of where that last change occurred. Here's some ideas on how you can determine the location of the last change by the user.

Read this tip »

 
Baffled by Array Formulas?

Have you heard about the special array formulas you can create in Excel? They make it a snap to perform calculations using large amounts of data and even generate results you can't get with regular formulas. Array formulas may be Excel's best-kept secret. Remove the confusion; discover how to use array formulas today.

 
Charts and charting
Labeling X-Y Scatter Plots

Figuring out how to get the data points in an X-Y scatter plot labeled can be confusing; Excel certainly doesn't make it easy. Here's some ideas on how to add the labels you need.

Read this tip »

 
Powerful spreadsheets
Looking Up Names when Key Values are Identical

Need to look up some values based upon some key items that may be identical to each other? Depending on the characteristics of your data, you may need to look at your worksheets just a bit differently than before.

Read this tip »

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450