Microsoft Office Forums - View Single Post - [Solved] Cell Range to Address Array

Thread: [Solved] Cell Range to Address Array

View Single Post

Old

10-22-2024, 05:24 AM

ImAhNoBoDy ImAhNoBoDy is offline

ImAhNoBoDy is offline

ImAhNoBoDy uses Windows 11

Windows 11 ImAhNoBoDy uses Office 2021

ImAhNoBoDy uses Office 2021

Office 2021

Novice

The original poster

Join Date: Jan 2012

Posts: 17

ImAhNoBoDy is on a distinguished road

Default

Quote:

Originally Posted by p45cal

View Post

Excellent. One of those too few occasions when AI produces a sensible result. Could you provide a link to that site please?

ps, you could use 4 as the ADDRESS function's 3rd argument to lose the $ symbols too.

The site I used was this:

https://aiexcelbot.com/formulas/logical/and

Reply With Quote