| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet formulae problems.
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet formulae problems.
=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? Nevyn907 wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing all formulae in a worksheet from absolute to relative | Excel Discussion (Misc queries) | |||
| Using Worksheet names in formulae | Excel Discussion (Misc queries) | |||
| Problems with COUNTIF formulae | Excel Discussion (Misc queries) | |||
| Making formulae function throughout worksheet | Excel Worksheet Functions | |||
| formulae problems:HELP | Excel Discussion (Misc queries) | |||
Linear Mode
