Hi Guys,
i have this data, i need to do substract every 7th day value with 1st day value(in raw data page sheet,red highlight) repeatedly as in the attached file (summary page sheet). currently im using vlookup function but problem i need to do manually. Any formula, i can do for this. need your advice on this. Thanks
summary page.JPG
raw data page.JPGraw data page.JPG
Try this formula in D1 and then fill down
Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
hi mehmetcik,
thanks for your reply. I tried to fill down, but the value is difference from the lookup value. value in D1 suppose to be 26059, but using the formula i get the value 22283. Thank you.
Last edited by watabe112; 06-27-2018 at 07:28 PM.
Check your results manually, I think that you have some errors.
Formula for D3Formula:Please Login or Register to view this content.
Last edited by mehmetcik; 06-27-2018 at 07:48 PM.
hi mehmetcik..formula working..thanks a lot for your help..😁
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks