How Do I

Question

test 2 GLA Graph.xlsx

I'm trying to figure the content content fro cells E4, G4 and H4

                                                                          E5, G5 and H5

                                                                          E6, G6 and G6

If the formula for cell G4 could be created I could make the adjustments and copy to the other cell.

G4 formula would be based on the data found on Sheet 2 with search criteria on Sheet 1

The formula would be based on cross referencing the GLA search criteria of cell D17 and F17. Lot Size search criteria of cells D20 and F20. Age of cells D23 and F23, by the date filter of L2 and L4. to the column and cell corresonding below.

The GLA data is in Sheet2 (I16:I650)

The Lot Size data is from the and range of Sheet 2 (M16:M650)

The Age range is from Sheet 2 (J16:J650)

The date range for sold (Close Price) is G16:G6560)

If the data falls within those three criteria and data filter, then bring forward the Close Price found in the Sheet 2 range of (H16:H650) by Minimum, Maximun and Count into the assigned cells on Sheet 1.

Thank You

Answer 1

Bill and Will:

Snow Lu's solution works perfectly well.

It's just not modern.

Share desired scenarios for PP/PQ solutions.

Answer 2

That's complicated

What am I doing wrong with Snow Lu solution

Answer 3

Excel 365 Pro Plus with Power Pivot and Power Query.

Price vs Size vs Year

No formulas, no VBA macro.

With PivotChart and CF.

https://www.mediafire.com/file_premium/xpl4sn7f0lolfmq/03_02_25.xlsx/file

https://www.mediafire.com/file_premium/gsqjvsvkwyqss5x/03_02_25.pdf/file

Answer 4

test 2 GLA Graph.xlsx

Snow Lu,

I tried the formula in cell G4 of Sheet1 of the attached spreadsheet. Something went wrong. Could you tell me what I did wrong.

Thank You

Answer 5

Try this one to get a list of all the items.

=FILTER(Sheet2!H16:H650,

(Sheet2!I16:I650＞D17)*(Sheet2!I16:I650＜F17)*

(Sheet2!M16:M650＞D20)*(Sheet2!M16:M650＜F20)*

(Sheet2!J16:J650＞D23)*(Sheet2!J16:J650＜F23)*

(Sheet2!G16:G650＞L2)*(Sheet2!G16:G650＜L4)

)

Then you can apply min, max or count on it.

=Min(filter formula)