Remove a last name from a text string On the previous page I included a formula to extract a first name from a text string. This formula will extract the last name: =RIGHT(A1,LEN(A1)-FIND(" ",SUBSTITUTE(A1,"","*",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))) Everything else works the same.
Find the number of days, years, or months between two dates Example: Cell A1 contains 12/23/1997 and cell A2 contains 1/12/1991. If cell B1 type the following formula to find the number of days between the two dates: =DATEDIF(A2,A1,"D") Press enter and the total number of days, 2537, should appear. To find the number of years: =DATEDIF(A2,A1,"Y") To find the number of months: =DATEDIF(A2,A1,"M") Make sure and put the greater of the two dates first in the formulas.
Mean, Median, and Mode Average, average, average. Anyone who has taken even the most rudimentary statistics class knows that there are three things to look for when dealing with averages for data. For this let's use the example that we have a column of numbers extending from cell A1 through cell A10. Mean average = what we all immediately think of when we think of the average. The formula is: =AVERAGE(A1:A10) Median average = The number closest to the center of the array. =MEDIAN(a1:a10) Mode = The value that occurs most often. =MODE(a1:a10)