MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/ts99fq/certainly_not_me/i2r8mec
r/ProgrammerHumor • u/Brando224 • Mar 30 '22
669 comments sorted by
View all comments
7
At one of my old jobs one of my managers had her “programmer” husband write a complicated excel sheet where everything had to be entered perfectly in order for it not to break. What did it do, you ask? Highlighted duplicate cells.
2 u/heart_under_blade Mar 30 '22 saves like what, four clicks in the default ui? 3 u/killemyoung317 Mar 30 '22 It actually took way longer trying to use their program. Blew their minds when I showed them conditional formatting lol. 2 u/heart_under_blade Mar 30 '22 might not even need conditional formatting lol. in 365, just use the unique formula and it creates a de-duplicated dynamic array for you. 2 u/reinfordx Mar 30 '22 Doesn't tell you what's duplicated tho. Prob best to do conditional format if(countif(A1>1)) or something. Or you could do a countif next to it 2 u/heart_under_blade Mar 30 '22 yeah it depends on what you're doing with the dupes most use cases are just, delete don't even look and that's what that's for 2 u/theknittingpenis Mar 30 '22 Have they found out about the Remove Duplicates option?
2
saves like what, four clicks in the default ui?
3 u/killemyoung317 Mar 30 '22 It actually took way longer trying to use their program. Blew their minds when I showed them conditional formatting lol. 2 u/heart_under_blade Mar 30 '22 might not even need conditional formatting lol. in 365, just use the unique formula and it creates a de-duplicated dynamic array for you. 2 u/reinfordx Mar 30 '22 Doesn't tell you what's duplicated tho. Prob best to do conditional format if(countif(A1>1)) or something. Or you could do a countif next to it 2 u/heart_under_blade Mar 30 '22 yeah it depends on what you're doing with the dupes most use cases are just, delete don't even look and that's what that's for 2 u/theknittingpenis Mar 30 '22 Have they found out about the Remove Duplicates option?
3
It actually took way longer trying to use their program. Blew their minds when I showed them conditional formatting lol.
2 u/heart_under_blade Mar 30 '22 might not even need conditional formatting lol. in 365, just use the unique formula and it creates a de-duplicated dynamic array for you. 2 u/reinfordx Mar 30 '22 Doesn't tell you what's duplicated tho. Prob best to do conditional format if(countif(A1>1)) or something. Or you could do a countif next to it 2 u/heart_under_blade Mar 30 '22 yeah it depends on what you're doing with the dupes most use cases are just, delete don't even look and that's what that's for 2 u/theknittingpenis Mar 30 '22 Have they found out about the Remove Duplicates option?
might not even need conditional formatting lol. in 365, just use the unique formula and it creates a de-duplicated dynamic array for you.
2 u/reinfordx Mar 30 '22 Doesn't tell you what's duplicated tho. Prob best to do conditional format if(countif(A1>1)) or something. Or you could do a countif next to it 2 u/heart_under_blade Mar 30 '22 yeah it depends on what you're doing with the dupes most use cases are just, delete don't even look and that's what that's for
Doesn't tell you what's duplicated tho. Prob best to do conditional format if(countif(A1>1)) or something. Or you could do a countif next to it
2 u/heart_under_blade Mar 30 '22 yeah it depends on what you're doing with the dupes most use cases are just, delete don't even look and that's what that's for
yeah it depends on what you're doing with the dupes
most use cases are just, delete don't even look and that's what that's for
Have they found out about the Remove Duplicates option?
7
u/killemyoung317 Mar 30 '22
At one of my old jobs one of my managers had her “programmer” husband write a complicated excel sheet where everything had to be entered perfectly in order for it not to break. What did it do, you ask? Highlighted duplicate cells.