Dear Sir / Mam
In my excel sheet1, column B:H has mixed values like "TRUE" and "FALSE", I take the meaning from down line to continues till the top if the last one has "TRUE" then "TRUE" How many values should be counted, if the last one is "FALSE" then how many "FALSE" values should be counted till the top, for that a formula is needed.
COUNT TRUE FALSE.JPG
also attached workbook.
Pls help me.
Thank you in Advance.
Bookmarks