News for hackers. Stuff that matters.
Re:Excel_to_code – Converts some Excel spreadsheets to C by liotier on Friday July 24, 2015 @07:03PM (#9945758)
vlookup pseudo-joins ahoy !
Re:Excel_to_code – Converts some Excel spreadsheets to C by personalcompute on Friday July 24, 2015 @08:29PM (#9946032)
I'll point out that if you find yourself with a RDBMS-like situation in Excel I highly recommend using Excel 2013+ 'tables' feature which adds foreign keys and better pseudo-joins (in pivot tables) inside of Excel. Better than anything hacked together with VLOOKUP. (heck, I've even seen some people hack it together with only SUMIF)
Re:Excel_to_code – Converts some Excel spreadsheets to C by function_seven on Friday July 24, 2015 @09:06PM (#9946160)
I use tables all the time in Excel 2010, haven't had much experience with 2013. Is this something that is truly new in 2013?
Re:Excel_to_code – Converts some Excel spreadsheets to C by personalcompute on Friday July 24, 2015 @11:27PM (#9946430)
I don't know, I have no experience with 2010 so I went with the lower bound I can guarantee as opposed to potentially giving harmful wrong information. Can't edit my comment now.