hi ,what I need is a formula in C1 which tracks the values of B1,thanks again!
hi ,what I need is a formula in C1 which tracks the values of B1,thanks again!
Please try at C3 copy down
=IF(A3="","",IFERROR(MATCH(0,--(MMULT(--(COUNTIF(OFFSET(A3,-ROW(INDIRECT("1:"&ROWS(A$1:A3)-2))+1,,-3),{1,2,3})=1),{1;1;1})=3),)-1,MAX(0,ROWS(A$1:A3)-2)))
i knew it you are the best.i wish you health and a successful career!!!
Thank you.
You didn't describe how you get C1 result on this post, no one would understand.
If you want others to be able to help you, you need to explain more on how you get C1 result.
I know this because I worked with you from the previous post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks