S
SK08
Hi,
Right now I have two sheets, sheet 1 has a list of dates in column A
(each date only listed once). Sheet 2 has individual purchases, with
the dates in column A and the price in column B.
Based on the date (listed in one cell) in sheet 1 i want to find the
average price of all the purchases on that date in sheet 2 (listed in
many cells).
Right now, in sheet 1, cell B3, my formula is :
=AVERAGE(VLOOKUP($A3,'Bond 1 Analysis (3)'!$A$3:$B$11357,2,FALSE))
I am getting a number (not "N/A", etc), but it is different than the
average I got for the date when I did it manually to check.
Right now I have two sheets, sheet 1 has a list of dates in column A
(each date only listed once). Sheet 2 has individual purchases, with
the dates in column A and the price in column B.
Based on the date (listed in one cell) in sheet 1 i want to find the
average price of all the purchases on that date in sheet 2 (listed in
many cells).
Right now, in sheet 1, cell B3, my formula is :
=AVERAGE(VLOOKUP($A3,'Bond 1 Analysis (3)'!$A$3:$B$11357,2,FALSE))
I am getting a number (not "N/A", etc), but it is different than the
average I got for the date when I did it manually to check.