Update tab function

  • Thread starter Thread starter Ivone
  • Start date Start date
I

Ivone

I have the list of tasks in one sheet (All) but I would like to have the list
of the ones I mark as "yes" in column F in sheet1 in tab named "recent"
 
Hi
Try:
=IF(ROW($A2)<=COUNTIF(All!$F:$F,"?*"),INDEX(All!A:A,SMALL(IF(All!$F$1:$F$100<>"",ROW($A$1:$A$100)),ROW($A2))),"")
-- it is the array formula - press:Ctrl+Shift+Enter--

Eva
Click yes if I helped
 
Back
Top