Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, I have a problem with pivot table and conditional formatting please help
Solved by V. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 20/03/2018 - 11:46
Hi, please help me!!
Excelchat Expert 20/03/2018 - 11:46
Hi
Excelchat Expert 20/03/2018 - 11:46
Yes please let me know your requirements
User 20/03/2018 - 11:46
Can you see my data?
Excelchat Expert 20/03/2018 - 11:46
yes
User 20/03/2018 - 11:46
Ok great
User 20/03/2018 - 11:47
I need to create a pivot table of this data. Count of lead sources but within specific date ranges
User 20/03/2018 - 11:47
for example I need to see the count of all lead sources from 13th December to 21st January
Excelchat Expert 20/03/2018 - 11:48
ok
Excelchat Expert 20/03/2018 - 11:48
dates you can select in filters of pivot
User 20/03/2018 - 11:49
I need the following
User 20/03/2018 - 11:49
13/12/2017 - 24/01/2018
User 20/03/2018 - 11:49
25/01/2018 - 21/02/2018
User 20/03/2018 - 11:50
22/02/2018 - 20/03/2018
Excelchat Expert 20/03/2018 - 11:50
so in you base data you can tag the dates to be between these range
User 20/03/2018 - 11:50
ok please show me how
User 20/03/2018 - 11:53
:)
User 20/03/2018 - 11:53
What should I do next?
Excelchat Expert 20/03/2018 - 11:53
working on it
Excelchat Expert 20/03/2018 - 11:53
2 min
User 20/03/2018 - 11:53
Oh thankyou
Excelchat Expert 20/03/2018 - 11:56
did you see in spreadsheet?
Excelchat Expert 20/03/2018 - 11:57
using if formula i have specified which date comes on which bucket
Excelchat Expert 20/03/2018 - 11:57
do you get that?
Excelchat Expert 20/03/2018 - 11:57
are you there buddy?
Excelchat Expert 20/03/2018 - 11:57
let me know if you do not understand
User 20/03/2018 - 11:58
Sorry I do not understand
Excelchat Expert 20/03/2018 - 11:58
i have pasted the imporant dates given by you in F2 to K2
Excelchat Expert 20/03/2018 - 11:58
do you see?
User 20/03/2018 - 11:59
yes
User 20/03/2018 - 11:59
where must i paste this?
Excelchat Expert 20/03/2018 - 11:59
you can paste it anywhere any per your requirement
Excelchat Expert 20/03/2018 - 11:59
in column D i have build the formula using those date
Excelchat Expert 20/03/2018 - 11:59
do you see
Excelchat Expert 21/03/2018 - 12:00
to get each and every date in column A into the ranges
User 21/03/2018 - 12:00
Sorry I don't think this is going to work for me
Excelchat Expert 21/03/2018 - 12:00
now when you apply pivot on top of this you will get counts of lead source in this ange
User 21/03/2018 - 12:00
I need it in a pivot table
Excelchat Expert 21/03/2018 - 12:00
why?
Excelchat Expert 21/03/2018 - 12:01
do you know how to use pivot table?
User 21/03/2018 - 12:01
oh okay I see
Excelchat Expert 21/03/2018 - 12:01
now use pivot table on this
Excelchat Expert 21/03/2018 - 12:01
it will be very easy for you now to display counts in these date ranges
Excelchat Expert 21/03/2018 - 12:01
you can also group them when you make pivot table
User 21/03/2018 - 12:02
I see, yes thankyou
Excelchat Expert 21/03/2018 - 12:02
welcome
Excelchat Expert 21/03/2018 - 12:02
do you need any more assistance?
User 21/03/2018 - 12:03
no thankyou very much
Excelchat Expert 21/03/2018 - 12:03
Do let me know of anything else is required
Excelchat Expert 21/03/2018 - 12:03
welcome
Excelchat Expert 21/03/2018 - 12:03
please do give good rating
Excelchat Expert 21/03/2018 - 12:03
it really helps

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.