SOLVED

Excel Piviot Table Sort by Date (Top Date Expiring Most Recent)

%3CLINGO-SUB%20id%3D%22lingo-sub-1428139%22%20slang%3D%22en-US%22%3EExcel%20Piviot%20Table%20Sort%20by%20Date%20(Top%20Date%20Expiring%20Most%20Recent)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428139%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20wanted%20to%20figure%20out%20if%20this%20is%20possible.%20Basically%20I%20update%20a%20Certification%20client%20file.%20I%20have%20columns%20for%20employee%20names%2C%20dates%20the%20Certifications%20expire%2C%20and%20the%20company%20the%20Certificates%20are%20from.%20What%20I%20would%20like%20to%20be%20able%20to%20do%20is%20have%20the%20column%20that%20has%20the%20dates%20be%20able%20to%20be%20sorted%20by%20the%20certificate%20expiring%20the%20most%20recent%20up%20at%20the%20top%20of%20the%20column.%20The%20dates%20do%20need%20to%20continue%20to%20match%20with%20the%20horizontal%20rows%20of%20the%20employee%20name%20and%20the%20company%20when%20the%20dates%20are%20sorted%2C%20so%20I%20would%20like%20the%20rows%20to%20follow%20the%20dates%20once%20sorted.%20Is%20this%20a%20Piviot%20Table%20that%20I%20would%20need%20to%20use%3F%20Right%20now%20I%20am%20manually%20updating%20the%20list%20by%20looking%20at%20all%20of%20the%20dates%20and%20manually%20inserting%20a%20row%20to%20update%20my%20information%20when%20there%20is%20a%20new%20person%20to%20be%20added%20to%20the%20list.%20I%20would%20like%20to%20just%20be%20able%20to%20add%20the%20new%20person%20to%20the%20bottom%20of%20the%20list%20and%20then%20click%20the%20date%20column%20to%20sort%20them%20into%20their%20proper%20place.%20Is%20this%20something%20that%20can%20be%20done%20in%20Excel.%20I%20have%20provided%20a%20mock%20up%20in%20screen%20shot%20format%20to%20illustrate%20what%20I%20am%20discussing.%20Thanks%20for%20your%20time.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1428139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428158%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Piviot%20Table%20Sort%20by%20Date%20(Top%20Date%20Expiring%20Most%20Recent)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684040%22%20target%3D%22_blank%22%3E%40Snuffles00%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.google.com%2Fsearch%3Fq%3Dhow%2Bto%2Bsort%2Bin%2Bexcel%26amp%3Boq%3Dhow%2Bto%2Bsort%2Bin%2Bex%26amp%3Baqs%3Dchrome.0.0j69i57j0l6.10911j0j7%26amp%3Bsourceid%3Dchrome%26amp%3Bie%3DUTF-8%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EThat%20is%20one%20of%20the%20basic%20tasks%20in%20Excel.%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hello,

I wanted to figure out if this is possible. Basically I update a Certification client file. I have columns for employee names, dates the Certifications expire, and the company the Certificates are from. What I would like to be able to do is have the column that has the dates be able to be sorted by the certificate expiring the most recent up at the top of the column. The dates do need to continue to match with the horizontal rows of the employee name and the company when the dates are sorted, so I would like the rows to follow the dates once sorted. Is this a Piviot Table that I would need to use? Right now I am manually updating the list by looking at all of the dates and manually inserting a row to update my information when there is a new person to be added to the list. I would like to just be able to add the new person to the bottom of the list and then click the date column to sort them into their proper place. Is this something that can be done in Excel. I have provided a mock up in screen shot format to illustrate what I am discussing. Thanks for your time.
1 Reply
Highlighted