LinkBack URL
About LinkBacks
this is the array
{=INDEX(A$2:A$6,MATCH(SMALL($B$2:$B$6+ROW($B$2:$B$6)/10^10,ROWS(A$11:A11)),$B$2:$B$6+ROW($B$2:$B$6)/10^10,0))}
my question is the symbol of { } will disappear when will click in another cell
so have any formula to replace it.
this is the array
{=INDEX(A$2:A$6,MATCH(SMALL($B$2:$B$6+ROW($B$2:$B$6)/10^10,ROWS(A$11:A11)),$B$2:$B$6+ROW($B$2:$B$6)/10^10,0))}
my question is the symbol of { } will disappear when will click in another cell
so have any formula to replace it.
Your workbook seems to be working fine as long as you confirm the formula with Ctrl+Shift+Entermy question is the symbol of { } will disappear when will click in another cell
Life's a spreadsheet, Excel!
Say thanks, Click *
Originally Posted by Ace_XL
ok....i try to lock the cell....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks