Quick Way to Check for Duplicates in a Column
I have been using this quick trick lately to check for duplicates in a column of values. Let’s say you have a list of a large group of numbers (characters work as well) and want to see if you have more than one instance of any of the numbers. To check for that, one simple [...]
Substitute Formula
The substitute formula is an relatively simple formula that can come in handy in many situations. I like to use this formula the most when a longer text field needs just a portion of it changed, without having to retype the entire cell value. Let’s go ahead and take a look at the substitute formula:
=SUBSTITUTE(Text, [...]
Excel Hints is almost fixed!
I have been having numerous problems with the site lately and am finally almost finished getting everything back to working order. For a long time I was unable to upgrade my version of WordPress without it crashing, but that problem is now fixed. I have put back together all the category sections (I’m still working [...]
Loading ...