Previous Topic Next Topic

Excel Macro - Selection of data from column using flag (0 or 1)

Closed
Kunal Kumar Posts 1 Registration date Sunday May 19, 2013 Status Member Last seen May 19, 2013 - May 19, 2013 at 09:17 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 21, 2013 at 11:29 AM
Hi,

In Excel, I have a column of data and corresponding flags (either 0 or 1) in another column.
I want to copy only those data which correspond to a given flag in a continuous manner in another coulumn. Please help me write an excel macro for that.

Thanks!
Kunal
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 21, 2013 at 11:29 AM
Hi Kunal,

Why don't you sort your data on the flags column?

Best regards,
Trowa
0