Friends...need a help..I have a worksheet in which data is compiled but it is alternate rows i.e alternate rows are blank..my requirement to compile data in adjecent rows i.e. blank rows is to be deleted
Thanks
7 Replies
ranjeet
(student)
(20 Points)
Replied 07 June 2008
Use Auto filter, then select blanck cells and delete them. you will get desired result.
Krishna Rao
(Service)
(31 Points)
Replied 07 June 2008
in case if one column is having a serial number / date etc. in ascending / descending order. you can sort the entire data and all blank rows will go down.
CA. Nitin Agrawal
(Chartered Accountants)
(1066 Points)
Replied 07 June 2008
Mr Rohit
Solution suggest by Mr. Ranjjet will not be helpful in case of ROW BALNK CELL REMOVAL
If u done this the data in other row will also deleted
The best way to sove the problem is to use the logical function "IF"
Ask for further enquiry
Regards
Nitin Agrawal
cell: 9893791917
email:nagrawal.raipur @ gmail.com
Neha L. Jain
(PCC student)
(90 Points)
Replied 09 June 2008
I think u should use Autofilter option & then select the "blanks" and delete the entire rows. U can then Copy the compiled data as required in a new worksheet by selecting paste special, values. I think this would solve your purpose. Try It !
Rohit Bhalotia
(CA)
(52 Points)
Replied 10 June 2008
dear friends.. Thanks 4 writing. filter option won't work as in filter fuction, if a row is complete blank then it won't take next row data.. so in this way blank rows cant be deleted
guru santhanam
(Chartered Accountant)
(97 Points)
Replied 10 June 2008
Hi Rohit,
Excel will select the blank rows also provided you select all the rows (including blank rows) till the end and then put auto filter.
I suggest u select entire column (eg: A to D) and then try auto filter.....then even if A column contains blank rows...it ll get selected.....
Sorting, Autofilter are the best ways to remove blank rows.
Regards,
gurusanthanam
Recent Topics
- Avoiding tax audit in case of intraday equity loss
- Form 3CEAB
- Form 3CEAA and Form 3CEAB
- DIR 3 Web KYC
- Can i declare LTCG income as business income if I
- Stock entry in new software
- I have an EMI collection shop, what is its SAC cod
- Making payment once in quarter possible under QRMP
- Master File Documentation related
- Applicability of 44AD needs clarification
Related Threads
CAclubindia
