Thread: Count if statement
View Single Post
 
Old 10-31-2019, 12:14 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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, 7 views)
Reply With Quote