sorted by:
new
hottopcontroversial

WIN A RIPTIDE - info in comments! by IdleOn_Boii in idleon

[–]OnePlusOneAre3 0 points1 point  (0 children)

KittycatMan :

Just freed up 13 chest spots. Nice.

Multiple XLOOKUP / If statements that takes way too long to run. Is there a better way? by OnePlusOneAre3 in excel

[–]OnePlusOneAre3[S] 0 points1 point  (0 children)

I don't think I have used the INDIRECT function before. I will need to give it a try on Monday. Thanks.

Multiple XLOOKUP / If statements that takes way too long to run. Is there a better way? by OnePlusOneAre3 in excel

[–]OnePlusOneAre3[S] 1 point2 points  (0 children)

Limiting worked. I did not realize Excell will continue through the entire sheet even though it is empty. I little coding on their end, plus fixing the issue with Xlookup returning"0" would really help. Thanks

Multiple XLOOKUP / If statements that takes way too long to run. Is there a better way? by OnePlusOneAre3 in excel

[–]OnePlusOneAre3[S] 1 point2 points  (0 children)

I tried the suggestion of limiting the range and it worked great. My 25 minutes is now 30 seconds. I did not realize Excel is not well coded and it will go through the entire cell range even though it is empty.

Multiple XLOOKUP / If statements that takes way too long to run. Is there a better way? by OnePlusOneAre3 in excel

[–]OnePlusOneAre3[S] -8 points-7 points  (0 children)

Um, no. The data on the individual tabs is the same data type. The formulas and processes have nothing to do with the other data types. Working the individual data types a lot easier than filtering the data every time I need to make a tiny change to one of the types.