marian68
asked on
VBA Code
Hi guys,
Attached you will find a sample of what the data is and the desirable result if it is possible.
Thank a lot,
Example.xls
Attached you will find a sample of what the data is and the desirable result if it is possible.
Thank a lot,
Example.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you guys.
The formula will work for 10000 records, but will take a while to calculate.
My test took 1 minute to copy and calculate, so when done, I would leave the formula for the first record, and convert the rest to values.
With the formula at the first record, recalculation can always be done again.
My test took 1 minute to copy and calculate, so when done, I would leave the formula for the first record, and convert the rest to values.
With the formula at the first record, recalculation can always be done again.
ASKER
The formule will work even for 10000 records?