Question description:
This user has given permission to use the problem statement for this
blog.
i have a list of text and i want to categorize them and count them
Solved by B. Q. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
24/01/2018 - 09:59
hello
Excelchat Expert
24/01/2018 - 09:59
Welcome to excel got it pro
Excelchat Expert
24/01/2018 - 10:00
Please tell me details
User
24/01/2018 - 10:00
so as you can see i have a list
User
24/01/2018 - 10:00
i might need to use a pivot table but what i am trying to do is create a chart that has each different value with a count of how many are in the list
Excelchat Expert
24/01/2018 - 10:00
Yes, I can see now.
Excelchat Expert
24/01/2018 - 10:02
Sorry, you want a chart or just count?
User
24/01/2018 - 10:02
a chart
User
24/01/2018 - 10:03
basically i want what i just did but for it to automatically count
Excelchat Expert
24/01/2018 - 10:03
Sorry, this was listed as a formula problem, hence I have claimed it. I don't know charts much.
User
24/01/2018 - 10:03
ooook
Excelchat Expert
24/01/2018 - 10:03
I can help with a formula though.
User
24/01/2018 - 10:04
could you give me a formula that would do this:
User
24/01/2018 - 10:04
if it says fx2day then count it
Excelchat Expert
24/01/2018 - 10:04
yes it can.
User
24/01/2018 - 10:04
awesome
User
24/01/2018 - 10:04
could you enter it in h4
User
24/01/2018 - 10:04
please
Excelchat Expert
24/01/2018 - 10:05
=countif(A:A,F4) this is the formula
User
24/01/2018 - 10:05
thank you very much
Excelchat Expert
24/01/2018 - 10:05
My pleasure.
Excelchat Expert
24/01/2018 - 10:05
anything else?
User
24/01/2018 - 10:05
is there anyway you could transfer me to someone who could help me with a chart/pivot table?
Excelchat Expert
24/01/2018 - 10:06
I can help with pivot table too.
User
24/01/2018 - 10:06
ok thank you
Excelchat Expert
24/01/2018 - 10:06
Gimme a few minutes please.
Excelchat Expert
24/01/2018 - 10:06
Have you deleted the data?
User
24/01/2018 - 10:07
I added more data
User
24/01/2018 - 10:07
so i want the first column in the pivot table to be in different rows the values in column E
Excelchat Expert
24/01/2018 - 10:08
Do you have column Headers?
User
24/01/2018 - 10:08
i can add that
Excelchat Expert
24/01/2018 - 10:08
Please do, and what about column H?
User
24/01/2018 - 10:08
so i want to categorize everything by method of shipment
User
24/01/2018 - 10:08
i meant to delete H
User
24/01/2018 - 10:08
i deleted it now
Excelchat Expert
24/01/2018 - 10:09
Thanks, a few minutes please.
User
24/01/2018 - 10:09
so basically i want the first column in the pivot to be the each of the different values of column E
User
24/01/2018 - 10:09
and then for example all of the UPS2DAIR's H columns to be added up
User
24/01/2018 - 10:09
if that makes sense
Excelchat Expert
24/01/2018 - 10:10
Yes it does.
Excelchat Expert
24/01/2018 - 10:11
Just made a pivot table on "Pivot Table 1" tab.
Excelchat Expert
24/01/2018 - 10:13
Have you seen it?
User
24/01/2018 - 10:13
yes i am looking at it
Excelchat Expert
24/01/2018 - 10:13
Okay, let me know.
User
24/01/2018 - 10:13
would the pivot table also be able to add up the values in column h
Excelchat Expert
24/01/2018 - 10:14
yeap it would.
User
24/01/2018 - 10:14
that correspond with column a of the pivot table
User
24/01/2018 - 10:15
thank you
User
24/01/2018 - 10:15
can you keep the count also
User
24/01/2018 - 10:15
please
Excelchat Expert
24/01/2018 - 10:16
There you go, it is there now.
User
24/01/2018 - 10:18
perfect
Excelchat Expert
24/01/2018 - 10:18
Please close the session now and also leave a feedback for me. :)
Excelchat Expert
24/01/2018 - 10:18
A 5 star would mean a lot.
User
24/01/2018 - 10:18
thank you
User
24/01/2018 - 10:18
you guys have the best website lol
Excelchat Expert
24/01/2018 - 10:19
Thanks for trying out excel got it pro. Have a great day.
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.
