I have an array. I fill it from a range of cells in excel. Once it is
filled with data, I want to change some of the data in a certain column
if certain conditions hold in the rows. I am assuming that a
ArrayColumnEditFuntion is the way to go. The InitialArray may look
like this:
1 2 3 4
1 10 40
2 8 25
3 0 30
4 2 15
Lets say that I want to zero out the 4th column numbers if the given
row value is 0 in column 1. Hence the revised array would look like:
1 2 3 4
1 10 40
2 8 25
3 0 0
4 2 15
The function would look something like:
ArrayColumnEditFunction(InitialArray, editcolumn, "0")
So I would say ArrayColumnEditFunction(InitialArray, 4, "0"). I guess
you coud always multiple column 1 value by column 4 value if the
element in the given row in column 1 was a 0.
Any thoughts on this?
---
Message posted from
http://www.ExcelForum.com/