Hi Steve, thanks for your help. I was wondering if you could help me structure this formula. Still having some issues with it. This is what I have done so far. Thanks
*=if(countif(Range,Component)>1,countif(Range(which moves one by one)),"")
** What im looking for.
So far I Know:
*Count(FILTER(“table”, ([Component] =[_THISROW].[Component])))
**This will count the number of components on the table but not in sequence. Also, How can I compare the count to a number (Expression: >1)
*COUNT(FILTER(“table”,AND(([_ROWNUMBER] >= 1), ([_ROWNUMBER] <= 1), ([Component] =[_THISROW].[Component]))))
** This will count if the component is in the range 1
how can I compare both so they are executed in sequence?