| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Formula to search ranges??
I need to prepare a conditional formula that will confirm or reject the data
in Column A to the data in Columns B and C as well as the range of numbers in between B and C. Columns B and C are roughly twenty thousand lines and range anywhere from 1 to 1000 numbers. For example: Column A Column B Column C 473190044 491987100 491987199 511373007 491987200 491987299 542418053 491987300 491988300 Can excel search a range of 100-199 like in columns B and C or will all numbers require a individual cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Problem with graph ranges | Charts and Charting in Excel | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
