| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Ignoring specific number
Okay I am try to sum up half a row and subtract away the other half of a row. It is a coding scheme however and I want excel to ignore every time there is a 99, so pretend it is a 0 in other words, but there is too much data to change them all to 0. Thanks in advance for your help.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count text with specific criteria ignoring N/A and blanks | Excel Worksheet Functions | |||
| specific number input, specific number output | Excel Programming | |||
| How do I sorty by addresses, ignoring number, using street name | Excel Worksheet Functions | |||
| How to get the minimum number of one column while ignoring the err | Excel Discussion (Misc queries) | |||
| Ignoring negative number | Excel Worksheet Functions | |||
Linear Mode
