Posted to microsoft.public.excel.worksheet.functions

Bernd P

external usenet poster

Posts: 806

Min Match Function needed

Hello Bill,

I suggest to use my UDF Pstat with this small change:
Case "min", "minimum"
If (v(UBound(v))(i, 1) < "" And vR(UBound(v), obj.Item
(s)) v(UBound(v))(i, 1)) Or vR(UBound(v), obj.Item(s)) = "" Then

You can find my UDF he
http://sulprobil.com/html/pstat.html

Regards,
Bernd

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
re done Match formula needed	bill gras	Excel Worksheet Functions	3	November 30th 09 06:40 AM
match formula needed	bill gras	Excel Worksheet Functions	2	November 29th 09 06:12 AM
Index Match Help Needed Badly	[email protected]	Excel Discussion (Misc queries)	4	May 8th 06 02:45 AM
Index and Match Help Needed	carl	Excel Worksheet Functions	3	September 26th 05 09:42 PM
Index and match functions help needed.	Zak	Excel Worksheet Functions	5	September 1st 05 02:08 PM

All times are GMT +1. The time now is 07:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us