Home

Please guide

%3CLINGO-SUB%20id%3D%22lingo-sub-1179433%22%20slang%3D%22en-US%22%3EPlease%20guide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179433%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20in%20which%20client%20list%20is%20there%20and%20it%20get%20added%20new%20client%20list%2C%20also%20i%20have%20calendar%20till%202028.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20to%20have%20results%20like%20client%20list%20and%20month%26amp%3Byear%20in%20one%20column.%20and%20in%20future%20if%20client%20get%20added%20in%20the%20list%20it%20should%20automatically%20get%20same%20results%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20guide%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1179433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181542%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20guide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181542%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367567%22%20target%3D%22_blank%22%3E%40Amardeep1001%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20date%20are%20stored%20in%20date%20format%20then%20you%20may%20use%20the%20PivotTables%20by%20grouping%20them%20by%20month%20and%20year.%20Make%20sure%20to%20convert%20you%20source%20data%20into%20Excel%20tables%20so%20whenever%20there%20is%20a%20new%20entry%20it%20populate%20as%20you%20hit%20refresh%20on%20the%20Pivot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ERegards%2C%20Faraz%20Shaikh%2C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelexciting.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.ExcelExciting.com%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181562%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20guide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181562%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20show%20me%20how%20i%20can%3F%26nbsp%3B%20i%20mean%20could%20you%20please%20share%20sample%20data%2Ffile%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a sheet in which client list is there and it get added new client list, also i have calendar till 2028. 

 

I wish to have results like client list and month&year in one column. and in future if client get added in the list it should automatically get same results

 

Please guide

2 Replies
Highlighted

Hi @Amardeep1001 

 

If you date are stored in date format then you may use the PivotTables by grouping them by month and year. Make sure to convert you source data into Excel tables so whenever there is a new entry it populate as you hit refresh on the Pivot.

 

Regards, Faraz Shaikh, MCT, MIE, MOS Master, Excel Expert 

www.ExcelExciting.com

Highlighted

@Faraz Shaikh 

 

Could you please show me how i can?  i mean could you please share sample data/file ?

 

Please