Cell Range to Address Array

		Microsoft Office Forums > Microsoft Excel > Excel
Cell Range to Address Array

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-22-2024, 05:24 AM

ImAhNoBoDy ImAhNoBoDy is offline

Windows 11 Cell Range to Address Array

Office 2021

Novice

Join Date: Jan 2012

Posts: 17

Quote:

Originally Posted by p45cal

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using IF AND to filter number in a range, works with dragging, but not in an Array	mda99das	Excel	5	11-17-2022 01:27 PM
Loading an Excel range to an array in VBS	BobBridges	Excel Programming	1	12-25-2020 01:04 PM
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
Error: AGGREGATE_doesn't ignore hidden rows for particualr array range	adisco	Excel	1	01-10-2017 10:59 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:37 PM.