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 huge data to do with.
file attached.
=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
With 2021 or 365:
in C5:
=TRANSPOSE(IF(FILTER(Table2[ITEM], (Table2[ID]=A5)*(Table2[Name]=B5),0),"Done",""))And please update the title of this thread so it better reflects what's expected. "Formula required" won't help those who search - Thanks
- can somebody help..?
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.
