Re:Excel_to_code – Converts some Excel spreadsheets to C
by liotier on Friday July 24, 2015 @07:03PM
(#9945758)
vlookup pseudo-joins ahoy !
[ Parent
| on HN ]
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.