Conversation

Notices

1. Embed this notice
   Matthew Loxton (mloxton@med-mastodon.com)'s status on Saturday, 09-Nov-2024 05:01:31 JST Matthew Loxton

   I contrived to fuck up five times in a row merging spreadsheets

   • Embed this notice
     HistoPol (#HP) 🥥 🌴 (histopol@mastodon.social)'s status on Saturday, 09-Nov-2024 05:02:26 JST HistoPol (#HP) 🥥 🌴

     in reply to

     @mloxton

     #Microsoft #Excel

     Hm, hard one. I don't think I've had that result in more than a decade.

     There are two options that work, done correctly without fault.
     One is for intermediate users, #HLookup 1), #VLookup, or #XLookup, the other for fairly advanced users, #PowerQuery 2).
     (I'm assuming that copy and paste has not been a top choice for you either. 😉)

     1)
     https://support.microsoft.com/en-us/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f

     2) https://m.youtube.com/watchhttps://m.youtube.com/watch?v=rNlie4RGdCU

   • Embed this notice
     HistoPol (#HP) 🥥 🌴 (histopol@mastodon.social)'s status on Saturday, 09-Nov-2024 05:02:30 JST HistoPol (#HP) 🥥 🌴

     in reply to

     @mloxton

     #Microsoft #Excel

     Hm, hard one. I don't think I've had that result in more than a decade.

     There are two upions that work, done correctly w/ fault. One is for intermediate users, #HLookup 1), #VLookup, or #XLookup, the other for fairly advanced users, #PowerQuery 2).
     (I'm assuming that copy and paste has not been a top choice for you either. 😉)

     1)
     https://support.microsoft.com/en-us/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f

     2) https://m.youtube.com/watchhttps://m.youtube.com/watch?v=rNlie4RGdCU

   • Embed this notice
     HistoPol (#HP) 🥥 🌴 (histopol@mastodon.social)'s status on Saturday, 09-Nov-2024 05:49:54 JST HistoPol (#HP) 🥥 🌴

     in reply to

     @mloxton

     Good 👍, though the described 1st method also works for repeated reports under high time-pressure. 😉

     I often despair when I hear (not you, OFC,) people complain about how "unrealible" spreadsheets are, etc. 99 % of the time, the problem sits in front of the screen and uses "simple" methods.

   • Embed this notice
     Matthew Loxton (mloxton@med-mastodon.com)'s status on Saturday, 09-Nov-2024 05:49:55 JST Matthew Loxton

     in reply to

     • HistoPol (#HP) 🥥 🌴

     @HistoPol
     Thanks
     I seem to be fine now.
     It was lack of blood sugar, and after a meal, it all worked out

     Thanks though, much appreciated