How do I automate the following example with code:
Sample data
DX63:EX63 H,O,O,O,H,H,O,O,O,O,O,O,O,O,O,O,H,O,O,O,H,O,O,O,O, H,O
DX64:DX64 H,O,O,O,H,O,O,O,H,O,O,O,O,O,O,H,O,O,O,O,H,O,O,O,O, H,H
Result
GE63:GJ63 = 1, 5, 6, 17, 21, 26
GE64:GK64 = 1, 5, 9, 16, 21, 26, 27

Apply for each source data row within the range DX63:EX116,
and place the output for each row in the range GE63:GM116
Record the order of each “H” within the range of each row of the sourc
range

--
dkenebr

-----------------------------------------------------------------------
dkenebre's Profile: http://www.excelforum.com/member.php...info&userid=76
View this thread: http://www.excelforum.com/showthread.php?threadid=39471