A
abc2002
Hi all
I have a big problem. It takes about 30 minutes to save my excel fil
because I have many array formula: about 32 000! So do you have a ti
to accelerate the computing process? Is a VBA function would do i
faster?
Here is an example of what I use:
Col A contain unique numbers
Sheet 1:
Col A Col B Col C
Row1 001 123 9i9
Row2 005 456 8u8
Row3 003 406 8ur
etc...
to +8000
In sheet 2, I have to check if the data exist in sheet 1. Col D contai
Yes (data is in the sheet1) or No...
Examples: Col D check if the data in Col B is the same in sheet 1
Col E check if Col C is the same in sheet 1
Here is the result:
Sheet 2:
Col A Col B Col C Col D Col E
Row1 001 123 9i9 yes yes
Row2 003 457 8u8 no yes
Row3 005 450 7kp no no
etc...
to +8000
Currently, Col D, E contain array formulas. The problem is that take
MANY MINUTES (I killed the process after 30 minutes) to calculate al
the fields.
Should I try to write yes no in the cells with a VBA function instea
of array formulas in the cells? Any tip?
Thank yo
I have a big problem. It takes about 30 minutes to save my excel fil
because I have many array formula: about 32 000! So do you have a ti
to accelerate the computing process? Is a VBA function would do i
faster?
Here is an example of what I use:
Col A contain unique numbers
Sheet 1:
Col A Col B Col C
Row1 001 123 9i9
Row2 005 456 8u8
Row3 003 406 8ur
etc...
to +8000
In sheet 2, I have to check if the data exist in sheet 1. Col D contai
Yes (data is in the sheet1) or No...
Examples: Col D check if the data in Col B is the same in sheet 1
Col E check if Col C is the same in sheet 1
Here is the result:
Sheet 2:
Col A Col B Col C Col D Col E
Row1 001 123 9i9 yes yes
Row2 003 457 8u8 no yes
Row3 005 450 7kp no no
etc...
to +8000
Currently, Col D, E contain array formulas. The problem is that take
MANY MINUTES (I killed the process after 30 minutes) to calculate al
the fields.
Should I try to write yes no in the cells with a VBA function instea
of array formulas in the cells? Any tip?
Thank yo