| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update tab function
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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update tab function
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)),R OW($A2))),"") -- it is the array formula - press:Ctrl+Shift+Enter-- Eva Click yes if I helped "Ivone" wrote: 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" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update tab function
Thank you it really works!!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| now function not to update | Excel Discussion (Misc queries) | |||
| now function not to update | Excel Discussion (Misc queries) | |||
| Don't Update Function | Excel Discussion (Misc queries) | |||
| function update | Excel Worksheet Functions | |||
| Function Update | Excel Worksheet Functions | |||
Hybrid Mode
