jaykilleen

'Just copy the function below into a new module
'I usually call this module 'functions'
'You can then call anywhere in your scripts `get_row_number("dummy text", 1)
'The integer '1' will tell this to do a ctrl+f on column A
'When it finds the first value it will return the row number of that value
'Best used on columns that contain unique values
'You might need to change the xlPart to xlWhole if you are going for an exact match
'You could also extend this function to pass in a boolean to look for whole or partial value and replace xlPart with the value passed in
`checkout https://gist.github.com/jaykilleen/892d0f0eed87b9f8e6b0 for other functions that I like to add into my 'functions' module.

jaykilleen

<div class="container">
  <div class="row">
    <div class="col-sm-4 col-sm-offset-4">
      <div class="light-well">
        <h2 class="page-header text-center">Edit <%= resource_name.to_s.humanize %></h2>

        <%= form_for resource, as: resource_name, url: registration_path(resource_name), html: { method: :put },
                      html: { class: "form-horizontal center"} do |f| %>

          <div class="form-group">

jaykilleen

/*
Taken and cribbed from blog.datalicious.com/free-download-all-australian-postcodes-geocod

May contain errors where latitude and longitude are off. Use at own non-validated risk.
*/

let
  Source =  Table.FromList(
    {
      [ID="200",Name="Australian National University",State="ACT",Lat="-35.28",Long="149.12"],