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.
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.
F4 to Repeat the Last Action (forget about Ctrl + Y).
Suppose you wanted to create a weekly agenda spreadsheet in which you not only wanted…
This is a quick and dirty formula trick to search for an item in a list and get the 2nd, 3rd, 4th . . .