Pray tell how I would graph someone’s address.
Comment on Converting numbers is easy
SinningStromgald@lemmy.world 3 days ago
Why would one need to convert the columns to numbers again? And why wouldn’t you just represent that data in a graph instead?
bleistift2@sopuli.xyz 2 days ago
BenLeMan@lemmy.world 2 days ago
And why wouldn’t one just use the =COLUMN() formula to determine the column number if necessary?
bleistift2@sopuli.xyz 2 days ago
Because I wasn’t even using Excel at that point. I was importing an excel sheet.
MelodiousFunk@slrpnk.net 2 days ago
I’ve done some seriously stupid shit in excel, mostly due to it being the only tool I had. By the time I handed the project off to someone else for maintenance/feature creep, there were VLOOKUP ranges spanning dozens of columns. VLOOKUP doesn’t care what column the target is named, only the offset from the beginning of the range. So being able to calculate CA minus W is pretty handy.
Yes, the project should have been a database. But these things happen when skinflint company meets annoyed amateur: you get a sprawling VBA abomination that, despite making actual developers want to choke a bitch, still works orders of magnitude better than the previous system.