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.
Please don't be so impatient! Participants here are just other Excel users who spend some of their free time helping others. You cannot expect instantaneous answers.
How does Table1 work? Does the real version already have many, many columns?
yes real version has upto 30-31 columns i.e the no. of days in a month.