formula reverse

  1. M

    Reversing a Formula

    This is a little tricky and I don't know if it can be done. I'm trying to accomplish a few things. First, on Sheet 2, after putting odds in cells B3 & B4 (ex: +150 and +160), it will show how much needs to be bet in D4 (based on $25 bet on the lower odds in D3), same total profit that will...
  2. R

    Formula Required to reverse list skipping blank cells

    I have a list values in column R. In column A I want to display the same list in reverse order. The following formula in column A achieves this =INDEX(R:R,COUNTA(R:R)-ROW()+1) The problem I have is that if there is a blank cell in R, column A will miss the last record in R. I realise this...

Some videos you may like

This Week's Hot Topics