Sometimes sorting gets really frustrating when all the data you are trying to sort isn’t formatted the same.
Create a new column next to the column you’re attempting to sort, then use this formula to move X amount of characters. I’m using Ford Part #’s and I need to sort by the 4th character in which is the Z
A2 cell = C0AZ-7153-A
Whereas x = the amount you want to move for example
From there just copy that formula to the rest of the cells in the new column then u can sort sheet under that column.
Data coming from different spreadsheet.
B25 = local cell which you are using for the search
URL = url from separate google sheet
sheet1 = name of other sheet your pulling data from
!a1:e = range of the search
After the search
3 = which column you wish to pull the data from
false = will your results be sorted?
If you get #REF when you first try this, just click your mouse on that and it will bring up a “allow access” dialog. You need to allow access if your pulling data from another spreadsheet.
Here’s how to locally pull data from another sheet. For example, you have a sheet1 and sheet2.
B3 = cell you want to use for search
Sheet2 = Sheet your pulling data from
!C3:E3 = range you want to pull data from
3 = which column you want data from
false = results will not be sorted.
$ git clone https://github.com/insanum/gcalcli.git
$ cd gcalcli
$ sudo yum install python-gflags python-dateutil python-httplib2 python-pip
$ sudo pip install google-api-python-client
$./gcalcli (browswer should open and you need to authenticate to your google account, once that is successful…then jump back to your shell)
Show a week
$ ./gcalcli calw
Show a full month
Add an event
$ ./gcalcli –calendar ‘email@example.com’ –title ‘Your Mom my pad’ –where ‘YO Mommas’ –when ’12/12/2013 20:00′ –duration 120 –description ‘Play time with mommy’ –reminder 30 add
Verify the new event
$ ./gcalcli calm 12/2013
(will show month with your new event)
Add a quick note in current day, you MUST ALWAYS specify the calendar.
$ ./gcalcli quick –calendar ‘firstname.lastname@example.org’ ‘Going waterskiing with JohnnyPiper and Little JohnnyApples 8pm’
List all the calendars you have available
$ ./gcalcli list
Search the calendaras for events
$ ./gcalcli search Little
2013-09-07 8:00pm Going waterskiing with JohnnyPiper and Little JohnnyApples
Bunch more you can do like import vcs/vcal/ics files from Exchange etc. Can setup crons for helpful pop-up reminders, email notifications..etc
Read the man page for further details.