Worksheet formulae problems.

N

Nevyn907

Hi Folks got a prob you can maybe help me with.

I have a range of cells that contain one of the following numbers 114 115. I
am trying to devise a formulae that will identify whichever number is missing
and duplicate that number in an answer cell
 
D

Dave Peterson

=if(countif(a1:c9,114)=0,114,if(countif(a1:c9,115)=0,115,"both there"))

If both are missing, you'll see 114. Is that ok?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple Cells 2
formula error 1
Excel Formula - Count Dates from another Sheet 8
Excel - Formulas 3
Excel Need Countifs Formula Help 0
Create an Averaging Formula 1
Complicated Formula 1
Summing rows using formulas with variables 1

Top