Pull different kind values from a range

[hsandeep]

I have a range which consists of 1 row x 12 columns but columns are not continuous & are 'spitted' like B2:D2; G2:I2 & L2:Q2.
Each cell in the above range=value or "" (null).

Output required:
1. S2=Value of Rightmost cell (in the range) having value>0
2. T2=Value of Rightmost - 1 cell i.e. 1 cell LEFT to the above cell.
3. U2=MAXIMUM value in the range.
Y. V2=MINIMUM value in the range.

Lastly;
Cell address (RC1 style) of the above outputs in W2, X2, Y2, Z2 respectively.

Thanks for sparing your time...

 

[hsandeep]

Note:
1.The above range MAY OR MAY NOT contain 'duplicate' numbers. The numbers in the range are generated thr' formulas. Though, it may contain "" in some cells of the above range.
2. If any cell has generated a value; all left cells of it will always contain a value (may be equal to 0 also) but NEVER "" (null) except the FIRST cell of the range because there is no cell/(s) to the left of FIRST cell.
3. For multiple max/min; the 'first' max/min occurrence has to be taken into account respectively.

Kindly help with the formulas in S2, T2, U2, V2, W2, X2, Y2 & Z2.

 

[hsandeep]

It may be that someone is 'close' to the answers but may be having some queries. I'll be happy to clarify all of those query/(ies), if any.

 

[hsandeep]

Example:
I have B2=4, C2=99, D2="", G2=7, H2=5, I2=88, L2:R2="" (Input)
Output:
1. S2=Value of Rightmost cell (in the range) having value>0 88
2. T2=Value of Rightmost - 1 cell i.e. 1 cell LEFT to the above cell. 5
3. U2=MAXIMUM value in the range. 99
4. V2=MINIMUM value in the range. 4

5. W2=I2
6. X2=H2
7. Y2=C2
8. Z2=B2

How to accomplish this please?