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
Highlighted
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
Highlighted

@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? 

Highlighted

@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)?

Highlighted

@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
Linking
Rick0302 in Excel on
1 Replies
Anyone good at custom format? Please help
Kaneszc in Excel on
1 Replies
Show Blank or Zero
I_B_C in Excel on
3 Replies
Duplicate Billing
Kay_T1060 in Excel on
1 Replies
formuale help
Gavc1 in Excel on
2 Replies
searching a sheet with a true and false function
Aaron_excel in Excel on
5 Replies