how to auto number merged cells in a column by using excel formula and not by running macro and visual basic.
i also want to know to concatenate entries in a columns and deleting duplicates