Hi, Copy data in separate sheet,
Then select all data in that coloumn, Now select blank cells, by pressing ctr + G (i.e. Goto) then select Blank Cells and Delete all Rows. Sent on my BlackBerry® from Vodafone -----Original Message----- From: Rajasekhar Praharaju <rajasekhar.prahar...@gmail.com> Sender: excel-macros@googlegroups.com Date: Mon, 13 Dec 2010 19:46:02 To: ashish koul<koul.ash...@gmail.com>; <dilipan...@gmail.com>; <excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: Fwd: $$Excel-Macros$$ Skip blank cells while copying a list Hi, Could you please help me out with an excel formula . The solution i want is like this The source column can have any entries with blanks in between : apple orange 12334 mango 5678 zcech I need to copy this data to new column skipping blanks: apple orange 12334 mango 5678 zcech I need a fomula (not macros please) and it shouldnot use row() The formula i have tried is if source data is in column A write in column C =IF(TRIM(A2)="","",ROW()) and write in column B =IF(ISERROR(SMALL(C:C,ROWS($A$2:A2))),"",INDEX(A:A ,MATCH(SMALL(C:C,ROWS($A$2:A2)),C:C,0))) Select both B and C and dropdown till the no f rows u want. This formula works very well. But the application i use (Xcelsius) doesnot support row( ) , rows( ). so i am in search of another formula. Kindly Help ........................ Please Thanks in Advance, Raj -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
