Results 1 to 29 of 29

Difficult COUNT IF problem (sequence based on date)

Threaded View

qwertz87 Difficult COUNT IF problem... 07-06-2019, 02:31 AM
Bo_Ry Re: Difficult COUNT IF... 07-06-2019, 05:16 AM
jason.b75 Re: Difficult COUNT IF... 07-06-2019, 05:26 AM
qwertz87 Re: Difficult COUNT IF... 07-07-2019, 01:31 PM
jason.b75 Re: Difficult COUNT IF... 07-07-2019, 01:45 PM
qwertz87 Re: Difficult COUNT IF... 07-07-2019, 04:39 PM
jason.b75 Re: Difficult COUNT IF... 07-07-2019, 05:00 PM
qwertz87 Re: Difficult COUNT IF... 07-08-2019, 01:36 AM
jason.b75 Re: Difficult COUNT IF... 07-08-2019, 09:53 AM
qwertz87 Re: Difficult COUNT IF... 07-08-2019, 12:25 PM
jason.b75 Re: Difficult COUNT IF... 07-08-2019, 01:32 PM
qwertz87 Re: Difficult COUNT IF... 07-08-2019, 02:57 PM
jason.b75 Re: Difficult COUNT IF... 07-08-2019, 04:10 PM
qwertz87 Re: Difficult COUNT IF... 07-09-2019, 02:53 AM
AliGW Re: Difficult COUNT IF... 07-09-2019, 02:56 AM
qwertz87 Re: Difficult COUNT IF... 07-09-2019, 07:05 AM
AliGW Re: Difficult COUNT IF... 07-09-2019, 07:07 AM
AliGW Re: Difficult COUNT IF... 07-09-2019, 07:12 AM
jason.b75 Re: Difficult COUNT IF... 07-09-2019, 09:57 AM
qwertz87 Re: Difficult COUNT IF... 07-09-2019, 11:23 AM
jason.b75 Re: Difficult COUNT IF... 07-09-2019, 11:29 AM
qwertz87 Re: Difficult COUNT IF... 07-09-2019, 05:09 PM
qwertz87 Re: Difficult COUNT IF... 07-10-2019, 02:33 AM
AliGW Re: Difficult COUNT IF... 07-10-2019, 02:38 AM
qwertz87 Re: Difficult COUNT IF... 07-10-2019, 03:59 AM
AliGW Re: Difficult COUNT IF... 07-10-2019, 04:01 AM
qwertz87 Re: Difficult COUNT IF... 07-10-2019, 05:51 AM
jason.b75 Re: Difficult COUNT IF... 07-10-2019, 09:57 AM
qwertz87 Re: Difficult COUNT IF... 07-10-2019, 10:51 AM
  1. 07-06-2019, 05:16 AM #2
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Difficult COUNT IF problem (sequence based on date)

    Please try at B4
    =IFERROR(1/(1/LOOKUP(9^9,FREQUENCY(IF(C4:LT4="R",COLUMN(C4:LT4)),IF((C4:LT4<>"R")*(C4:LT4<>""),COLUMN(C4:LT4)))))&"d","")

    Press Ctrl+Shift+Enter and drag down
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count a sequence based on nominal input
    By qwertz87 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2019, 08:34 AM
  2. Difficult Count if or Sum if problem
    By m_carter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2019, 06:32 AM
  3. Formula to Sequence Based on Date and Name
    By blens1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2018, 04:03 AM
  4. Sum/Count based on sequence
    By ulisesap in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-29-2015, 04:03 PM
  5. Count if date is between two other dates (for entire columns of dates) - DIFFICULT
    By nholtappels in forum Excel General
    Replies: 4
    Last Post: 02-02-2012, 09:24 AM
  6. index (count? sequence?) unique dates based on values in another column
    By William Judd in forum Excel General
    Replies: 11
    Last Post: 11-05-2011, 12:34 PM
  7. a difficult date and month calculation problem
    By jolinchew in forum Excel General
    Replies: 9
    Last Post: 10-06-2011, 04:58 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1