I have a problem where I need to compare cells in a large list and find the following question below...
Question: How many times was a 0 value found before a 1 value in the list? This list is vertical(FYI) and also I will be unable to use macros, just need assistance in creating an IF formula for this.
Any help would be greatly appreciated on this!! Below is also a sample list.
0 1 0 0 0 1 0 0 1
The basic formula would be
=COUNTIFS(A1:A9,0,A2:A10,1)
with the ranges adjusted as necessary.
If there are no empty cells in the range, this would be a bit more dynamic
=COUNTIFS(A1:INDEX(A:A,COUNT(A:A)-1),0,A2:INDEX(A:A,COUNT(A:A)),1)
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments