I can't think of any Excel-intrinsic method that would do this.
However a VBA macro could. If I was to assume that your colored cells
are the ONLY data on active worksheet, give this macro a try:
Sub ExtractNonZeroCells()
Dim db As Range
Set db = ActiveSheet.UsedRange
'First results of clear previous extraction
Columns("A").ClearContents
Dim nextRow As Long
nextRow = 8
Dim rCell As Range
For Each rCell In db.Cells
If rCell.Value <> "" And rCell.Value <> 0 Then
Cells(nextRow, 1).Value = rCell.Value
nextRow = nextRow + 1
End If
Next rCell
End Sub
Hope this helped,
Rolf Jaeger
SoarentComputing
http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm
On Nov 23, 8:08 am, Kaustubh K <kaustubh....@gmail.com> wrote:
> Hi,
>
> In the attached file the basic data is in coloured cells.
>
> What I want to achieve is that I want to list all items from the basic data
> that are not zero in column A and that too alphabetically i.e A1, then A6
> then A8 and so on.
>
> Is there any method in excel so that I can do that.
>
> Thanks
> KK
>
> PROBLEM.xlsx
> 11KViewDownload
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
