NeptuneOrbit@lemmy.world to Vanity license plates@lemmy.world · 7 months agoFor all the corporate Excel jockeys out therelemmy.worldexternal-linkmessage-square15fedilinkarrow-up1133arrow-down12
arrow-up1131arrow-down1external-linkFor all the corporate Excel jockeys out therelemmy.worldNeptuneOrbit@lemmy.world to Vanity license plates@lemmy.world · 7 months agomessage-square15fedilink
minus-squareCuriousRefugee@lemmy.mllinkfedilinkarrow-up12·7 months agoI’ve been a loyal adherent of the great INDEX(MATCH) for years, but I will have to look at this XLOOKUP deity to see if I should convert.
minus-squareflorge@feddit.uklinkfedilinkarrow-up6·7 months agoFILTER is another of the more recent excel functions that is also really awesome
minus-squareShadowAndFlamelinkfedilinkEnglisharrow-up5·7 months agoI use FILTER and XLOOKUP on the daily
minus-squareLordPassionFruit@lemm.eelinkfedilinkarrow-up2·7 months agoI know that XLOOKUP is probably better, but I just like my lil INDEX(MATCH) for some reason. You couldn’t pay me to convert (you probably could)
minus-squareShadowAndFlamelinkfedilinkEnglisharrow-up2·7 months agoSad, that’s what they taught us in college ~2017 but XLOOKUP is just that but better and less typing
I’ve been a loyal adherent of the great INDEX(MATCH) for years, but I will have to look at this XLOOKUP deity to see if I should convert.
FILTER is another of the more recent excel functions that is also really awesome
I use FILTER and XLOOKUP on the daily
I know that XLOOKUP is probably better, but I just like my lil INDEX(MATCH) for some reason. You couldn’t pay me to convert (you probably could)
Sad, that’s what they taught us in college ~2017 but XLOOKUP is just that but better and less typing