Thread: Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
Just to be clear...

1) Can you provide a sample of the values for the first row in
'Results'?

2) Can you provide a sample of the value/criteria contained in A4?

3) Can you confirm whether Column A and 'Results' are formatted as
'Text' or 'General'?

In article <580f590cc0896@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,

Thank you for reply. I'm receiving #Value error - not sure Why?

Cheers
Sam
Reply With QuoteReply With Quote