To sort a row of columns:
Define the following formula on a blank row:
=transpose(sort(transpose(C3:H4)))
Then just copy the sorted row and copy...special..values only
Delete all but the copied row
To sort column of addresses that contain street numbers [1]: Create a blank column next to the address column. Select a blank cell adjacent to the address list, and type this formula: =MID(A1,FIND(” “,A1)+1,255) (A1 is the cell of your address list), and press Enter button, then drag the fill handle to fill the range you want. After that, you can see all addresses are extracted to the help column except the street numbers.
Baseball was my primary sport growing up, and of course I enjoyed immensely coaching David and Kristen in youth baseball. When it comes to watching, however, it’s one of my least favorite sports to watch for all the reasons stated in the article.
Here is my radicle idea: Any ball hit over the fence is an out. It’s not original. I played in a coed softball team that had that rule in place.
The following will create a new file with lines removed containing given pattern:
cat file.txt | grep -v "pattern" >filtered.txt
Match two words:
grep -E -i -w 'word1|word2' sourcefile.txt
grep -rl "string" /path // -r recurse, -l output filenames only
What is the ultimate quantification of success? For me, it’s not how much time you spend doing what you love. It’s how little time you spend doing what you hate – Casey Neistat
Kristen’s heading to Houston Baptist University in 2 months. We decided to finally retire the 2006 Sportage in our family (thank you Mom) and get her a new Kia Sportage with the latest collision avoidance safety features standard in the Sportage 2020. Doesn’t look too bad either!
One of the best stories I’ve heard. Hopefully more medical schools will follow. I believe it has a huge potential to solve what’s wrong with our medical system in America.
“In the field of medicine, schools have become worried that students saddled with steep debt are increasingly pursuing top-paying specialties rather than careers in family medicine, pediatrics and research. “
I use a wallet case for my phones. It holds my driver’s license, a few cards and some bills. Don’t have to keep track of a wallet and I think it offers some of the best protection for a phone. This new case with a strapless design does a sufficient job of keeping the cover closed. On the way home from Dallas during the Cleveland Cincinnati game I found this terrific use of the case. I was able to secure it by folding the cover and pinching the vanity cover on my passenger visor! It held strong the entire trip and offered a glare-free convenient position to watch the game on the road! Probably helped that my newest phone, the Motorola G6 is on the smaller size. So far it’s been a great phone!
I was set to get a new Google Pixel 3 phone $150 off $800 during Thanksgiving. Then I came across the G6 I could get for $189 at Costco ($50 off). You can get it on Amazon for $200. I decided to give it a try and so far, I’m pretty happy with it. My Google Nexus 6 phone was starting to have issues and no longer allowed Android Auto to work in my car.
The phone is slightly thinner but taller with a 18:9 ratio rather than the standard 16:9. It has tons of features which I’m still discovering. This is the first phone I’ve owned with a fingerprint scanner and I really like how convenient and quick it is to unlock the phone. I can define motion actions as shortcuts to various functions. For example shaking it twice will turn on the flashlight!
It has a 12m front facing dual-camera. Judging from the 1st photo I shot on our back porch, it is plenty nice!
I could buy a phone like this EVERY year at this price and in 4 years I would have spent as much as an iPhone!
