Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2020, 02:46 PM
wheddingsjr wheddingsjr is offline Help with a formula Windows 7 64bit Help with a formula Office 2016
Advanced Beginner
Help with a formula
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default Help with a formula

Hi all

I have a list of codes and dates that I am trying to count depending on the group number. Within each group is a date. Each time the first group number appears I want a (.) to signify that its the first one in the group, the following lines should add up the amount of days between the previous date within the group. I hope I explained that well enough to understand. I am including an example so that you have an idea of what I am trying to accomplish. Thanks in advance for any and all assistance.
Attached Files
File Type: xlsx Example.xlsx (9.8 KB, 6 views)
Reply With Quote
  #2  
Old 07-12-2020, 09:53 PM
Purfleet Purfleet is offline Help with a formula Windows 10 Help with a formula Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

=IF(COUNTIFS($B$2:B2,B2)=1,".",A2-A1) should do the trick
Attached Files
File Type: xlsx Examplemsof_PURFLEET.xlsx (10.2 KB, 8 views)
Reply With Quote
  #3  
Old 07-12-2020, 11:52 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with a formula Windows 7 64bit Help with a formula Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

As the OP seems to be using 2016, COUNTIFS is not available.
However Purfleet's formula will work with COUNTIF instead
Reply With Quote
  #4  
Old 07-13-2020, 12:53 AM
Purfleet Purfleet is offline Help with a formula Windows 10 Help with a formula Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Countifs has been around for years? Its showing on my work PC (2016) and my old excel 2007 box
Reply With Quote
  #5  
Old 07-13-2020, 07:30 AM
wheddingsjr wheddingsjr is offline Help with a formula Windows 7 64bit Help with a formula Office 2016
Advanced Beginner
Help with a formula
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default

Thanks Purfleet, that worked perfectly!!!
Reply With Quote
  #6  
Old 07-13-2020, 09:29 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with a formula Windows 7 64bit Help with a formula Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Microsoft then has it wrong COUNTIFS function - Office Support
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Copy Row 2 Row But Next Column In Formula From Another Tab TimG Excel 3 04-16-2018 09:20 PM
Help with a formula Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Help with a formula Better formula please Haha88 Excel 2 03-01-2015 03:36 PM
Help with a formula What formula should I use? TotalONE Excel 3 11-26-2013 01:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 PM.


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