Forum Discussion
Solved
formula required
Hi Everyone, I have data in table 2 and basis that i want to fill the column value as "Done" each time the ID is counted. Currently i have inserted Done manually but i need a formula as i have a ...
=IFERROR(IF(IFERROR(LARGE(IF(($A5=$G$5:$G$11)*($B5=$H$5:$H$11),ROW($G$5:$G$11)-4),COLUMN(A$1)),""),"Done",""),"")An alternative could be this formula if you don't work with Office 365 or Excel 2021. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 20021.
=IFERROR(IF(IFERROR(LARGE(IF(($A5=$G$5:$G$11)*($B5=$H$5:$H$11),ROW($G$5:$G$11)-4),COLUMN(A$1)),""),"Done",""),"")An alternative could be this formula if you don't work with Office 365 or Excel 2021. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 20021.
- thankyou