find the smallest number

I have the same number series need to find the smallest number.

Not quite sure whats required..

Try using the Min function..

Sanju,
Try this code: (In VBA editor you will need to go to Tools>References, and check the box next to "Microsoft Scripting Runtime" to use the code)

Please Login or Register  to view this content.

Sanju, did you read my whole post? You need to add a reference to the Microsoft Scripting Runtime
in VBA editor->Tools->References, and check the box next to "Microsoft Scripting Runtime"

How about just a formula?

=MIN(IF($B$3:$B$66=B3, $C$3:$C$66))

Confirmed with Ctrl+Shift+Enter.

Or a pivot table:

Row\Col	G	H
2	Min of Value
3	Equal	Total
4	0	17
5	1000	5
6	2000	14
7	3000	32
8	4000	-2
9	5000	1
10	6000	-53