List of Real-World Examples

Real-World Examples

Search through our list of real-world examples that may best address your Excel or VBA question.

Title	Solution Type	Title and Solution Type
SPORT Highest scoring player How to calculate the highest scoring player from a list of players
SPORT Lowest scoring player How to calculate the lowest scoring player from a list of players
SPORT Team with highest number of wins How to calculate the team with the highest number of wins
EDUCATION Student with highest mark How to calculate the student with the highest mark from a list of students
EDUCATION Student with lowest mark How to calculate the student with the lowest mark from a list of students
EDUCATION Assign a grade to a result How to calculate a grade based on a mark
EDUCATION Weighted average of assessment results How to calculate a weighted average of multiple test results
EDUCATION Student with highest attendance rate How to calculate a student with the highest attendance rate by initially calculating the attendance rate of all students and then identifying the student with the highest attendance rate
EDUCATION Student with lowest attendance rate How to calculate a student with the lowest attendance rate by initially calculating the attendance rate of all students and then identifying the student with the highest attendance rate
FINANCE Monthly loan repayment How to calculate monthly loan repayments
FINANCE Fortnightly loan repayment How to calculate fortnightly loan repayments
FINANCE Weekly loan repayment How to calculate weekly loan repayments
FINANCE Debt Service Coverage Ratio How to calculate the Debt Service Coverage Ratio (DSCR) in Excel
FINANCE Debt Ratio How to calculate the Debt Ratio in Excel
FINANCE Loan to Value Ratio How to calculate the Loan to Value Ratio (LVR) in Excel
FINANCE Compound Interest How to calculate the compound interest in Excel
FINANCE Asset to Sales Ratio How to calculate the Asset to Sales Ratio in Excel
OTHER Convert birthday to age in years How to convert a date of birth to age, in years
OTHER Convert birthday to age in months How to convert a date of birth to age, in months
OTHER Convert birthday to age in days How to convert a date of birth to age, in days
OTHER Convert birthday to exact age How to convert a date of birth to the exact age, which is split into days, months and years
OTHER Combine First and Last name How to combine the first and surname that are captured in different cells
OTHER Return First name from name How to return the First name from name
OTHER Return Last name from name How to return the Last name from name
OTHER Remaining days to New Year from today How to calculate the remaining days from today to New Year in Excel
OTHER Remaining days and hours to New Year from today How to calculate the remaining days and hours from today to New Year in Excel
OTHER Remaining days, hours and minutes to New Year from today How to calculate the remaining days, hours and minutes from today to New Year in Excel
OTHER Remaining days to New Year from a specific date How to calculate the remaining days from a specific date to New Year in Excel
OTHER Remaining days and hours to New Year from a specific date and time How to calculate the remaining days and hours from a specific date and time to New Year in Excel
OTHER Remaining days to birthday from today How to calculate the remaining days to a birthday, based on a birthdate, from today in Excel