Hoping someone has done this before - I want to be able to copy paste raw data into a "Data dump" tab (that i will just build upon incrementally 'forever' or reuse over and over after preserving the output data using paste special - values) and have another tab serve as the destination to where the table and formula will live.
The source data is comprised of 3 values (excerpt below). The idea is that I will trend this data which is received multiple times per day. If I just grab everythign in the report (raw data is in notepad) and copy paste into one tab, how can I have a formula search both the data AND the hour, then once a match is found only pull the value in the 3rd column in? Even if I can get this to work what happens if there are duplicates in that the ame date with same hour but slightly different count in the 3rd column?
Here is the formula I started with: =SUMIF('Dump Area'!$B$3:$B$26,$B13,'Dump Area'!$C$3:$C$26)
It works, but only if I group pdays separately (thereby only matching on the 'hour' not the date.
I've seen references to SUMIFS, VLOOKUP, INDEX, and a few others but none seem to help.
What am I doing wrong?
Disc_Date Disc_Hr CallCnt
2013-07-25 10 425
2013-07-25 11 479
2013-07-25 12 629
2013-07-25 13 868
2013-07-25 14 1127
2013-07-25 15 1458
2013-07-25 16 1941
2013-07-25 17 1496
2013-07-25 18 1086
2013-07-25 19 660
2013-07-25 20 584
2013-07-25 21 484
2013-07-25 22 429
2013-07-25 23 566
2013-07-25 08 323
2013-07-25 09 400
2013-07-26 00 583
2013-07-26 01 597
2013-07-26 10 209
2013-07-26 11 241
2013-07-26 12 410
2013-07-26 13 380
2013-07-26 14 479
2013-07-26 02 599
2013-07-26 03 411
2013-07-26 04 250
2013-07-26 05 209
2013-07-26 06 161
2013-07-26 07 178
2013-07-26 08 180
2013-07-26 09 176
Bookmarks