Seeing all the Excel experts out here is giving me hope to solve this.
I am trying to find the 10 lowest (and if possible highlight them) of 20
numbers in a column and enter the results in the next column to the right.

There will be 6 columns total and 20 rows.
ADate BData Cdata Ddata Edata FData

The E Column is where I am looking to find the lowest 10 of 20 numbers
and the F Column is where I am looking to put those results.

Thank you in advance for any help you can give.

Dan


--
shredder

Maybe

=SMALL($E$1:$E$20,ROW(A1))

Put this in F where you want the result and drag down 10 rows.

Mike

"shred77" wrote:

Seeing all the Excel experts out here is giving me hope to solve this.
I am trying to find the 10 lowest (and if possible highlight them) of 20
numbers in a column and enter the results in the next column to the right.

There will be 6 columns total and 20 rows.
ADate BData Cdata Ddata Edata FData

The E Column is where I am looking to find the lowest 10 of 20 numbers
and the F Column is where I am looking to put those results.

Thank you in advance for any help you can give.

Dan


--
shredder

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message ...
| Seeing all the Excel experts out here is giving me hope to solve this.
| I am trying to find the 10 lowest (and if possible highlight them) of 20
| numbers in a column and enter the results in the next column to the right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20 numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

Thanks Mike. Sorry I didn't even make you break a sweat on that one! Works
great.
My data is actually in E2 : E21 but that adjustment was easy. Can I ask what
the (A1)) does in this formula? Because the A1 in my worksheet is a "date"
header.

Thanks again
--
shredder


"Mike H" wrote:

Maybe

=SMALL($E$1:$E$20,ROW(A1))

Put this in F where you want the result and drag down 10 rows.

Mike

"shred77" wrote:

Seeing all the Excel experts out here is giving me hope to solve this.
I am trying to find the 10 lowest (and if possible highlight them) of 20
numbers in a column and enter the results in the next column to the right.

There will be 6 columns total and 20 rows.
ADate BData Cdata Ddata Edata FData

The E Column is where I am looking to find the lowest 10 of 20 numbers
and the F Column is where I am looking to put those results.

Thank you in advance for any help you can give.

Dan


--
shredder

Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My data is in
E2 thru E21 and when I enter your formula it only highlights E3 thru E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers in the
column. I double checked everything and the formula is entered as shown in
the post.

The formula you gave for the finding and posting of the lowest 10 of 20
numbers worked with the mod (A1)) at the end. Look at Mikes reply and it will
show that. Not sure why it works that way, but that is why I'm here to learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message ...
| Seeing all the Excel experts out here is giving me hope to solve this.
| I am trying to find the 10 lowest (and if possible highlight them) of 20
| numbers in a column and enter the results in the next column to the right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20 numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

The ROW(A1) function returns a result of 1, and when you fill it down the
next row down will have ROW(A2) returning 2, and so on.
--
David Biddulph

"shred77" wrote in message
...
Thanks Mike. Sorry I didn't even make you break a sweat on that one! Works
great.
My data is actually in E2 : E21 but that adjustment was easy. Can I ask
what
the (A1)) does in this formula? Because the A1 in my worksheet is a "date"
header.

Thanks again
--
shredder


"Mike H" wrote:

Maybe

=SMALL($E$1:$E$20,ROW(A1))

Put this in F where you want the result and drag down 10 rows.

Mike

"shred77" wrote:

Seeing all the Excel experts out here is giving me hope to solve this.
I am trying to find the 10 lowest (and if possible highlight them) of
20
numbers in a column and enter the results in the next column to the
right.

There will be 6 columns total and 20 rows.
ADate BData Cdata Ddata Edata FData

The E Column is where I am looking to find the lowest 10 of 20 numbers
and the F Column is where I am looking to put those results.

Thank you in advance for any help you can give.

Dan


--
shredder

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My data is
in
E2 thru E21 and when I enter your formula it only highlights E3 thru E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers in
the
column. I double checked everything and the formula is entered as shown in
the post.

The formula you gave for the finding and posting of the lowest 10 of 20
numbers worked with the mod (A1)) at the end. Look at Mikes reply and it
will
show that. Not sure why it works that way, but that is why I'm here to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to solve this.
| I am trying to find the 10 lowest (and if possible highlight them) of
20
| numbers in a column and enter the results in the next column to the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20 numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

Thanks Biff! Worked like a charm.. and by the way. Where is a good source to
learn how to formulate this stuff. I have some excel books but hard to pick
out this sort of thing from the book.
--
shredder


"T. Valko" wrote:

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My data is
in
E2 thru E21 and when I enter your formula it only highlights E3 thru E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers in
the
column. I double checked everything and the formula is entered as shown in
the post.

The formula you gave for the finding and posting of the lowest 10 of 20
numbers worked with the mod (A1)) at the end. Look at Mikes reply and it
will
show that. Not sure why it works that way, but that is why I'm here to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to solve this.
| I am trying to find the 10 lowest (and if possible highlight them) of
20
| numbers in a column and enter the results in the next column to the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20 numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

Where is a good source to learn how to formulate this stuff.
I have some excel books but hard to pick out this sort
of thing from the book.

Yeah, I know what you mean!

You'll learn more in these forums than you will from a book! All you have to
do is invest the time! Read the posts and study the replies. Try applying
the solutions to your own applications. Keep a library of formulas for quick
reference.

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks Biff! Worked like a charm.. and by the way. Where is a good source
to
learn how to formulate this stuff. I have some excel books but hard to
pick
out this sort of thing from the book.
--
shredder


"T. Valko" wrote:

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted
depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My data
is
in
E2 thru E21 and when I enter your formula it only highlights E3 thru
E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers in
the
column. I double checked everything and the formula is entered as shown
in
the post.

The formula you gave for the finding and posting of the lowest 10 of 20
numbers worked with the mod (A1)) at the end. Look at Mikes reply and
it
will
show that. Not sure why it works that way, but that is why I'm here to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to solve
this.
| I am trying to find the 10 lowest (and if possible highlight them)
of
20
| numbers in a column and enter the results in the next column to the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20
numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

Biff is absolutely right! It's so hard to find the answer in a "book" when
you don't even know what you should be looking for in the first place. All I
can say is "Thank God for all you Excel EXPERTS out there!!
--
JM


"T. Valko" wrote:

Where is a good source to learn how to formulate this stuff.
I have some excel books but hard to pick out this sort
of thing from the book.

Yeah, I know what you mean!

You'll learn more in these forums than you will from a book! All you have to
do is invest the time! Read the posts and study the replies. Try applying
the solutions to your own applications. Keep a library of formulas for quick
reference.

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks Biff! Worked like a charm.. and by the way. Where is a good source
to
learn how to formulate this stuff. I have some excel books but hard to
pick
out this sort of thing from the book.
--
shredder


"T. Valko" wrote:

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted
depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My data
is
in
E2 thru E21 and when I enter your formula it only highlights E3 thru
E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers in
the
column. I double checked everything and the formula is entered as shown
in
the post.

The formula you gave for the finding and posting of the lowest 10 of 20
numbers worked with the mod (A1)) at the end. Look at Mikes reply and
it
will
show that. Not sure why it works that way, but that is why I'm here to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to solve
this.
| I am trying to find the 10 lowest (and if possible highlight them)
of
20
| numbers in a column and enter the results in the next column to the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20
numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

I think you are right. It does take some time but you and a lot of others
here sure know your stuff, and I'm certainly glad of that.. If I keep pullin'
my hair out trying to figure this stuff out, I will be a very patchy bald guy!

Any thoughts on the Excel 2003 bible from Wallenbach ( think that's his
name) ?
--
shredder


"T. Valko" wrote:

Where is a good source to learn how to formulate this stuff.
I have some excel books but hard to pick out this sort
of thing from the book.

Yeah, I know what you mean!

You'll learn more in these forums than you will from a book! All you have to
do is invest the time! Read the posts and study the replies. Try applying
the solutions to your own applications. Keep a library of formulas for quick
reference.

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks Biff! Worked like a charm.. and by the way. Where is a good source
to
learn how to formulate this stuff. I have some excel books but hard to
pick
out this sort of thing from the book.
--
shredder


"T. Valko" wrote:

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted
depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My data
is
in
E2 thru E21 and when I enter your formula it only highlights E3 thru
E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers in
the
column. I double checked everything and the formula is entered as shown
in
the post.

The formula you gave for the finding and posting of the lowest 10 of 20
numbers worked with the mod (A1)) at the end. Look at Mikes reply and
it
will
show that. Not sure why it works that way, but that is why I'm here to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to solve
this.
| I am trying to find the 10 lowest (and if possible highlight them)
of
20
| numbers in a column and enter the results in the next column to the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20
numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

I hear that JM!
--
shredder


"JM" wrote:

Biff is absolutely right! It's so hard to find the answer in a "book" when
you don't even know what you should be looking for in the first place. All I
can say is "Thank God for all you Excel EXPERTS out there!!
--
JM


"T. Valko" wrote:

Where is a good source to learn how to formulate this stuff.
I have some excel books but hard to pick out this sort
of thing from the book.

Yeah, I know what you mean!

You'll learn more in these forums than you will from a book! All you have to
do is invest the time! Read the posts and study the replies. Try applying
the solutions to your own applications. Keep a library of formulas for quick
reference.

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks Biff! Worked like a charm.. and by the way. Where is a good source
to
learn how to formulate this stuff. I have some excel books but hard to
pick
out this sort of thing from the book.
--
shredder


"T. Valko" wrote:

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted
depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My data
is
in
E2 thru E21 and when I enter your formula it only highlights E3 thru
E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers in
the
column. I double checked everything and the formula is entered as shown
in
the post.

The formula you gave for the finding and posting of the lowest 10 of 20
numbers worked with the mod (A1)) at the end. Look at Mikes reply and
it
will
show that. Not sure why it works that way, but that is why I'm here to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to solve
this.
| I am trying to find the 10 lowest (and if possible highlight them)
of
20
| numbers in a column and enter the results in the next column to the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20
numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

Any thoughts on the Excel 2003 bible from Wallenbach ( think that's his
name) ?

John Walkenbach. He's a highly respected author and his books are
recommended very often in these forums.

The best way to choose a book is to go to a bookstore and thumb through the
selections. I think the Bible is a general overview of the entire Excel
application. He also has books that are for a specific aspect of Excel. For
instance there is a book that is *all* about formulas. There are others that
are *all* about VBA programming and charting.

Here's a good listing of Excel and related books:

http://contextures.com/xlbooks.html

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
I think you are right. It does take some time but you and a lot of others
here sure know your stuff, and I'm certainly glad of that.. If I keep
pullin'
my hair out trying to figure this stuff out, I will be a very patchy bald
guy!

Any thoughts on the Excel 2003 bible from Wallenbach ( think that's his
name) ?
--
shredder


"T. Valko" wrote:

Where is a good source to learn how to formulate this stuff.
I have some excel books but hard to pick out this sort
of thing from the book.

Yeah, I know what you mean!

You'll learn more in these forums than you will from a book! All you have
to
do is invest the time! Read the posts and study the replies. Try applying
the solutions to your own applications. Keep a library of formulas for
quick
reference.

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks Biff! Worked like a charm.. and by the way. Where is a good
source
to
learn how to formulate this stuff. I have some excel books but hard to
pick
out this sort of thing from the book.
--
shredder


"T. Valko" wrote:

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted
depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My
data
is
in
E2 thru E21 and when I enter your formula it only highlights E3 thru
E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers
in
the
column. I double checked everything and the formula is entered as
shown
in
the post.

The formula you gave for the finding and posting of the lowest 10 of
20
numbers worked with the mod (A1)) at the end. Look at Mikes reply
and
it
will
show that. Not sure why it works that way, but that is why I'm here
to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to solve
this.
| I am trying to find the 10 lowest (and if possible highlight
them)
of
20
| numbers in a column and enter the results in the next column to
the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20
numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

Thank you Mr.Biff. I appreciate all your information!
--
shredder


"T. Valko" wrote:

Any thoughts on the Excel 2003 bible from Wallenbach ( think that's his
name) ?

John Walkenbach. He's a highly respected author and his books are
recommended very often in these forums.

The best way to choose a book is to go to a bookstore and thumb through the
selections. I think the Bible is a general overview of the entire Excel
application. He also has books that are for a specific aspect of Excel. For
instance there is a book that is *all* about formulas. There are others that
are *all* about VBA programming and charting.

Here's a good listing of Excel and related books:

http://contextures.com/xlbooks.html

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
I think you are right. It does take some time but you and a lot of others
here sure know your stuff, and I'm certainly glad of that.. If I keep
pullin'
my hair out trying to figure this stuff out, I will be a very patchy bald
guy!

Any thoughts on the Excel 2003 bible from Wallenbach ( think that's his
name) ?
--
shredder


"T. Valko" wrote:

Where is a good source to learn how to formulate this stuff.
I have some excel books but hard to pick out this sort
of thing from the book.

Yeah, I know what you mean!

You'll learn more in these forums than you will from a book! All you have
to
do is invest the time! Read the posts and study the replies. Try applying
the solutions to your own applications. Keep a library of formulas for
quick
reference.

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks Biff! Worked like a charm.. and by the way. Where is a good
source
to
learn how to formulate this stuff. I have some excel books but hard to
pick
out this sort of thing from the book.
--
shredder


"T. Valko" wrote:

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted
depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My
data
is
in
E2 thru E21 and when I enter your formula it only highlights E3 thru
E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers
in
the
column. I double checked everything and the formula is entered as
shown
in
the post.

The formula you gave for the finding and posting of the lowest 10 of
20
numbers worked with the mod (A1)) at the end. Look at Mikes reply
and
it
will
show that. Not sure why it works that way, but that is why I'm here
to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to solve
this.
| I am trying to find the 10 lowest (and if possible highlight
them)
of
20
| numbers in a column and enter the results in the next column to
the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20
numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder

You're welcome!

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thank you Mr.Biff. I appreciate all your information!
--
shredder


"T. Valko" wrote:

Any thoughts on the Excel 2003 bible from Wallenbach ( think that's his
name) ?

John Walkenbach. He's a highly respected author and his books are
recommended very often in these forums.

The best way to choose a book is to go to a bookstore and thumb through
the
selections. I think the Bible is a general overview of the entire Excel
application. He also has books that are for a specific aspect of Excel.
For
instance there is a book that is *all* about formulas. There are others
that
are *all* about VBA programming and charting.

Here's a good listing of Excel and related books:

http://contextures.com/xlbooks.html

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
I think you are right. It does take some time but you and a lot of
others
here sure know your stuff, and I'm certainly glad of that.. If I keep
pullin'
my hair out trying to figure this stuff out, I will be a very patchy
bald
guy!

Any thoughts on the Excel 2003 bible from Wallenbach ( think that's his
name) ?
--
shredder


"T. Valko" wrote:

Where is a good source to learn how to formulate this stuff.
I have some excel books but hard to pick out this sort
of thing from the book.

Yeah, I know what you mean!

You'll learn more in these forums than you will from a book! All you
have
to
do is invest the time! Read the posts and study the replies. Try
applying
the solutions to your own applications. Keep a library of formulas for
quick
reference.

--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks Biff! Worked like a charm.. and by the way. Where is a good
source
to
learn how to formulate this stuff. I have some excel books but hard
to
pick
out this sort of thing from the book.
--
shredder


"T. Valko" wrote:

To highlight the 10 smallest numbers:

Select the range E2:E21
Goto the menu FormatConditional Formatting
Formula Is:

=AND(E2<"",E2<=SMALL(E$2:E$21,10))

Click the Format button
Select the style(s) desired
OK out

Note that there could be more or less than 10 numbers highlighted
depending
on duplicates and how many numbers you actually have in the range.


--
Biff
Microsoft Excel MVP


"shred77" wrote in message
...
Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My
data
is
in
E2 thru E21 and when I enter your formula it only highlights E3
thru
E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20
numbers
in
the
column. I double checked everything and the formula is entered as
shown
in
the post.

The formula you gave for the finding and posting of the lowest 10
of
20
numbers worked with the mod (A1)) at the end. Look at Mikes reply
and
it
will
show that. Not sure why it works that way, but that is why I'm
here
to
learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message
...
| Seeing all the Excel experts out here is giving me hope to
solve
this.
| I am trying to find the 10 lowest (and if possible highlight
them)
of
20
| numbers in a column and enter the results in the next column
to
the
right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20
numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder