Find text and copy into new column (excelvba)
Closed
amzary
-
Oct 19, 2009 at 09:53 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 21, 2009 at 07:01 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 21, 2009 at 07:01 AM
Related:
- Find text and copy into new column (excelvba)
- Excel copy column from one sheet to another automatically - Guide
- Excel count how many times a value appears in a column ✓ - Office Software Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Sum column if another column equals ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 21, 2009 at 07:01 AM
Oct 21, 2009 at 07:01 AM
Hello
A suggestion
conditional format with several colours and check manually
or you can put this formula in cell B2
=IF(A2="channel1",1,IF(AND(B1=1,A2="channel2"),2,IF(AND(B1=2,A2="channel3"),3,0)))
and filter for number three to check the occurance of channel 1,2,3 in order
A suggestion
conditional format with several colours and check manually
or you can put this formula in cell B2
=IF(A2="channel1",1,IF(AND(B1=1,A2="channel2"),2,IF(AND(B1=2,A2="channel3"),3,0)))
and filter for number three to check the occurance of channel 1,2,3 in order
