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 |
Hi Khushboo Gaurav
Q1 - Use a custom format for the cell
Q2 - Use Index/Match
Please refer attachment.
Hope this helps.
Sunny
Thanks so much for answering both of my questions. Much appreciated.
Khushboo
Can the question 2 be solved using an if function?
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
Gotcha! Thanks for the clarification. Much appreciated,
Khushboo
