cm0002@lemmy.world to Programmer Humor@programming.dev · 9 days agoExcellemmy.mlexternal-linkmessage-square83fedilinkarrow-up11.29Karrow-down16cross-posted to: programmerhumor@lemmy.ml
arrow-up11.28Karrow-down1external-linkExcellemmy.mlcm0002@lemmy.world to Programmer Humor@programming.dev · 9 days agomessage-square83fedilinkcross-posted to: programmerhumor@lemmy.ml
minus-squarefeannag@sh.itjust.workslinkfedilinkEnglisharrow-up5·edit-28 days agoI should probably learn how BI works, but I’m mostly torturing excel to do things it was never intended to do. Also I do a lot of lookups and xlookup will slow my sheet down.
minus-squarexpinchx@lemmy.worldlinkfedilinkarrow-up3·8 days agoYeah if its something ad hoc I’ll paste values but for sheets meant to be maintained I’ll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)
I should probably learn how BI works, but I’m mostly torturing excel to do things it was never intended to do.
Also I do a lot of lookups and xlookup will slow my sheet down.
Yeah if its something ad hoc I’ll paste values but for sheets meant to be maintained I’ll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)