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

Closed
Report
Posts
1
Registration date
Sunday May 19, 2013
Status
Member
Last seen
May 19, 2013
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Kunal,

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

Best regards,
Trowa