Quote (King Atrhur @ Mar 30 2017 11:47am)
Always hated excel formula's and shit, some of it really does get way to intricate for my liking.
Yeah. I need to convert it to VBA but would take too much time to do so. 2 mins of calculations when I manipulate the file

Have a sum if with 3 index matches in it
Twice
That populates to 1500 lines so really it's 3000 sum ifs each with 3 index matches
Hella gay but best way I could think of to do it due to EOM time crunch.
Standard shitty work PC with a 3000 series i5 and 8 GB ram
Could ask for a new PC I suppose
This post was edited by Penguins0690 on Mar 30 2017 12:27pm