Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Function
Hi All
I was wondering if there was a way to use the find function to rather than look for an exact value eg. "1" but to look for a range of numbers eg "between (number) + 5 & (number) - 5" or is a loop the best answer for this one? Thanks in Advance Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Function
What are you looking in?
1) A single cell; as in find if there is a 1 in "I have 1 book" 2) A single cell: as in find if A1 is a number in the range 4 to 6 3) A range? As in find if the any of the numbers 4,5,6 appear in A1:A20 Tell us more about the problem. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jason Zischke" wrote in message ... Hi All I was wondering if there was a way to use the find function to rather than look for an exact value eg. "1" but to look for a range of numbers eg "between (number) + 5 & (number) - 5" or is a loop the best answer for this one? Thanks in Advance Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Function
Hi Bernard V Liengme
Thanks for the responce to elaborate say I have a range("A1:A20") and I want to find all the cells thats value is say between 20 & 25. Jason "Bernard Liengme" wrote: What are you looking in? 1) A single cell; as in find if there is a 1 in "I have 1 book" 2) A single cell: as in find if A1 is a number in the range 4 to 6 3) A range? As in find if the any of the numbers 4,5,6 appear in A1:A20 Tell us more about the problem. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jason Zischke" wrote in message ... Hi All I was wondering if there was a way to use the find function to rather than look for an exact value eg. "1" but to look for a range of numbers eg "between (number) + 5 & (number) - 5" or is a loop the best answer for this one? Thanks in Advance Jason |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Function
This will tell you how many cells fit the criteria
=SUMPRODUCT(--(a1:a20=20),--(a1:a20<=25)) This is five the sum of those cells =SUMPRODUCT(--(a1:a20=20),--(a1:a20<=25), a1:a20) If you select all the range; use Format|Conditional Formatting and use Formula Is =AND(A1=20,A1<=25) and set a fill colour; then all the cells that fit the criteria will be in that colour best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jason Zischke" wrote in message ... Hi Bernard V Liengme Thanks for the responce to elaborate say I have a range("A1:A20") and I want to find all the cells thats value is say between 20 & 25. Jason "Bernard Liengme" wrote: What are you looking in? 1) A single cell; as in find if there is a 1 in "I have 1 book" 2) A single cell: as in find if A1 is a number in the range 4 to 6 3) A range? As in find if the any of the numbers 4,5,6 appear in A1:A20 Tell us more about the problem. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jason Zischke" wrote in message ... Hi All I was wondering if there was a way to use the find function to rather than look for an exact value eg. "1" but to look for a range of numbers eg "between (number) + 5 & (number) - 5" or is a loop the best answer for this one? Thanks in Advance Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find function?? | Excel Worksheet Functions | |||
Find Function | Excel Worksheet Functions | |||
find function | Excel Programming | |||
Find Function | Excel Programming | |||
backwards find function to find character in a string of text | Excel Programming |