Log In
Register
Home
Active Member
Advanced Excel Formulas
February 12, 2019
Offline
1) How to format the date so it displays "As of 1/1/2015" while still permitting use as date input field.
2. How to use the IF function so the name of the person with the larger corresponding number appears.
| John | 17 | |
| Jane | 12 |
VIP
Trusted Members
June 25, 2016
Offline
Hi Khushboo Gaurav
Q1 - Use a custom format for the cell
Q2 - Use Index/Match
Please refer attachment.
Hope this helps.
Sunny
Active Member
Advanced Excel Formulas
February 12, 2019
Offline
Thanks so much for answering both of my questions. Much appreciated.
Khushboo
Active Member
Advanced Excel Formulas
February 12, 2019
Offline
Can the question 2 be solved using an if function?
October 5, 2010
Offline
Hi Khushboo,
You could use IF but only for small numbers of records, and the records/rows would need to be sorted ascending or descending based on the number. You'd need to use an IF for every person and nesting them quickly becomes unwieldy.
INDEX/MATCH is a better solution for larger numbers of rows/records.
Phil
1 Guest(s)
