Forum Discussion

LousQuinn's avatar
LousQuinn
Copper Contributor
Jun 07, 2022

Count when matching ID's equal number in seperate colum

Hello,

I’m currenty bringing data from Jotform into Excel which includes the colum headings

‘House ID’ and ‘members in household’

The ‘House ID’ is a unique mix of characters that are assigned to all connected members of the same household

The ‘Members in household’ will always be a number which will equal the total count of the 'House Id's'

 

I’m trying to find a way to achieve the following

 

Count when ‘House ID’ equals the number of ‘members in household’ 

 

To give this some context -

 

The first ‘House ID’ that enters the sheet will always have the ‘members in household’ count on the same row.

 

The other matching 'House ID's' could arrive into the sheet at different times.

 

I need a formula that  look’s for when the ‘House ID’ count matches the ‘members in household’

 

I've tried using COUNTIF function but this needs a value and as the value's change eveytime a new 'House ID' is submitted, i'm not sure how this will work.

 

The included screen shot would class as a complete

 

Thanks,

Lou

 

 

 

 

3 Replies

    • LousQuinn's avatar
      LousQuinn
      Copper Contributor
      Hi Hans, the plan is that when the household is complete, aggregate the data from each row thats included in the household and populate a document which in turn will be emailed to each member of the household. Thanks