Forum Discussion
...
...cant delete post so editing it instead
...
Christie1991 Yes, that's right! But.... if you want to be able to copy the formula down the column you need to fix the reference to C2 by adding dollar signs. I've added some formulae in your file (re-attach). See what happens when you leave out the dollar-signs and copy the formula in F5. Doing is the best way of learning!