thenum1roc
Board Regular
- Joined
- Jun 2, 2002
- Messages
- 77
I know for columns to rows you would put :
=INDEX($M$287:$AW$287,COLUMNS(CQ12:CQ12),1)
put when I tried to do:
=INDEX($M$287:$AW$287,ROWS(CQ12:CQ12),1)
it does not work. What do I need to do to set some rows equal to some columns.
Thanks
=INDEX($M$287:$AW$287,COLUMNS(CQ12:CQ12),1)
put when I tried to do:
=INDEX($M$287:$AW$287,ROWS(CQ12:CQ12),1)
it does not work. What do I need to do to set some rows equal to some columns.
Thanks