| Really obvious stuff you learned or discovered later than you should have 09:11 - Feb 28 with 11124 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 15:33 - Feb 28 with 4514 views | StochesStotasBlewe |
| Really obvious stuff you learned or discovered later than you should have on 15:13 - Feb 28 by BanksterDebtSlave |
You don't have to slide up and down the bed to masturbate you can use your hand....what a revelation.
Have I over shared? |
Not at all. Thanks for sharing. I,ll give it a try later. |  |
| We have no village green, or a shop.
It's very, very quiet.
I can walk to the pub. |
| |
| Really obvious stuff you learned or discovered later than you should have on 15:35 - Feb 28 with 4513 views | Lord_Lucan |
| 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. |
I never knew that |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 15:36 - Feb 28 with 4509 views | Lord_Lucan |
Women don't find drunk men a turn on | |
| |
| Really obvious stuff you learned or discovered later than you should have on 15:37 - Feb 28 with 4507 views | BanksterDebtSlave |
| Really obvious stuff you learned or discovered later than you should have on 15:36 - Feb 28 by Lord_Lucan |
Women don't find drunk men a turn on |
Drunk ones do. |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 15:39 - Feb 28 with 4504 views | Lord_Lucan |
| Really obvious stuff you learned or discovered later than you should have on 15:37 - Feb 28 by BanksterDebtSlave |
Drunk ones do. |
I don't like drunk women. | |
| |
| Really obvious stuff you learned or discovered later than you should have on 15:41 - Feb 28 with 4499 views | StochesStotasBlewe |
| Really obvious stuff you learned or discovered later than you should have on 15:13 - Feb 28 by BanksterDebtSlave |
You don't have to slide up and down the bed to masturbate you can use your hand....what a revelation.
Have I over shared? |
If you sit on your hand until it goes numb, it feels like somebody else is doing it for you. | |
| We have no village green, or a shop.
It's very, very quiet.
I can walk to the pub. |
| |
| Really obvious stuff you learned or discovered later than you should have on 15:46 - Feb 28 with 4486 views | BanksterDebtSlave |
| Really obvious stuff you learned or discovered later than you should have on 15:39 - Feb 28 by Lord_Lucan |
I don't like drunk women. |
They sometimes sober up......win/win. | |
| |
| Really obvious stuff you learned or discovered later than you should have on 18:23 - Feb 28 with 4414 views | Trequartista |
| 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. |
I don't think that's true. Only some of them do. |  |
| |
Login to get fewer ads
| Really obvious stuff you learned or discovered later than you should have on 18:30 - Feb 28 with 4406 views | Lord_Lucan |
| Really obvious stuff you learned or discovered later than you should have on 18:23 - Feb 28 by Trequartista |
I don't think that's true. Only some of them do. |
This has freaked me out actually as I never knew and on our lads whatsit group it's currently 3 against 2 not having knew. | |
| |
| Really obvious stuff you learned or discovered later than you should have on 18:36 - Feb 28 with 4399 views | ITFC_Forever |
If you put a belt on your trousers before you put the trousers on, then you shouldn’t miss any belt loops. |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 19:48 - Feb 28 with 4355 views | Superblue95 |
| Really obvious stuff you learned or discovered later than you should have on 12:56 - Feb 28 by Tangledupin_Blue |
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. |
Sorry to hear that. RIP |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 19:53 - Feb 28 with 4346 views | jeera |
| Really obvious stuff you learned or discovered later than you should have on 12:56 - Feb 28 by Tangledupin_Blue |
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. |
Sorry to read this.
Condolences to you and your family. |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 19:53 - Feb 28 with 4346 views | Deano69 |
| Really obvious stuff you learned or discovered later than you should have on 09:37 - Feb 28 by monytowbray |
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. |
If you also like PowerPoint take a look at Sway, it will blow your mind. |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 19:57 - Feb 28 with 4334 views | C_HealyIsAPleasure |
| Really obvious stuff you learned or discovered later than you should have on 15:41 - Feb 28 by StochesStotasBlewe |
If you sit on your hand until it goes numb, it feels like somebody else is doing it for you. |
#deadhandgang |  |
| |
| Really obvious stuff you learned or discovered later than you should have on 17:51 - Feb 29 with 4188 views | gordon |
You lot are a right bunch of beginners, you should be doing this in R. |  | | |
| Really obvious stuff you learned or discovered later than you should have on 17:53 - Feb 29 with 4181 views | gordon |
| Really obvious stuff you learned or discovered later than you should have on 15:35 - Feb 28 by Lord_Lucan |
I never knew that |
I realised this at about 28, I'm no longer one of those people pulling the 'extra long hose' right to its limit and spraying petrol all over my trousers. | | | |
| Really obvious stuff you learned or discovered later than you should have on 17:54 - Feb 29 with 4171 views | TractorWood |
| Really obvious stuff you learned or discovered later than you should have on 09:46 - Feb 28 by monytowbray |
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. |
Love excel. [Post edited 29 Feb 2020 17:55]
|  |
| |
| Really obvious stuff you learned or discovered later than you should have on 18:00 - Feb 29 with 4160 views | C_HealyIsAPleasure |
That Paul Lambert is an absolute chancer - about 95% of this board | |
| |
| |
By continuing to use the site, you agree to our use of cookies and to abide by our Terms and Conditions.
