Pray tell how I would graph someone’s address.
Comment on Converting numbers is easy
SinningStromgald@lemmy.world 5 weeks 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 5 weeks ago
BenLeMan@lemmy.world 5 weeks ago
And why wouldn’t one just use the =COLUMN() formula to determine the column number if necessary?
bleistift2@sopuli.xyz 5 weeks ago
Because I wasn’t even using Excel at that point. I was importing an excel sheet.
MelodiousFunk@slrpnk.net 5 weeks 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.