SanjayGMusafir
Well-known Member
- Joined
- Sep 7, 2018
- Messages
- 1,498
- Office Version
- 2021
- Platform
- MacOS
Hi Experts
Everything was going fine. Just now the following formula stopped working. I checked it, part by part. The INDEX function is giving error.
In fact I realized the problem when found one of the Macro using same formula was not working as intended.
Any suggestions
Thanks in advance
Everything was going fine. Just now the following formula stopped working. I checked it, part by part. The INDEX function is giving error.
In fact I realized the problem when found one of the Macro using same formula was not working as intended.
Any suggestions
Thanks in advance
Excel Formula:
=HYPERLINK("#"&
ADDRESS(MATCH(1,Index((Banks[Dt]>=TODAY())*(Banks[Dt]<=TODAY()+15),0,1),0)+5,COLUMN(Banks[Dt]),4,1),
ADDRESS(MATCH(1,Index((Banks[Dt]>=TODAY())*(Banks[Dt]<=TODAY()+15),0,1),0)+5,COLUMN(Banks[Dt]),4,1))