Home

Excel Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-656574%22%20slang%3D%22en-US%22%3EExcel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656574%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20little%20problem%20with%20listing%20data%20from%20a%20database.%3C%2FP%3E%3CP%3EI%20need%20to%20sort%20data%20by%20weeks%2C%20but%20i%20have%20dates%20so%20i%20said%20to%20Excel%20which%20date%20belongs%20to%20monthweek%20no.1%2C2%2C3..%20you%20get%20the%20point.%3C%2FP%3E%3CP%3EThen%20with%20that%2C%20i%20would%20like%20to%20list%20the%20data%20which%20are%20in%20the%20same%20week%20category(it%20has%20multiple%20columns%2C%20that's%20why%20i%20think%20it's%20difficult.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-656574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edata%20sorting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20validation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Elist%20data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-656637%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656637%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351483%22%20target%3D%22_blank%22%3E%40Norbijo%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20use%20WEEKNUM()%20or%20ISOWEEKNUM()%20to%20find%20on%20which%20week%20of%20the%20year%20the%20date%20is.%20Or%20you'd%20like%20to%20count%20weeks%20within%20each%20month%20separately%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-656798%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656798%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bi%20did%20that%20part%2C%20i%20figured%20it%20out.%20Now%20i%20have%20the%20weeknumbers%20for%20each%20month%20(1%20to%205%2C%20because%20i%20month%20has%20a%20max.%20of%205%20week)%2C%20my%20question%20is%2C%20if%20a%20select%20a%20week(such%20as%20week%20No.01)%2C%20how%20to%20list%20all%20of%20the%20data%20that%20fits%20into%20that%20category(because%20i%20have%20personal%20data%20and%20each%20of%20them%20has%20a%20date)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-657126%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-657126%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351483%22%20target%3D%22_blank%22%3E%40Norbijo%3C%2FA%3E%26nbsp%3B%2C%20other%20words%20select%20all%20data%20from%20the%20range%20or%20table%20for%20the%20concrete%20week%20and%20copy%20them%20into%20another%20place%20within%20workbook%2C%20correct%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20Power%20Query%2C%20could%20be%20formulas%2C%20depends%20on%20how%20your%20data%20is%20structured.%20Better%20discuss%20that%20with%20sample%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Norbijo
New Contributor

Hi,

 

I have a little problem with listing data from a database.

I need to sort data by weeks, but i have dates so i said to Excel which date belongs to monthweek no.1,2,3.. you get the point.

Then with that, i would like to list the data which are in the same week category(it has multiple columns, that's why i think it's difficult.)

 

Thank you for help.

3 Replies

@Norbijo , you may use WEEKNUM() or ISOWEEKNUM() to find on which week of the year the date is. Or you'd like to count weeks within each month separately? 

@Sergei Baklan i did that part, i figured it out. Now i have the weeknumbers for each month (1 to 5, because i month has a max. of 5 week), my question is, if a select a week(such as week No.01), how to list all of the data that fits into that category(because i have personal data and each of them has a date)?

@Norbijo , other words select all data from the range or table for the concrete week and copy them into another place within workbook, correct?

 

That could be Power Query, could be formulas, depends on how your data is structured. Better discuss that with sample file.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies