disulfidebond

Notes: A hash symbol (#) denotes a comment that is not part of any code or Excel formula entry
The following is a cookbook of solutions to common problems with data file manipulation.  
When possible, solutions for fixes within Excel and outside of Excel are provided.

I. Problem: There are duplicates in a column, but you don't want to lose row ordering

Solution Within Excel:  Pick a column with unique identifiers, or create a new column with unique identifiers in each row with the command:
       
        =1 # add this to the first cell in the column
        =[row]+1 # copy and paste this this to each subsequent cell in the column

disulfidebond

#!/bin/sh


sudo apt-get update

sleep 1

sudo apt-get install apt-transport-https ca-certificates curl software-properties-common

curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -

disulfidebond

Bash Cheatsheet and Quick Reference

Introduction

This guide provides an overview to Bash, and is divided into sections on Introduction, Overview, Advanced, Awk, Sed, and Grep. Note that there is overlap among the sections, such as the Advanced section describing piping in Bash using grep. External links are noted by links, and bash commands are denoted by italics. Some commands can be copied and pasted, however, caution should be used when copying and pasting from this guide, and extreme caution should be used when copying and pasting bash commands from an unknown or unverified source, because there is no "undo" when commands are executed from a Bash terminal window.

Key Concepts:

• Comments in bash are denoted with a hash # symbol:

echo 'Hello World' # <- everything after here will be ignored by Bash