I will say manipulating data in an excel, csv, file is way easier than writing some stupid code to do it for me. Yea cool story bro, I’ll just delete the rows I don’t want or make a new csv with all the stuff I do want. Kids these days and their If ( ) then ( ) statements
@PROC DUDE, I'm learning powershell and let me say I've never been more confused in my life
@PROC DUDE, But don't you love doing =if(X,if(XX,Yes,if(XXX,Yes,)),False)
And having to nest multiple functions in each other and having vlookup not work since your dumb coworker didn't have all values in the same format?
@PROC DUDE, I’ve recently added scripts to my money spreadsheet (what I use to keep track of spending and what not), and being able to to change graphs and add new months and such with buttons is much more fun than typing it all out manually
Aha, so thats why sometimes our tracking slips at work have that printed on them. Wonder how you fix that.
@Draconis, it just means the cell is trying to reference a location that doesn’t exist (like a cell left of column 1). Just have to go into the cells equation, and replace the “REF” with the actual target cell.
@ZweihanderNLeaveHer, ye if i scroll further down i can see all like another copy of the tracking slip but this time theres the ref thing instead of the part number.
@Draconis, if you make a cell equal to a cell that has a reference problem, it would show the same thing. Follow the chain up to the source.
I am fluent in Excel and I obviously understand this.
@The Goshdarn Batman, seriously I fvcking hate being forced to use stata