find missing value

  1. A

    find missing value

    I want to find missing value between to colum. like this <tbody> 1 3 how can I find value 2 between 1 and 3 4 8 and 5,6,7 between 4 and 8 </tbody> please any one tell me the formula for this. please help
  2. H

    Find missing value to make sum equal given number

    Hi, I am looking for a formula that help to auto-fill an emty cell (in a range) with value to make total sum equal a given number. Say a1=2, b1=4, c1=6, what formula do to find value of d1 to make the total e1=sum(a1:d1)=15 I know it may sound silly but I really need help. thks.

Some videos you may like

This Week's Hot Topics