extract non zero valus from a list.

  • Thread starter TUNGANA KURMA RAJU
  • Start date
T

TUNGANA KURMA RAJU

I am looking for a funtion that retrives names from col (a:a) whose
corresponding values in Col(b:b) are not zero or blank.Please don't suggest
filtering,or sorting.
 
G

GTVT06

I am looking for a funtion that retrives names from col (a:a) whose
corresponding values in Col(b:b) are not zero or blank.Please don't suggest
filtering,or sorting.
Click to expand...

Not sure where you want to retrieve them to, so I wrote this code to
retrieve them to the immediate window, you can edit the code to fit
your needs. Or reply back and I can help make the adjustment.

Sub test()
Dim cell As Range
For Each cell In Range("A:A")
If cell <> "" And cell.Offset(0, 1).Value <> 0 Then
Debug.Print cell
Next cell
End Sub
 
T

TUNGANA KURMA RAJU

Retieve the names in col C:c

GTVT06 said:
Not sure where you want to retrieve them to, so I wrote this code to
retrieve them to the immediate window, you can edit the code to fit
your needs. Or reply back and I can help make the adjustment.

Sub test()
Dim cell As Range
For Each cell In Range("A:A")
If cell <> "" And cell.Offset(0, 1).Value <> 0 Then
Debug.Print cell
Next cell
End Sub
Click to expand...
 
T

TUNGANA KURMA RAJU

very long back, I came across Row,Rows function to get this results,I need a
function.
 
G

GTVT06

This will retrieve name from column C

Sub test()
Dim cell As Range
For Each cell In Range("A:A")
If cell <> "" And cell.Offset(0, 1).Value <> 0 Then
Debug.Print cell.Offset(0, 1).Value
Next cell
End Sub
 
Top