LinkBack URL
About LinkBacks
Hi I have an excell work book contains two sheets,
sheet1-coloum "A" is dropdown coloum, which will list from coloum "A" from Sheet2.
Note: NO blank spaces should come.
any formula you have plz?
Hi I have an excell work book contains two sheets,
sheet1-coloum "A" is dropdown coloum, which will list from coloum "A" from Sheet2.
Note: NO blank spaces should come.
any formula you have plz?
Last edited by VBA Noob; 02-04-2009 at 03:39 AM.
Formula to remove blanks:
=INDEX(Sheet2!$A$1:$A$10,SMALL(IF(ISTEXT(Sheet2!$A$1:$A$10), ROW(Sheet2$A$1:$A$10),”"),ROW(1:1))) + CTRL + SHIFT + ENTER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks