Both of your formulas worked for the first cell but when I tried to drag it down I received #N/A errors. Am i doing something wrong here?