So, heres the deal, i imported several data from a XML.
That data contains sold volume of specific items on a 15 day period.
as you can see here
version currentTime name key typeID regionID date LowPrice highPrice avgPrice volume orders
2 2013-06-13 20:54:47 history 438 10000002 5/30/2013 1106060.91 1247994.77 1247994.66 2999 459
2 2013-06-13 20:54:47 history 438 10000002 5/31/2013 1247994.66 1247994.7 1247994.68 1684 426
2 2013-06-13 20:54:47 history 438 10000002 6/1/2013 1247995 1250000 1249999.94 1096 428
2 2013-06-13 20:54:47 history 438 10000002 6/2/2013 1274099.88 1275000 1274999.99 418 192
2 2013-06-13 20:54:47 history 438 10000002 6/3/2013 1275000 1429973.53 1429973.46 621 296
2 2013-06-13 20:54:47 history 438 10000002 6/4/2013 1275943.89 1429972.68 1429972.64 905 404
2 2013-06-13 20:54:47 history 438 10000002 6/5/2013 1422995.91 1422999.99 1422996.92 1300 508
2 2013-06-13 20:54:47 history 438 10000002 6/6/2013 1320000 1422990.35 1421988.35 2194 608
2 2013-06-13 20:54:47 history 438 10000002 6/7/2013 1350022.94 1400022.98 1400019.95 1296 545
2 2013-06-13 20:54:47 history 438 10000002 6/8/2013 1349996.92 1400019.8 1400019.58 1989 560
2 2013-06-13 20:54:47 history 438 10000002 6/9/2013 1394999.89 1400019.54 1398999.98 2063 631
2 2013-06-13 20:54:47 history 438 10000002 6/10/2013 1333334 1394997.8 1394995.58 2929 499
2 2013-06-13 20:54:47 history 438 10000002 6/11/2013 1394991.98 1394995.52 1394993 1840 507
2 2013-06-13 20:54:47 history 438 10000002 6/12/2013 1393999 1393999.99 1393999.96 1040 388
2 2013-06-13 20:54:47 history 440 10000002 5/30/2013 1650010.24 1809998.8 1804989.58 778 271
2 2013-06-13 20:54:47 history 440 10000002 5/31/2013 1803984.57 1804985.03 1803984.73 969 235
2 2013-06-13 20:54:47 history 440 10000002 6/1/2013 1650021.36 1803948.48 1802998.78 1213 307
2 2013-06-13 20:54:47 history 440 10000002 6/2/2013 1802999 1803948.43 1802999.92 437 135
2 2013-06-13 20:54:47 history 440 10000002 6/3/2013 1802000 1803917.98 1803917.92 486 207
Each XML Imported has at least 15 different items, they way i can recognized them is by his TypeID
Right next to the this table i got an =AVERAGE function will calculate the average sold volumen for the past 15 days like these: =AVERAGE(A10:A20)
On my main Tab, i can make a =Data!A2
Thing is i would love to get a Vlookup+Average function to work without doing the average manually on each TypeID.
Is there any way to simplify this?.
Bookmarks