Pivot tables, filters, report.
I am fascinated with excel but I really don't know what excel is capable of doing. I know pivot tables are amazing.... so, basicly. I am looking what a pivot table can do.
I have attached a file with different columns and rows. I want to be able to look at a table and see. Something like. The equipment on the 1st left side column. and then the location of where they got shipped to on the top right columns and the date that I got shipped to on the center table. and but if not possible it's ok. Something that shows it came back from wherever it got shipped to. THANK YOU.!!!!! HAVE A GOOD DA PEOPLE!
REQUESTED REQ # MTICKET CHILD TICKET TYPE MODEL S/N RECEIVED RMA P.O.# RMA# SHIP TO SHIPPED DATE OF RETURN DELIVERED TO CUSTOMER.
9/3/2015 LAX-15-98 76646 76646 RADIO HTT500 3209180 11/4/2015 9051 POWERTRUNK 11/4/2015 2/8/2016
7/24/2015 LAX-15-86 27207 74850 BATTERY BATTERY 9867470 8/11/2015 285552 8815 POWERTRUNK 8/11/2015
8/11/2015 LAX-15-89 27227 74954 BATTERY BATTERY 9867117 8/11/2015 285552 8815 POWERTRUNK 8/11/2015
12/4/2015 LAX-15-10 77836 RADIO STP8080 2PPND01334G7Y9RL 12/4/2015 287913 SEPURA 12/4/2015 1/15/2015
11/4/2015 LAX-15-99 76646 76646 RADIO HTT50 3219923 11/4/2016 9051 POWERTRUNK 11/4/2015 2/8/2016
12/23/2015 LAX-15-112 77963 RADIO STP8080 2PND01334G4Y9SH 12/23/2015 288701 SEPURA 12/23/2015 3/22/2016
11/9/2015 LAX-15-100 76835 76835 RADIO HTT50 3209154 11/9/2015 9087 POWERTRUNK 11/9/2015 2/8/2016
1/25/2016 LAX-16-01 28753 78989 RADIO STP8080 2PND01332G4YZ4Z 4/25/2016 294674 SEPURA 4/25/2016
Re: Pivot tables, filters, report.
You did not attach anything and I cannot use TextToColumns to easily parse your data.
Please ensure you mark your thread as Solved once it is. Click here
to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Adamlee in forum Excel General
Last Post: 08-31-2015, 08:11 AM
By bhenlee in forum Excel Programming / VBA / Macros
Last Post: 07-29-2015, 04:28 PM
By jackie_m in forum Excel Charting & Pivots
Last Post: 01-21-2015, 05:17 AM
By DSL1970 in forum Excel General
Last Post: 04-16-2013, 07:17 PM
By csivell in forum Excel Programming / VBA / Macros
Last Post: 08-08-2012, 02:21 PM
By ramjet in forum Excel General
Last Post: 07-12-2012, 01:45 PM
By shoesterix in forum Excel Programming / VBA / Macros
Last Post: 03-23-2011, 05:02 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1