Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
FORMULA REQUIRED | Excel Discussion (Misc queries) | |||
Help required on a formula | Excel Programming | |||
Help required for formula | Excel Discussion (Misc queries) | |||
Formula help required!!! | Excel Worksheet Functions |