hi bryan,

thanks for your reply. unfortunately, this may not be the solution to
my problem for two reasons:

1. i have over 1000 rows, ever-burgeoning database.
2. on a daily basis the rows with "X" change. today there may be 10
such rows, tommorrow 54, day after 23. hence, i cannot 'fixate' Column
A data in the "IF" condition.

i was thinking that if i were to get a formula to get the index in
Column A (comma separated) i would use the 'Recalculate' functionality
in conjunction with it to get the current indices (viz, rows with
"X").

thanks,

mac.


--
icestationzbra
------------------------------------------------------------------------
icestationzbra's Profile: http://www.excelforum.com/member.php...fo&userid=4580
View this thread: http://www.excelforum.com/showthread...hreadid=486171