These tips were comprised from a wide variety of sources including, but not limited to, experience, websites, books, blogs, friends and colleagues. Where appropriate, I will give full and complete credit to the original source.
Throughout these articles, I will attempt to identify anything that is expected to be typed in Excel by a single underline. Obviously, the single underline does not appear when entering the formula or information into Excel, but I find it much easier to Copy/Paste and identify than a normal usage of “quotes” which always certainly would never be entered.
This site may contain links to third party sites. FIG Consulting Partners does not accept any responsibility or liability for the conduct or content of those sites and the offerings made by the third parties. Third party links to other sites are not endorsements or recommendations by FIG Consulting Partners™ of the third party sites, goods or services. Your access to or use of them is at your own risk.
- Suppose you have a file with a list of student names and the number of votes they received in the student council election. Now assume that, for whatever reason, you can’t or don’t want to sort that list to determine the top 5 vote getters. So you are looking for create a formula that returns a column of student names with the top 5 votes.Read more
- Suppose your worksheet has text values in the format “firstnameLASTNAME” and the user would like to separate the two names into two separate columns as determined by the case of the text. The key is to determine where the text switches from lowercase to UPPERCUASE. To do this, you need to use an array formula.Read more