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
2733
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 26, 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
2733
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 26, 2021
460
Hi Kunal,

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

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!