$collection_rows = get_field('collection_profiles');
                if ($collection_rows) {

                    function cmp($a, $b) {
                        if ($a->collection_profile_note == $b->collection_profile_note) {
                            return 0;
                        } else {
                            return $a->collection_profile_note < $b->collection_profile_note ? 1 : -1;
                        }
                    }
                    uasort($collection_rows, 'cmp');
                    print_r($collection_rows);

                    echo '<h2>'.__('Profiles in Collection','roots').'</h2>';
                    echo '<ul>';

                    foreach($collection_rows as $collection_row) {
                        // Extract single post value
                        $collection_profile_field = $collection_row['collection_profile'];
                        $collection_profile_page = isset($collection_profile_field[0]) ? $collection_profile_field[0]->ID : NULL;
                        ?>
                        <li><a href="<?php echo get_permalink($collection_profile_page); ?>"><?php echo get_the_title($collection_profile_page); ?></a> <?php echo $collection_row['collection_profile_note']; ?></li>
                    <?php }
                    echo '</ul>';
                }




// The above outputs:

Array
(
    [2] => Array
        (
            [collection_profile] => Array
                (
                    [0] => stdClass Object
                        (
                            [ID] => 207
                            [post_author] => 1
                            [post_date] => 2012-02-23 13:35:55
                            [post_date_gmt] => 2012-02-23 19:35:55
                            [post_content] =>
                            [post_title] => Casing Test Profile
                            [post_excerpt] =>
                            [post_status] => publish
                            [comment_status] => closed
                            [ping_status] => closed
                            [post_password] =>
                            [post_name] => casing-test-profile
                            [to_ping] =>
                            [pinged] =>
                            [post_modified] => 2012-02-23 13:35:55
                            [post_modified_gmt] => 2012-02-23 19:35:55
                            [post_content_filtered] =>
                            [post_parent] => 0
                            [guid] => http://domain.com/?post_type=moulding_profiles&#038;p=207
                            [menu_order] => 0
                            [post_type] => moulding_profiles
                            [post_mime_type] =>
                            [comment_count] => 0
                            [ancestors] => Array
                                (
                                )

                            [filter] => raw
                        )

                )

            [collection_profile_note] => 2
        )

    [1] => Array
        (
            [collection_profile] => Array
                (
                    [0] => stdClass Object
                        (
                            [ID] => 188
                            [post_author] => 1
                            [post_date] => 2012-02-17 15:24:24
                            [post_date_gmt] => 2012-02-17 21:24:24
                            [post_content] =>
                            [post_title] => Test Profile
                            [post_excerpt] =>
                            [post_status] => publish
                            [comment_status] => closed
                            [ping_status] => closed
                            [post_password] =>
                            [post_name] => test-profile
                            [to_ping] =>
                            [pinged] =>
                            [post_modified] => 2012-02-28 14:13:32
                            [post_modified_gmt] => 2012-02-28 20:13:32
                            [post_content_filtered] =>
                            [post_parent] => 0
                            [guid] => http://domain.com/?post_type=moulding_profiles&#038;p=188
                            [menu_order] => 0
                            [post_type] => moulding_profiles
                            [post_mime_type] =>
                            [comment_count] => 0
                            [ancestors] => Array
                                (
                                )

                            [filter] => raw
                        )

                )

            [collection_profile_note] => 3
        )

    [0] => Array
        (
            [collection_profile] => Array
                (
                    [0] => stdClass Object
                        (
                            [ID] => 273
                            [post_author] => 1
                            [post_date] => 2012-03-26 07:53:45
                            [post_date_gmt] => 2012-03-26 13:53:45
                            [post_content] =>
                            [post_title] => Profile 1
                            [post_excerpt] =>
                            [post_status] => publish
                            [comment_status] => closed
                            [ping_status] => closed
                            [post_password] =>
                            [post_name] => profile-1
                            [to_ping] =>
                            [pinged] =>
                            [post_modified] => 2012-04-12 08:07:35
                            [post_modified_gmt] => 2012-04-12 14:07:35
                            [post_content_filtered] =>
                            [post_parent] => 0
                            [guid] => http://domain.com/?post_type=moulding_profiles&#038;p=273
                            [menu_order] => 0
                            [post_type] => moulding_profiles
                            [post_mime_type] =>
                            [comment_count] => 0
                            [ancestors] => Array
                                (
                                )

                            [filter] => raw
                        )

                )

            [collection_profile_note] => 1
        )

)

so the actual print_r() is not outputting the arrays in order and then the foreach() statement is outputting:

    2
    3
    1

again - not in order.