ExcelBanter - Finding a series of values within an Array

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Finding a series of values within an Array (https://www.excelbanter.com/excel-programming/308691-re-finding-series-values-within-array.html)

[email protected]

Finding a series of values within an Array

arr is Array correct?

Will your ColumnVector work beyond xl2000 (in case there are upgrades
in the future?) Probably should have asked that about all the array
functions before.

are there other arguments other than 0 or none in the last that would
be useful to know?
This could be a huge timesaver... thank you thank you thank you.

Alan Beban[_2_]

Finding a series of values within an Array

wrote:

arr is Array correct?

I never use Array for the name of an array because it is the name of a
command in VBA; in fact, I get an "Expected identifier" error message for

Dim Array

arr is whatever variable name to which the subject array is assigned.
Will your ColumnVector work beyond xl2000 (in case there are upgrades
in the future?) Probably should have asked that about all the array
functions before.

If the upgrades are backward compatible; I don't know what else to say.

are there other arguments other than 0 or none in the last that would
be useful to know?

Check the online help for the MATCH worksheet function.

This could be a huge timesaver... thank you thank you thank you.

De nada,
Alan Beban

All times are GMT +1. The time now is 01:23 PM.