ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PLEASE HELP FIX MY FORMULA (https://www.excelbanter.com/excel-discussion-misc-queries/187553-please-help-fix-my-formula.html)

DaveAsh

PLEASE HELP FIX MY FORMULA
 
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.



All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com