LinkBack URL
About LinkBacks
hi, i know stupid question.
but i need help with this.
i want fix column A but not number, and a want apply it for a row. like
$A39 $A40 ....
i can do it for a column, but not for a row. any help??
hi, i know stupid question.
but i need help with this.
i want fix column A but not number, and a want apply it for a row. like
$A39 $A40 ....
i can do it for a column, but not for a row. any help??
A$39
the $ before a letter of number "locks" that value
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
i want do this:
copy and paste the below In any cell of column-A
=ADDRESS(38+COLUMN(A1),1,4,1)
Drag it right
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
hmm, thanks Sixthsense... but it doesnt work.. i dont know why. i am just trying it on new excel.
A B C D
1 x
2 y
3 z
i do this =address(1,1,2,true,"Sheet1), but excel said: formula contain an error
Could you please describe it a bit more for my better understanding or attach a sample workbook with expected output will be helpful.
I have column e.g. A and there are values A1=a A2=b A3=c. What i need is to take these values and copy it to row.
Sheet1: A1=a A2=b A3=c
Sheet2: C1='Sheet1'!$A1, and than i want drag it to right for automatically add other data from sheet1
In C1 cell of sheet2
Formula:
Please Login or Register to view this content.
Drag it right
or
in C1
the a15 can be changed to whatever your last cell is. then drag right.
Please Login or Register to view this content.
this would be better as it doesn't use indirect (which is volatile)
or
in C1
the a15 can be changed to whatever your last cell is. then drag right.Please Login or Register to view this content.
this would be better as it doesn't use indirect (which is volatile)
=INDEX(Sheet1!$A$1:$A$15,COLUMN(Sheet2!A$1)) works, but i changed , with ;
thx
p.s.: how can i mark it SOLVED?
thread tools at the top of the page.
what means COLUMN(Sheet2!A$1) ???
this returns the number of the column in the brackets (a=1 b=2 c=3) etc. so when you drag it this is used to index the next row in your original list
cool, now i understand. thx u so much for your help. very good job!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks