SMALL function in EXCEL

[Lamar]

I am using the following formula to sum the 5 smallest
numbers in a row.

=IF(Q34>4,SUM(SMALL(B34:K34,{1,2,3,4,5})),SUM(B34:K34))

It works great, but I would like to highlight the 5
numbers the formula used.

Is there any way?

Thanks.

 

[Don Pistulka]

Lamar,

Use conditional formatting with this formula:


=OR(B34=SMALL($B$34:$K$34,1),B34=SMALL($B$34:$K$34,2),B34=SMALL($B$34:$K$34,
3),B34=SMALL($B$34:$K$34,4),B34=SMALL($B$34:$K$34,5))


For more on conditional formatting, see Debra Dalgleish's site:
http://www.contextures.com/xlCondFormat01.html

 

[Leo Heuser]

Lamar,

One way:

Select B34:K34 (from B34) and use this formula
in conditional formatting:

=OR(B34=SMALL($B$34:$K$34,ROW($1:$5)))

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.