Hello,
Can anyone suggest a formula for the cells shaded in yellow in my screen shot? The answers I expect from the formula are also listed below in range C8:C11. Thank you.
Can anyone suggest a formula for the cells shaded in yellow in my screen shot? The answers I expect from the formula are also listed below in range C8:C11. Thank you.
Cell Formulas | ||
---|---|---|
Range | Formula | |
A1 | Product Code | |
A2 | 123 | |
A3 | 123 | |
A4 | 456 | |
A5 | 456 | |
B1 | Date Sold | |
B2 | 42384 | |
B3 | 42430 | |
B4 | 42425 | |
B5 | 42468 | |
C1 | Selling Price | |
C7 | answers s/b | |
C8 | 125 | |
C9 | 130 | |
C10 | 215 | |
C11 | 215 | |
F1 | Product Code | |
F2 | 123 | |
F3 | 123 | |
F4 | 456 | |
F5 | 456 | |
G1 | Price Effective Date | |
G2 | 42339 | |
G3 | 42430 | |
G4 | 42370 | |
G5 | 42475 | |
H1 | Price | |
H2 | 125 | |
H3 | 130 | |
H4 | 215 | |
H5 | 245 |