RINCONPAUL
05-18-2017, 11:38 PM
I've been away from excel for awhile and am being stumped by something I'm sure I knew the answer to once?
I have a table and in each cell a function resides to produce a value (number or text) when conditions are met. The table populates top down row by row with no gaps. I'm trying to use vba or even a Index Match Rept function to retrieve the last value displayed in certain columns. The problem is (xlUp) or (xlDown) or I M R sees the functions in the column cells as values and won't find the last displayed value.
The only way out I can see, is to copy and paste the displayed values into seperate columns, then work on them. I'm sure there is another way though?
Cheers
I have a table and in each cell a function resides to produce a value (number or text) when conditions are met. The table populates top down row by row with no gaps. I'm trying to use vba or even a Index Match Rept function to retrieve the last value displayed in certain columns. The problem is (xlUp) or (xlDown) or I M R sees the functions in the column cells as values and won't find the last displayed value.
The only way out I can see, is to copy and paste the displayed values into seperate columns, then work on them. I'm sure there is another way though?
Cheers