Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have the following formula set up which refers to one other sheet: =IF(ISERROR(SMALL(IF(('MANAGEMENT POLICIES & ADMIN'!$E$10:$E$128="Yes"),ROW($C$1:$C$119)),ROW()-ROW($C$1))),"",INDEX('MANAGEMENT POLICIES & ADMIN'!B$10:B$128,SMALL(IF(('MANAGEMENT POLICIES & ADMIN'!$E$10:$E$128="Yes"),ROW($C$1:$C$119)),ROW()-ROW($C$1)))) How can I add to the 'MANAGEMENT POLICIES & ADMIN'! part of the formula to work for sheets 2,3 and 4 too. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|