Quantcast
Please log in or register. Registered visitors get fewer ads.
Forum index | Previous Thread | Next thread
Really obvious stuff you learned or discovered later than you should have 09:11 - Feb 28 with 3270 viewsmonytowbray

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 12:23]

"The world will not be destroyed by those who do evil, but by those who watch them without doing anything."
Poll: How close will a TWTD election poll be next to June results?

0

Really obvious stuff you learned or discovered later than you should have on 09:14 - Feb 28 with 2447 viewsPecker

I have been doing up shoe laces all my life. Just discovered slip ons. Wasted days of my life doing up laces.
6

Really obvious stuff you learned or discovered later than you should have on 09:34 - Feb 28 with 2396 viewsBloomBlue

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.
0

Really obvious stuff you learned or discovered later than you should have on 09:36 - Feb 28 with 2378 viewsStokieBlue

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

“You may not feel outstandingly robust, but if you are an average-sized adult you will contain within your modest frame no less than 7 X 10^18 joules of potential energy—enough to explode with the force of thirty very large hydrogen bombs, assuming you knew how to liberate it and really wished to make a point."

0
Really obvious stuff you learned or discovered later than you should have on 09:37 - Feb 28 with 2369 viewsmonytowbray

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.

"The world will not be destroyed by those who do evil, but by those who watch them without doing anything."
Poll: How close will a TWTD election poll be next to June results?

0

Really obvious stuff you learned or discovered later than you should have on 09:38 - Feb 28 with 2360 viewsusm

Cool story, bro.

FOYSC
Poll: Did Broad just get a hat trick without realising ?

-1

Really obvious stuff you learned or discovered later than you should have on 09:45 - Feb 28 with 2326 viewsSwansea_Blue

Conditional formatting is my go to. I just like the pretty colours.

Poll: So then cake aficionados, which is your favourite part of Battenberg?

0
Really obvious stuff you learned or discovered later than you should have on 09:45 - Feb 28 with 2326 viewsmonytowbray

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" ;)

"The world will not be destroyed by those who do evil, but by those who watch them without doing anything."
Poll: How close will a TWTD election poll be next to June results?

1
Really obvious stuff you learned or discovered later than you should have on 09:46 - Feb 28 with 2319 viewsmonytowbray

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.

"The world will not be destroyed by those who do evil, but by those who watch them without doing anything."
Poll: How close will a TWTD election poll be next to June results?

1
Login to get fewer ads

Really obvious stuff you learned or discovered later than you should have on 09:47 - Feb 28 with 2310 viewsSouperJim

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...

Poll: Prawn Crackers
Blog: Broken Ipswich

1

Really obvious stuff you learned or discovered later than you should have on 09:48 - Feb 28 with 2308 viewsTangledupin_Blue

Some football teams play F A Cup games after January!

Poll: Which, in your opinion, is the best form of international cricket...

7
Really obvious stuff you learned or discovered later than you should have on 10:24 - Feb 28 with 2232 viewsbrazil1982

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.
2
Really obvious stuff you learned or discovered later than you should have on 10:28 - Feb 28 with 2221 viewsPecker

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.
0
Really obvious stuff you learned or discovered later than you should have on 10:54 - Feb 28 with 2179 viewsWeWereZombies

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).

Poll: Best use of vinegar?

1
Really obvious stuff you learned or discovered later than you should have on 11:02 - Feb 28 with 2155 viewsMeadowlark

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)
0
Really obvious stuff you learned or discovered later than you should have on 11:07 - Feb 28 with 2137 viewsmonytowbray

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.

"The world will not be destroyed by those who do evil, but by those who watch them without doing anything."
Poll: How close will a TWTD election poll be next to June results?

0
Really obvious stuff you learned or discovered later than you should have on 11:18 - Feb 28 with 2099 viewsParisBlue

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...

Libraries gave us power
Poll: Which position in the table will we be after Saturday?

0

Really obvious stuff you learned or discovered later than you should have on 11:28 - Feb 28 with 2077 viewstractordownsouth

That you don't need any detailed policies to win elections, you just need a meaningless slogan.

Poll: Who's Grimboy?
Blog: Season Preview 2015/16

1

Really obvious stuff you learned or discovered later than you should have on 11:29 - Feb 28 with 2079 viewsWD19

I only discovered relatively recently that all car fuel gauges tell you which side the fuel cap is on.
1
Really obvious stuff you learned or discovered later than you should have on 11:47 - Feb 28 with 2023 viewsFixed_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.

The glass is half full!!!
Poll: So which refund option did/will you go for?

1
Really obvious stuff you learned or discovered later than you should have on 12:22 - Feb 28 with 1982 viewsmonytowbray

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 :)

"The world will not be destroyed by those who do evil, but by those who watch them without doing anything."
Poll: How close will a TWTD election poll be next to June results?

0
Really obvious stuff you learned or discovered later than you should have on 12:33 - Feb 28 with 1945 viewsSuperblue95

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

My hobbies include being quiet during trips, clapping with songs, and diabetes.
Poll: Englands player of the tournament

0

Really obvious stuff you learned or discovered later than you should have on 12:35 - Feb 28 with 1935 viewsHalf_Idiot

Similarly with excel I recently discovered the sumproduct formula as opposed to the long winded formula of sum(X*Y,X*Y,etc...)
0
Really obvious stuff you learned or discovered later than you should have on 12:39 - Feb 28 with 1904 viewspositivity

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
0

Really obvious stuff you learned or discovered later than you should have on 12:55 - Feb 28 with 1879 viewsBLUEBEAT

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.


Poll: Most pointless?

1
Really obvious stuff you learned or discovered later than you should have on 12:56 - Feb 28 with 1879 viewsTangledupin_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.

Poll: Which, in your opinion, is the best form of international cricket...

0

Please log in or register. Registered visitors get fewer ads.
About Us Contact Us Terms & Conditions Privacy Cookies Advertising
© TWTD 1995-2020