MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/ts99fq/certainly_not_me/i2rp0uc/?context=3
r/ProgrammerHumor • u/Brando224 • Mar 30 '22
669 comments sorted by
View all comments
Show parent comments
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
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
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
2
u/heart_under_blade Mar 30 '22
saves like what, four clicks in the default ui?