DMAX with multiple critreia HELP PLEASE

[Excel_Illerate]

Hello all,

I'm attempting to convert a "multiple criteria" Lotus 123 @DMAX function to a "multiple criteria" Excel =DMAX function. I've received some assistance but it did not solve the problem. Thank you for the help.

Does anyone out there have data base experience using the =DMAX function with multiple criteria? The question is to involved to attempt to explain and display it again and I haven't figured out how to post the formula here as "code".

If someone has data base experience and is interested in attempting to assist in creating the working =DMAX function with the multiple criteria, I can send you a file explaining and displaying the entire functions use. The file size is 29 KB's. Please advise me.

Thank you for any assistance.

 

[GlennUK]

... The question is to involved to attempt to explain and display it again and I haven't figured out how to post the formula here as "code". ...

I doubt that you will get any answers without explaining what you want.

 

[Excel_Illerate]

Hello GlennUK,

I have attempted to explain this problem in the below posts:

http://www.mrexcel.com/forum/showthread.php?t=560678
and
http://www.mrexcel.com/forum/showthread.php?p=2773104#post2773104

I've been pestered for quite a while now (by friends that use Excel) to convert from Lotus 123 to Excel. Everyone tells me that Excel can do so much more than 123. OK, I finally decided to do so.

But, this formula did not convert from 123 to Excel and is something I don't know how to do. I did receive some assistance, but it did not provide the correct answers to model the 123 workbook.

I'd be more than happy to send an example file to anyone (as we do in the 123 forums) if someone were interested in showing me what I'm doing wrong.

Guess I don't convert. Thank you though for the reply.

 

[GlennUK]

This does what you want ( although you never said what is supposed to happen if a second lowest draw for a number doesn't exist ... in my formulas it returns a #REF error) :

Excel Workbook
	C	D	E	F
3		258
4
5
6
7
8
9	1	2	3	4
10
11	247	0	247	247
12
13
14	228	248	243	241
15
16
17	#REF!	244	240	237
Sheet1

 

[crusader]

I've been pestered for quite a while now (by friends that use Excel) to convert from Lotus 123 to Excel. Everyone tells me that Excel can do so much more than 123. OK, I finally decided to do so.

Have you explored LibreOffice?

 

[Excel_Illerate]

Hello crusader,

No I haven't seen that before. I will look into it. Thank you.

And GlennUK has developed a formula that works for my usage. Thank you also.