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

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

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

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