A
A Good Friend
Dear friends
i have two sheets in one work book
Sheet1
A b
green -1
red 0
blue 1
Yellow 2
Sheet 2
i want to apply a farmula in which i want if (Sheet1 b ) contain 0 of less
value then colour Name (in A) comes out in columen A of sheet2 else colour
name comes in B of Sheet2
out PUT should be like
A b
green
red
blue
Yellow
i have two sheets in one work book
Sheet1
A b
green -1
red 0
blue 1
Yellow 2
Sheet 2
i want to apply a farmula in which i want if (Sheet1 b ) contain 0 of less
value then colour Name (in A) comes out in columen A of sheet2 else colour
name comes in B of Sheet2
out PUT should be like
A b
green
red
blue
Yellow