Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro needed | New Users to Excel | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to set macro security in Excel to minimum | Excel Programming | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |