Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BobbyCochran
 
Posts: n/a
Default Macros for find and replace and then joining columns

I have a large dataset where I need to do a find and replace for every group
of 3 columns. Each column as either a 1 or 0. I need to change all the "1s"
in N columns to "1", the "1s" in N+1 columns to "2", and the "1s" in N+2
columns to "3".

Then I need to merge each group of 3 columns into one column, preserving the
data. Any ideas?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"