|
Posted to microsoft.public.excel.newusers
|
|
|
customised sheet from master sheet
thank you Max
"Max" wrote:
For copying down purposes, D24 and F24 needs to be fixed (with $ signs) in
the indicative criteria expression:
=IF(AND(x!$A2="America",x!$BY2=D$24,x!$BY2<=F$24) ,ROWS($1:1),"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
|