Excel copy and paste
OK Bob, Now that I have the formula, with your help and minor changes to your
formula I was able to have it show what I was looking for.
Thank you!
But I have another issue now;
When I copy the formula to the rest of the cells in the same or diferent
column the row number does not change automatically.
I have to manually change every number for every cell. It is very time
consuming when I have to work with thousand or more cells per column.
I know it can be done because my other formula use to do this.
I am sure it's a simple but I am stuck!
Thanks
Bebz
|