Vignesh Veerasamy
Member
Modified the formula strange is when "A" is starting the series it is showing "To check" which is contradictory.
Formula : =IF(INDEX(B2:O2,LARGE(IF(B2:O2<>"",COLUMN(B$1:O$1)-COLUMN(A$1)),2))&INDEX(B2:O2,LARGE(IF(B2:O2<>"",COLUMN(B$1:O$1)-COLUMN(A$1)),1))="0-","To Check","No Check")
Reference URL : https://chandoo.org/forum/threads/value-based-check-data.48599/
Formula : =IF(INDEX(B2:O2,LARGE(IF(B2:O2<>"",COLUMN(B$1:O$1)-COLUMN(A$1)),2))&INDEX(B2:O2,LARGE(IF(B2:O2<>"",COLUMN(B$1:O$1)-COLUMN(A$1)),1))="0-","To Check","No Check")
Reference URL : https://chandoo.org/forum/threads/value-based-check-data.48599/