Forum Discussion

aayushmanmishra's avatar
aayushmanmishra
Copper Contributor
Dec 31, 2022
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 ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Dec 31, 2022

    aayushmanmishra 

    =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.

     

Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 31, 2022

Hi aayushmanmishra 

 

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

Resources