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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
May 21, 2013 at 11:29 AM
Hi Kunal,

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

Best regards,
Trowa
0