| Really obvious stuff you learned or discovered later than you should have 09:11 - Feb 28 with 8546 views | monytowbray |
Yesterday I discovered, after over 8 years of my current profession doing a lot of Excel heavy lifting, that there's a conditional format function to highlight duplicates in a column or row. I've been doing this the hard way and doing =countif formulas the entire time to discover duplicates. Not the hardest or most time extensive way to do so but still, there's a button I can just click to sort it out that's sat under my nose all this time.
Anyone else got anything like that where they suddenly discovered they've spent years faffing with something when there was an easier way? [Post edited 28 Feb 2020 12:23]
|  |
| |  |
| Really obvious stuff you learned or discovered later than you should have on 09:14 - Feb 28 with 5271 views | Pecker |
I have been doing up shoe laces all my life. Just discovered slip ons. Wasted days of my life doing up laces.  |  | | |
| Really obvious stuff you learned or discovered later than you should have on 09:34 - Feb 28 with 5220 views | BloomBlue |
Last week I discovered I've been wearing a watch all my life to tell the time but now people wear a watch for everything (ie paying for stuff) other than telling the time, I've stopped wearing a watch now. |  | | |
| Really obvious stuff you learned or discovered later than you should have on 09:36 - Feb 28 with 5202 views | StokieBlue |
It's nicer to do it yourself using COUNTIF() as you still then have all the original source data you were given and can times by either 1 or 0 to eliminate the duplicates.
Excel is actually an excellent piece of software from the much maligned Microsoft.
SB |  |
| Avatar - IC410 - Tadpoles Nebula |
| |
| Really obvious stuff you learned or discovered later than you should have on 09:37 - Feb 28 with 5193 views | monytowbray |
| Really obvious stuff you learned or discovered later than you should have on 09:36 - Feb 28 by StokieBlue |
It's nicer to do it yourself using COUNTIF() as you still then have all the original source data you were given and can times by either 1 or 0 to eliminate the duplicates.
Excel is actually an excellent piece of software from the much maligned Microsoft.
SB |
I agree, and I do like the idea of counting how many dupes in column. But the fact this button exists blows my mind.
I bloody love Excel too. | |
| |
| Really obvious stuff you learned or discovered later than you should have on 09:38 - Feb 28 with 5184 views | usm |
Cool story, bro. |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 09:45 - Feb 28 with 5150 views | Swansea_Blue |
Conditional formatting is my go to. I just like the pretty colours. |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 09:45 - Feb 28 with 5150 views | monytowbray |
| Really obvious stuff you learned or discovered later than you should have on 09:38 - Feb 28 by usm |
Cool story, bro. |
Don't be hating on me because you know your answer to this question is "sex" ;) | |
| |
| Really obvious stuff you learned or discovered later than you should have on 09:46 - Feb 28 with 5143 views | monytowbray |
| Really obvious stuff you learned or discovered later than you should have on 09:45 - Feb 28 by Swansea_Blue |
Conditional formatting is my go to. I just like the pretty colours. |
I use it a lot for quick data visualisation, particularly if it's a template or document other people will be using.
We need a TWTD Excel formula appreciation thread. | |
| |
Login to get fewer ads
| Really obvious stuff you learned or discovered later than you should have on 09:47 - Feb 28 with 5134 views | SouperJim |
| Really obvious stuff you learned or discovered later than you should have on 09:14 - Feb 28 by Pecker |
I have been doing up shoe laces all my life. Just discovered slip ons. Wasted days of my life doing up laces. |
Just wait until you find out about velcro... |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 09:48 - Feb 28 with 5132 views | Tangledupin_Blue |
Some football teams play F A Cup games after January!  |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 10:24 - Feb 28 with 5056 views | brazil1982 |
| Really obvious stuff you learned or discovered later than you should have on 09:47 - Feb 28 by SouperJim |
Just wait until you find out about velcro... |
That's just a rip off. |  | | |
| Really obvious stuff you learned or discovered later than you should have on 10:28 - Feb 28 with 5045 views | Pecker |
| Really obvious stuff you learned or discovered later than you should have on 09:48 - Feb 28 by Tangledupin_Blue |
Some football teams play F A Cup games after January! |
What is this witchcraftry you speak of ? Everybody knows the F.A. Cup final is on the first weekend of January. | | | |
| Really obvious stuff you learned or discovered later than you should have on 10:54 - Feb 28 with 5003 views | WeWereZombies |
| Really obvious stuff you learned or discovered later than you should have on 09:48 - Feb 28 by Tangledupin_Blue |
Some football teams play F A Cup games after January! |
Dare we ask how your Dad is doing?
And my obvious stuff (that my daughter instructed me about, in that advice given as a command that daughters seem to do nowadays) is chromebook instead of Windows. OK, I am dumbed down, but also much less stressed and with time to get up from the computer and do real life (or stay stuck to the computer and fritter away another day on TWTD). |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 11:02 - Feb 28 with 4979 views | Meadowlark |
| Really obvious stuff you learned or discovered later than you should have on 09:34 - Feb 28 by BloomBlue |
Last week I discovered I've been wearing a watch all my life to tell the time but now people wear a watch for everything (ie paying for stuff) other than telling the time, I've stopped wearing a watch now. |
I stopped wearing a watch over 30 years ago. It was a liberating moment, just like in Easyrider!
(Note for younger readers. "Easyrider" was a hippy/biker film from the 1960s) |  | | |
| Really obvious stuff you learned or discovered later than you should have on 11:07 - Feb 28 with 4961 views | monytowbray |
| Really obvious stuff you learned or discovered later than you should have on 11:02 - Feb 28 by Meadowlark |
I stopped wearing a watch over 30 years ago. It was a liberating moment, just like in Easyrider!
(Note for younger readers. "Easyrider" was a hippy/biker film from the 1960s) |
Classic (and depressingly real) film.
I wear my Tissot more as an accessory now and my FitBit is just to monitor my fitness. | |
| |
| Really obvious stuff you learned or discovered later than you should have on 11:18 - Feb 28 with 4923 views | ParisBlue |
| Really obvious stuff you learned or discovered later than you should have on 09:45 - Feb 28 by Swansea_Blue |
Conditional formatting is my go to. I just like the pretty colours. |
The problem I have with Excel and conditional formatting is a lot of people seem to choose yellow and green as the colours... |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 11:28 - Feb 28 with 4901 views | tractordownsouth |
That you don't need any detailed policies to win elections, you just need a meaningless slogan. |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 11:29 - Feb 28 with 4903 views | WD19 |
I only discovered relatively recently that all car fuel gauges tell you which side the fuel cap is on. |  | | |
| Really obvious stuff you learned or discovered later than you should have on 11:47 - Feb 28 with 4847 views | Fixed_It |
| Really obvious stuff you learned or discovered later than you should have on 09:45 - Feb 28 by Swansea_Blue |
Conditional formatting is my go to. I just like the pretty colours. |
I find it makes it look like I know what I am doing even when I don't. |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 12:22 - Feb 28 with 4806 views | monytowbray |
| Really obvious stuff you learned or discovered later than you should have on 11:18 - Feb 28 by ParisBlue |
The problem I have with Excel and conditional formatting is a lot of people seem to choose yellow and green as the colours... |
I've had people start doing that on purpose to annoy me in the past. Always said if I ended up running a team it would be my first biggest rule, no Y&G spreadsheets. But in the end I decided being and/or having a boss isn't for me and went self-employed :) | |
| |
| Really obvious stuff you learned or discovered later than you should have on 12:33 - Feb 28 with 4769 views | Superblue95 |
| Really obvious stuff you learned or discovered later than you should have on 11:29 - Feb 28 by WD19 |
I only discovered relatively recently that all car fuel gauges tell you which side the fuel cap is on. |
My dad never realised that either until I showed him last month |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 12:35 - Feb 28 with 4759 views | Half_Idiot |
Similarly with excel I recently discovered the sumproduct formula as opposed to the long winded formula of sum(X*Y,X*Y,etc...) | | | |
| Really obvious stuff you learned or discovered later than you should have on 12:39 - Feb 28 with 4728 views | positivity |
| Really obvious stuff you learned or discovered later than you should have on 12:35 - Feb 28 by Half_Idiot |
Similarly with excel I recently discovered the sumproduct formula as opposed to the long winded formula of sum(X*Y,X*Y,etc...) |
INDEX MATCH changed my life | |
| |
| Really obvious stuff you learned or discovered later than you should have on 12:55 - Feb 28 with 4703 views | BLUEBEAT |
Found out this week that the little arrow at the side of the petrol pump icon on the dashboard tells you what side of the car your tank/flap is.
 |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 12:56 - Feb 28 with 4703 views | Tangledupin_Blue |
| Really obvious stuff you learned or discovered later than you should have on 10:54 - Feb 28 by WeWereZombies |
Dare we ask how your Dad is doing?
And my obvious stuff (that my daughter instructed me about, in that advice given as a command that daughters seem to do nowadays) is chromebook instead of Windows. OK, I am dumbed down, but also much less stressed and with time to get up from the computer and do real life (or stay stuck to the computer and fritter away another day on TWTD). |
Thank you for asking.
Am sorry to say that he slipped away at 6:30 on Tuesday morning. The end was very peaceful. I was there until 2 o'clock that morning but went off for sleep leaving my sister by his bedside. I was then due to take over from her at 8. | |
| |
| |
By continuing to use the site, you agree to our use of cookies and to abide by our Terms and Conditions.
