coldturkey
New Member
- Joined
- Dec 3, 2019
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
Hi all,
I have a table with Dates in a row and times in the columns I need to find the date when the first instance of a particular value occurs. The value can and does occur more than once. I also need a second formula to find the date of the last occurence. For example the first occurence of BRo is 25/11/2020 and the last is 9/12/20. I can't use a UDF as the work environment is locked down. (Note I am running Windows 10 and Excel 2019)
Thanks in advance.
I have a table with Dates in a row and times in the columns I need to find the date when the first instance of a particular value occurs. The value can and does occur more than once. I also need a second formula to find the date of the last occurence. For example the first occurence of BRo is 25/11/2020 and the last is 9/12/20. I can't use a UDF as the work environment is locked down. (Note I am running Windows 10 and Excel 2019)
Thanks in advance.