Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up function
I have a list of numbers, i need to do a search to match all the numbers on
that llst with the one i put in the look up function. ex. I'm looking for the #3 B D E F 2 3 6 5 15 3 7 9 10 12 4 9 3 14 18 5 3 15 11 12 Is there a function that i could type the #3 in the formula and it will highlight all the #3's in the list so therefore, i should be able to see B2, B5 & D4 highlighted. please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up function
Edit Find Findall
you will be presented with a list. If you hi-light all the items on the list, all the equivalent cell will also be hi-lighted. -- Gary''s Student - gsnu200826 "Anna" wrote: I have a list of numbers, i need to do a search to match all the numbers on that llst with the one i put in the look up function. ex. I'm looking for the #3 B D E F 2 3 6 5 15 3 7 9 10 12 4 9 3 14 18 5 3 15 11 12 Is there a function that i could type the #3 in the formula and it will highlight all the #3's in the list so therefore, i should be able to see B2, B5 & D4 highlighted. please help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up function
Easiest way and quickest is probably with a conditional format. Suppose the
cell youwant to match is F7, go to format-conditional formatting in the three boxes select cell value is equal to $f$7 use the paint brush to copy the format to the rest of your table. note shift, ctrl plus arrow keys fills in the format very quickly rather than doing each cell. "Anna" wrote: I have a list of numbers, i need to do a search to match all the numbers on that llst with the one i put in the look up function. ex. I'm looking for the #3 B D E F 2 3 6 5 15 3 7 9 10 12 4 9 3 14 18 5 3 15 11 12 Is there a function that i could type the #3 in the formula and it will highlight all the #3's in the list so therefore, i should be able to see B2, B5 & D4 highlighted. please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |