Need help to find a formula that will give me the weekly results from a range and pull the starting and ending dates for each week and then list it in a new table.
The table on the right is just text i filled in for what I wanted it to look like as an example. I need the Week numbers and the start and end date of each week to populate the table.
Any help or suggestions will be greatly appreciated. 1RecordsLogTest.xlsx
weeklychange.png
1RecordsLogTest.xlsx
Last edited by natenate88; 02-10-2015 at 11:22 PM.
looks like you just need the formula to put in column N?
how about:
Formula:
Please Login or Register to view this content.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Well the table on the right is just text i filled in for what I wanted it to look like. I need the Week numbers and the start and end date of each week to populate the table.
If I've interpreted correctly put this array formula in L7 fill down and right to N11.To array enter press and hold Ctrl + Shift as you hit Enter. Then fill down and across.Formula:Please Login or Register to view this content.
Typo in my formula in post #4. Should beFormula:Please Login or Register to view this content.
The formula looks promising but the problem is I also need the week numbers to populate in column K. The daily records all correspond to the week numbers, so you can see they're grouped by 7 dates. I attached the excel file, if you can get a better look. Thanks for the input. If you can let me know if you can work something out. Thanks again
I would like the formula to group the dates by the week number (as long as there is one day in that week, and populate the other Table, as weeks.
I just need the week number and start/end week dates to populate the table.
Last edited by natenate88; 02-11-2015 at 02:48 AM.
still haven't been able to find a way. anyone?
I've relooked at your file, and I don't see anything differently than I did initially.
I don't understand. I thought my formula did the things you asked......the week numbers in column K being the criteria for looking up the dates etc. Here is your file with my formula in context with an additional formula in column K that identifies and isolates the unique week numbers.Formula:Please Login or Register to view this content.
If this still isn't doing what you want can you clarify further?
Last edited by FlameRetired; 02-11-2015 at 04:52 PM.
It opened fine but if I clicked to see the formula and pressed enter again it would return 1/0/1900 for the dates and wrong values for the weight change. The week number return is perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks