Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 27th 19, 06:46 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2005
Posts: 8
Default Help required on a formula.

Apologies if in wrong area.


I have the following formula of which links and paste data in column B. What im trying to do is do the same formula so it takes data from BA7 to CC2 and paste in column F

=INDEX($BA$1:$CC$1,ROWS($A$6:A6))&" "&INDEX($BA$2:$CC$2,ROWS($A$6:A6))

I tried changing to whats below but it not working.

=INDEX($BA$7:$CC$2,ROWS($A$6:A6))&" "&INDEX($BA$7:$CC$2,ROWS($A$6:A6))

Any ideas what ive done wrong.

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM
FORMULA REQUIRED shaji Excel Discussion (Misc queries) 2 September 12th 06 04:05 PM
Help required on a formula Gavin[_11_] Excel Programming 2 September 4th 06 03:11 PM
Help required for formula recklaw Excel Discussion (Misc queries) 2 March 15th 06 11:11 AM
Formula help required!!! CADmanJP Excel Worksheet Functions 2 March 10th 06 03:45 AM


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017