john316swan
Board Regular
- Joined
- Oct 13, 2016
- Messages
- 66
- Office Version
- 2019
- Platform
- Windows
I have a sheet with table of data and I need to apply a different percentage to each row of data going into the array. For example
Now i need to multiply each scholarship in the row (from column AD to column CR) by the corresponding % in column ac.
I can loop through but that takes a bit of time and i was trying to speed it up so i thought that an array would be best. Thanks for your help!
AC | AD | AE | AF | ...all the way to CR |
---|---|---|---|---|
Prorate | scholarship1 | scholarship2 | scholarship3 | scholarship4 |
.67 | 5000 | 1000 | 2000 | 3000 |
.45 | 4000 | 3000 | 5500 | 2500 |
1 | 3500 | 1000 | 3500 | 1000 |
.98 | 1000 | 2000 | 3000 | 4000 |
Now i need to multiply each scholarship in the row (from column AD to column CR) by the corresponding % in column ac.
I can loop through but that takes a bit of time and i was trying to speed it up so i thought that an array would be best. Thanks for your help!