Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
I have a spread sheet that I am trying to compare item descriptions. My
column headers are DESC 400 - CDM 400- CDM HSM - DESC HSM. What i have is CDM 400 numbers that may or may not be in the CDM HSM numbers - I want to sort or filter them so it the number is not in HSM but in 400, it creates a blank. Any input will be great. -- Michele |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
It creates a blank where? Do you want cells moved to create this blank? Or
do you want some cell cleared to create this blank? HTH Otto "Michele" wrote in message ... I have a spread sheet that I am trying to compare item descriptions. My column headers are DESC 400 - CDM 400- CDM HSM - DESC HSM. What i have is CDM 400 numbers that may or may not be in the CDM HSM numbers - I want to sort or filter them so it the number is not in HSM but in 400, it creates a blank. Any input will be great. -- Michele |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
see below.
I have this: 2 columns 123456 123455 123457 123456 123458 123459 123459 123467 I want it like this: 123455 123456 123456 123457 123458 123459 123459 123467 If there is a match- i want it to be side by side, if no match - leave a blank. Thanks for you help. -- Michele "Otto Moehrbach" wrote: It creates a blank where? Do you want cells moved to create this blank? Or do you want some cell cleared to create this blank? HTH Otto "Michele" wrote in message ... I have a spread sheet that I am trying to compare item descriptions. My column headers are DESC 400 - CDM 400- CDM HSM - DESC HSM. What i have is CDM 400 numbers that may or may not be in the CDM HSM numbers - I want to sort or filter them so it the number is not in HSM but in 400, it creates a blank. Any input will be great. -- Michele |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
Michele
This little macro will do what you want. I assumed that your 2 columns are Columns A & B. I assumed that your data has headers in row 1 and the data starts in row 2. HTH Otto Sub FilterAB() Dim rColA As Range Dim rColC As Range Dim i As Range Application.ScreenUpdating = False Range("B1").EntireColumn.Insert Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp)) Set rColC = Range("C2", Range("C" & Rows.Count).End(xlUp)) For Each i In rColA If Not rColC.Find(What:=i.Value, LookAt:=xlWhole) Is Nothing Then i.Offset(, 1).Value = i.Value End If Next i Range("C1").EntireColumn.Delete Application.ScreenUpdating = True End Sub "Michele" wrote in message ... see below. I have this: 2 columns 123456 123455 123457 123456 123458 123459 123459 123467 I want it like this: 123455 123456 123456 123457 123458 123459 123459 123467 If there is a match- i want it to be side by side, if no match - leave a blank. Thanks for you help. -- Michele "Otto Moehrbach" wrote: It creates a blank where? Do you want cells moved to create this blank? Or do you want some cell cleared to create this blank? HTH Otto "Michele" wrote in message ... I have a spread sheet that I am trying to compare item descriptions. My column headers are DESC 400 - CDM 400- CDM HSM - DESC HSM. What i have is CDM 400 numbers that may or may not be in the CDM HSM numbers - I want to sort or filter them so it the number is not in HSM but in 400, it creates a blank. Any input will be great. -- Michele |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
Your assumptions are correct, however I know nothing about "macro". How do I
run this?? -- Michele "Otto Moehrbach" wrote: Michele This little macro will do what you want. I assumed that your 2 columns are Columns A & B. I assumed that your data has headers in row 1 and the data starts in row 2. HTH Otto Sub FilterAB() Dim rColA As Range Dim rColC As Range Dim i As Range Application.ScreenUpdating = False Range("B1").EntireColumn.Insert Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp)) Set rColC = Range("C2", Range("C" & Rows.Count).End(xlUp)) For Each i In rColA If Not rColC.Find(What:=i.Value, LookAt:=xlWhole) Is Nothing Then i.Offset(, 1).Value = i.Value End If Next i Range("C1").EntireColumn.Delete Application.ScreenUpdating = True End Sub "Michele" wrote in message ... see below. I have this: 2 columns 123456 123455 123457 123456 123458 123459 123459 123467 I want it like this: 123455 123456 123456 123457 123458 123459 123459 123467 If there is a match- i want it to be side by side, if no match - leave a blank. Thanks for you help. -- Michele "Otto Moehrbach" wrote: It creates a blank where? Do you want cells moved to create this blank? Or do you want some cell cleared to create this blank? HTH Otto "Michele" wrote in message ... I have a spread sheet that I am trying to compare item descriptions. My column headers are DESC 400 - CDM 400- CDM HSM - DESC HSM. What i have is CDM 400 numbers that may or may not be in the CDM HSM numbers - I want to sort or filter them so it the number is not in HSM but in 400, it creates a blank. Any input will be great. -- Michele |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting data to put "0's" last | Excel Discussion (Misc queries) | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
sorting data with ; | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Sorting Data | Excel Discussion (Misc queries) |