ROW Formula

[EH003268]

Does anyone know how i can change this formula so that i can just dra
it down. I have
=IF(ISERROR(INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(1:1)),ROW(15:15),1)),
",INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(1:1)),ROW(15:15),1))
And when i drag down i want
=IF(ISERROR(INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(2:2)),ROW(15:15),1)),
",INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(2:2)),ROW(15:15),1))

I want the Red (15:15) to remain unchanged.
Thank

 

[OverAC]

Does anyone know how i can change this formula so that i can just drag
it down. I have
=IF(ISERROR(INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(1:1)),ROW(15:15),1)),"
",INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(1:1)),ROW(15:15),1))
And when i drag down i want
=IF(ISERROR(INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(2:2)),ROW(15:15),1)),"
",INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(2:2)),ROW(15:15),1))

I want the Red (15:15) to remain unchanged.
Thanks

Row(15:15) = 15,
If you dont want it change while dragging why don't you just edit it as
15.
OverAC

 

[Peo Sjobom]

Please, post only in one newsgroup

http://www.cpearson.com/excel/newposte.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[EH003268]

I have a lot of columns (and rows)