| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I compare a number against a list of numbers
In Excel 2003, I have a row of 7 numbers and wish to find if any of those
numbers is in a vertical list of 24 numbers and to highlight the numbers which are on the vertical list. Have tried writing a macro but have failed! |
|
#2
|
|||
|
|||
|
Select the range of 24 numbers, go to Format
Conditional Formatting, select "Formula Is", and put: =COUNTIF(rng,INDIRECT("rc",0)) where "rng" is a defined name for the range of 7 numbers. Press the Format button and format as desired. HTH Jason Atlanta, GA -----Original Message----- In Excel 2003, I have a row of 7 numbers and wish to find if any of those numbers is in a vertical list of 24 numbers and to highlight the numbers which are on the vertical list. Have tried writing a macro but have failed! . |
|
#3
|
|||
|
|||
|
Very nice
"Jason Morin" wrote: Select the range of 24 numbers, go to Format Conditional Formatting, select "Formula Is", and put: =COUNTIF(rng,INDIRECT("rc",0)) where "rng" is a defined name for the range of 7 numbers. Press the Format button and format as desired. HTH Jason Atlanta, GA -----Original Message----- In Excel 2003, I have a row of 7 numbers and wish to find if any of those numbers is in a vertical list of 24 numbers and to highlight the numbers which are on the vertical list. Have tried writing a macro but have failed! . |
|
#4
|
|||
|
|||
|
Nice. Is there a way to do the opposite as far as highlighting the numbers
in the range of 24 that are not in the range of 7 numbers? "Jason Morin" wrote: Select the range of 24 numbers, go to Format Conditional Formatting, select "Formula Is", and put: =COUNTIF(rng,INDIRECT("rc",0)) where "rng" is a defined name for the range of 7 numbers. Press the Format button and format as desired. HTH Jason Atlanta, GA -----Original Message----- In Excel 2003, I have a row of 7 numbers and wish to find if any of those numbers is in a vertical list of 24 numbers and to highlight the numbers which are on the vertical list. Have tried writing a macro but have failed! . |
|
#5
|
|||
|
|||
|
Thanks. You can use:
=COUNTIF(rng,INDIRECT("rc",0))=0 Jason -----Original Message----- Nice. Is there a way to do the opposite as far as highlighting the numbers in the range of 24 that are not in the range of 7 numbers? "Jason Morin" wrote: Select the range of 24 numbers, go to Format Conditional Formatting, select "Formula Is", and put: =COUNTIF(rng,INDIRECT("rc",0)) where "rng" is a defined name for the range of 7 numbers. Press the Format button and format as desired. HTH Jason Atlanta, GA -----Original Message----- In Excel 2003, I have a row of 7 numbers and wish to find if any of those numbers is in a vertical list of 24 numbers and to highlight the numbers which are on the vertical list. Have tried writing a macro but have failed! . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding the second largest number in a list | Excel Discussion (Misc queries) | |||
| Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
| How do I pick a number from a list in Excel? | Excel Worksheet Functions | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
