Forum Discussion
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
Where do you want the output and in what form?