Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2017, 12:35 PM
wheddingsjr wheddingsjr is offline Counting the difference in days within multiple groups Windows 7 64bit Counting the difference in days within multiple groups Office 2016
Advanced Beginner
Counting the difference in days within multiple groups
 
Join Date: Mar 2017
Posts: 58
wheddingsjr is on a distinguished road
Default Counting the difference in days within multiple groups

Hi all

I have been working on a project where I have to identify anytime a group number appears within a 5 days period within multiple groups. I have sorted the spread sheet by group# and I am ok with subracting one date from another to get the difference, however, the group numbers change. I can continue to manuallydo it the way I am but the spreadsheet has over 7,500 lines. If you look at the attachment, you will see that each time the group # changes I have manually entered in a zero in the "# Of Days" field because that starts the next group set and the first date of the set is using the last date of the previous group set which is not what I need. I tried to add to the current formula using "IF" but it doesnt work. Any assistance would be appreciated.

Thanks
Attached Files
File Type: xlsx Book1.xlsx (11.0 KB, 8 views)
Reply With Quote
  #2  
Old 03-27-2017, 02:35 PM
gebobs gebobs is offline Counting the difference in days within multiple groups Windows 7 64bit Counting the difference in days within multiple groups Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

=if(A3=A2,C3-C2,0)
Reply With Quote
  #3  
Old 03-28-2017, 07:38 AM
wheddingsjr wheddingsjr is offline Counting the difference in days within multiple groups Windows 7 64bit Counting the difference in days within multiple groups Office 2016
Advanced Beginner
Counting the difference in days within multiple groups
 
Join Date: Mar 2017
Posts: 58
wheddingsjr is on a distinguished road
Default

Thanks gebob

That worked perfectly. I must have written my "IF" formula incorrectly.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting the difference in days within multiple groups Counting multiple data in cell more than once Alaska1 Excel 3 03-01-2015 04:27 PM
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook JaxV Excel 9 11-14-2014 12:25 AM
Counting the difference in days within multiple groups Calculate difference by days and hours alysolyman Excel 6 05-13-2013 02:19 AM
Counting cells with multiple complex criteria TishyMouse Excel 12 12-06-2012 05:05 AM
Counting the difference in days within multiple groups Sum & difference between multiple values in a single cell iuliandonici Excel 4 04-13-2011 09:27 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft