1

Topic: To deduce in 3 fields of 3 values from request

, salute!
Prompt - a head broke already.
There is a request, in which only 3 lines.
For example:
321
234
75
As to me to deduce these values on fields in shape.
With maximum 321 and minimum 75 values clearly - through function Dmax and Dmin .
And how to deduce 234?
In advance thanks!

2

Re: To deduce in 3 fields of 3 values from request

=DMax (the Field, Request, ' WHERE the Field <' and DMax (the Field, Request))

smile))

3

Re: To deduce in 3 fields of 3 values from request

Akina;
That that not that:

=DMax ("[Top]"; "[Total]"; ' WHERE "[TOP]" <' and DMax ("[Top]"; "[Total]"))

4

Re: To deduce in 3 fields of 3 values from request

MAX MIN wrote:

that that not that:

not something, and inverted commas.

=DMax ("[Top]"; "[Total]"; "WHERE [TOP] <" and DMax ("[Top]"; "[Total]"))

5

Re: To deduce in 3 fields of 3 values from request

Akina;
In the field instead of value - the ERROR

6

Re: To deduce in 3 fields of 3 values from request

MAX MIN , not, well I am fine - I can write from a lantern... Well you should look that ! At least on syntax.
WHERE remove...

7

Re: To deduce in 3 fields of 3 values from request

Akina;
Precisely, an eye
THANKS!

8

Re: To deduce in 3 fields of 3 values from request

WHERE to remove
It is possible still Dlookup ("[TOP]"; "TOTAL"; "[TOP] <>" and {here received earlier max value} AND [TOP] <> "and {here received earlier min value})