I used the same function and still got the #REF!
how can I solve this ?
Thanks for reaching out.
Can you please send me the Excel file you are working on at email@example.com so that I can take a better look. Thank you.
Looking forward to your reply.