Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-28-2019, 04:03 PM
Alaska1 Alaska1 is offline Count if statement Windows 7 64bit Count if statement Office 2007
Advanced Beginner
Count if statement
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default Count if statement

I need to get the minimum date for the customer id in the attached file a


and tag it as the a number on in the file in the file. Can I use a count if statement?
Attached Files
File Type: xlsx Book1.xlsx (8.3 KB, 10 views)
Reply With Quote
  #2  
Old 10-28-2019, 04:53 PM
Alansidman's Avatar
Alansidman Alansidman is offline Count if statement Windows 10 Count if statement Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

In C2 type =INDEX($A$2:$A$7,MATCH(B2,$B$2:$B$7,0),MATCH(MIN($ A$2:$A$7),$A$2:$A$7,0)) and copy down.
Reply With Quote
  #3  
Old 10-29-2019, 03:17 AM
Alaska1 Alaska1 is offline Count if statement Windows 7 64bit Count if statement Office 2007
Advanced Beginner
Count if statement
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you for your response. Not sure what happen to my question below. I need to put the number one in the minimum date for that customer id.

example
4/3/2019 23456 1
6/1/2019 23456 0
9/1/2019 23456 0
4/20/2018 34567 1
10/1/2018 34567 0
5/3/2019 34567 0
Reply With Quote
  #4  
Old 10-30-2019, 03:44 AM
p45cal's Avatar
p45cal p45cal is online now Count if statement Windows 10 Count if statement Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

C2:
=IF(MINIFS($A$2:$A$7,$B$2:$B$7,B2)=A2,1,0)
copied down.
Reply With Quote
  #5  
Old 10-30-2019, 03:56 AM
Alaska1 Alaska1 is offline Count if statement Windows 7 64bit Count if statement Office 2007
Advanced Beginner
Count if statement
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you for you help.
Reply With Quote
  #6  
Old 10-31-2019, 12:14 AM
ArviLaanemets ArviLaanemets is offline Count if statement Windows 8 Count if statement Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Another way (you can hide column CustRow on sheet Data).

In case there may be several entries for same customer at same date, the formula will not work!
Attached Files
File Type: xlsx ExampleOccurrences.xlsx (13.0 KB, 5 views)
Reply With Quote
  #7  
Old 10-31-2019, 03:17 AM
Alaska1 Alaska1 is offline Count if statement Windows 7 64bit Count if statement Office 2007
Advanced Beginner
Count if statement
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you for all your help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a Select statement in Excel to an update statement shabbaranks Excel Programming 5 10-31-2018 11:47 PM
Count if statement IF statement mrry475 Excel 1 09-06-2016 09:30 AM
Count if statement Getting the Count formula to count all rows Jennifer Murphy Word Tables 11 08-23-2016 09:37 PM
Count if statement Count if statement Alaska1 Excel 7 05-30-2014 08:57 AM
Count if statement if statement piper7971 PowerPoint 1 08-19-2010 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 AM.


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