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.