NeptuneOrbit@lemmy.world to Vanity license plates@lemmy.world · 2 months agoFor all the corporate Excel jockeys out therelemmy.worldimagemessage-square15fedilinkarrow-up1126arrow-down12
arrow-up1124arrow-down1imageFor all the corporate Excel jockeys out therelemmy.worldNeptuneOrbit@lemmy.world to Vanity license plates@lemmy.world · 2 months agomessage-square15fedilink
minus-squareCuriousRefugee@lemmy.mllinkfedilinkarrow-up12·2 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·2 months agoFILTER is another of the more recent excel functions that is also really awesome
minus-squareShadowAndFlame@mander.xyzlinkfedilinkEnglisharrow-up5·2 months agoI use FILTER and XLOOKUP on the daily
minus-squareShadowAndFlame@mander.xyzlinkfedilinkEnglisharrow-up2·2 months agoSad, that’s what they taught us in college ~2017 but XLOOKUP is just that but better and less typing
minus-squareLordPassionFruit@lemm.eecakelinkfedilinkarrow-up2·2 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)
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
Sad, that’s what they taught us in college ~2017 but XLOOKUP is just that but better and less typing
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)