macro is needed
 

i have 2 columns
1) Company names
2) Dividend Per share

if the company did not pay dividend the cell is empty

the question is
i want to find out which companies paid out dividend

thanks in advance


+-------------------------------------------------------------------+
|Filename: question.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4526 |
+-------------------------------------------------------------------+

--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=526646

macro is needed
 

if the company pays out dividend
it will put name in another column in another sheet
but there will be no blanks


--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=526646

macro is needed
 

Select a number of cells to accommodate all possible values on the other
sheet, and in the formula bar enter

=IF(ISERROR(SMALL(IF(Sheet1!$B$1:$B$20<"",ROW(She et1!$A1:$A20),""),ROW(Shee
t1!$A1:$A20))),"",
INDEX(Sheet1!$A$1:$A$20,SMALL(IF(Sheet1!$B1:$B20< "",ROW(Sheet1!$A1:$A20),""
),ROW(Sheet1!$A1:$A20))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"barkiny" wrote in
message ...

if the company pays out dividend
it will put name in another column in another sheet
but there will be no blanks


--
barkiny
------------------------------------------------------------------------
barkiny's Profile:
http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=526646