Pulling data into a table based on date and number criteria

JJabra

New Member
Joined
Aug 19, 2019
Messages
37
Hi Guys,

I have a list of raw data on a separate tab to the table which consists of two columns, dates and the second column holds a number between 1 and 5.

What I want is for the table to pull data from the raw data so that everything it counts how many of each number between 1-5 there are in each week as has been manually entered below.

Upon looking online I am struggling to find similar examples to help me get started. Any help would be appreciated

Week OneTwoThreeFourFive
01/01/2018​
102126
08/01/2018​
42268
15/01/2018​
854920
22/01/2018​
105121927
29/01/2018​
1312163654
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
Hello, I did not understand the example well.
You could explain again what data you have in the "raw data" sheet.
What do you have on the other sheet.
What results do you expect on the other sheet.
And please explain a couple of examples.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,659
Messages
5,549,268
Members
410,905
Latest member
Extjel
Top