Get cell address for non-contiguous cells?

[aquixano]

I need to be able to identify multiple cells selected within a single column and sometimes they will be non-contiguous.

Please Login or Register  to view this content.

Tells me how many cells are selected.

Please Login or Register  to view this content.

Will give me the addresses of the cells selected, for example: $B$40,$B$42,$B$50,$B$60,$B$63

But I can’t figure out how to get the address of a specific cell within the selection? i.e. If I need to do something with the third cell in the selection, what query can I use to return only $B$50?

[shg]

If they are non-contiguous single cells,

Please Login or Register  to view this content.

[aquixano]

Brilliant! Thanks shg

[shg]

You're welcome.