News for hackers. Stuff that matters.
Re:XLOOKUP for Excel by nefitty on Saturday August 31, 2019 @11:27PM (#20850331)
My office is split between Excel and Sheets users. I was once trying to mash-up my Sheets knowledge with an Excel colleague. I told him it might be easier to accomplish his task with Sheets because query() uses a SQL-like syntax. I told him Excel doesn't have that. He responded, "lmao you can do that with vb". I looked up instructions on how to that and realized he had no idea what he was missing.
Re:XLOOKUP for Excel by coagmano on Monday September 02, 2019 @03:36AM (#20857392)
Anything that requires VB is not friendly. Of course there's a sheets equivalent using javascript, which you can say the same thing about