-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
#array
-
Z
Group values in arrays then replace them with a new value
I have a large number of excel files to clean up, any of the values contained in these arrays will be replaced by a different value Below is what I have so far, any help is greatly appreciated Sub CleanUpOutlier() Array1 = ("1", "2", "3", "4") Array2 = ("5", "6", "7", "8") With...- zack8576
- Thread
- #array #excel #replace #vba
- Replies: 1
- Forum: Excel Questions
-
X
Excel Formula for an alphanumeric text string in a cell
I'm not really even sure how to query this so I'll provide an example and then explain further: JT005 JT005 BB005 BB005 BD010 These values are pulled in from an agent database. The structure is always a string of 5 characters- the first 2 are alphabetic and correspond to the person's...- xystential
- Thread
- #alphanumeric #array #formula
- Replies: 12
- Forum: Excel Questions
-
D
Array
Hi, I wrote the formula below and it partially works. I was expecting 3 strings to return, but I am only receiving 2 strings. Syntactically, the formula is correct. I confirmed that the underlying data is correct. I narrowed the error down to the when the Match function leads into the row...- davidepstein22
- Thread
- #array correct data formula strings
- Replies: 2
- Forum: Excel Questions
