It would be a VBA function. I have it already written. My problem is that I have an entre row that this Function will be running in so for example I have this function in A5 through A20 I want it to run against column B in the adjacent cells so a 5 would go against B5.