Matching and Consolidating Common Entries

Hi,

I have list with data within 2 columns, the first is a list of applications, the second identifies what type of applicaitons it is, as shown below:

Application Name, Type
App A, A
App B, Non A
App A, A
App C, Non A
App B, Non A

What I need to do is, put a formula together so the end result is as follows:

For A:

Application Name
App A

For Non A:

Application Name
App B
App C

Thanks in advance to any one who can help.

Calli

I think i understand what you mean, maysomething like this

Please Login or Register  to view this content.

I have attached a workbook so you can see

Thanks

DJ

Hi, Calli
This is not a formula but the result is probably better.
Paste the code into an Mt Macro or Command Bar
If you don't know how to do this call Back.
At the moment the code provides two distinct lists "App A" and "App NonA" in Columns "C" and "D" and assumes your Data is in columns "A" and "B".
See if its does what you want

Please Login or Register  to view this content.

Regards Mick

DJ,

The spreadsheet that you gave me is similar to what I have in the data table

Application Name, Type
App A, A
App B, Non A
App A, A
App C, Non A
App B, Non A

However, I need to separate the application by "TYPE" so that the applications that are A and NON A are not intermixed.

Mick,

I don't know how to do what you suggested, can you guide me through it.

Thanks again everyone.

Calli

Hi Calli

Inserting a Command Button in worksheet and Allocating Code

Open your workbook at the Sheet Number with your Data that you want to Manipulate.
Click View, Tools, Control Box,---- Control Box Menu Appears on sheet.
Slide you cursor over the Tool Box until you find a Command Button.
Click It then click Somewhere on the sheet.-- Command Button appears on sheet.
The Command Button will have handles round its edge, This is so you can Position it on the sheet.
Click the command Button "Hold the Mouse Click Down" and Drag the Command Button to where you want it.
Double Click the Command Button, The VB Editor window will appear.
You can also open the Editor By clicking Alt + F11, but if you double click the Command Bar the editor will open in the procedure relating specifically to your Command Bar.
If the VB Editor window has two panes the right pane is where you must paste your code.
The left pane can be "Project Window" or "Properties Window, Click "Ctrl+R" if not showing.
Paste your code just under the words "Private Sub CommandButton1_Click() " in the Right hand pane.
If you have done this correctly. Scroll to the bottom of the code and you should see the words "End Sub"
To ensure you code is Running, Paste the bit of code below into your Code ,between the lines "Next cl" And "End Sub"
On the VB Toolbar you will see a Green Triangular shapes icon,.
This is to change the VB Editor mode from "Run Mode" to "Design Mode "
Click this Icon, The Small blue square to its left will change from light blue to dark blue, or Vice Versa. Before you close the Editor make sure this Square is "Dark Blue" i.e. (Reset)
Close the Editor. Select the Command Button and Click it.
When the code Runs the Msgbox should appear With The Message " "Transfer Complete" ,if this doesn't happen Open The VB Editor "Alt + F11" and click the "Reset ( Blue Square) and or The "Green Triangle" on the Tool bar . The Blue Square should be "Dark Blue ", in order to run the code..
NB:- If you want to get back into this specific code through the Command Button.
Get the Control Box menu back on the screen, Click the green triangle, When you slide the cursor over your Command button , The cursor shape will change to a "Arrow Headed Cross" , you will then be able to double click it to view your code.
If you prefer, you can forgo all this hassle by putting the code in an MT macro, with a key combination (Like Ctrl+"A") to run it.
Don't be daunted by all this, when you get the hang of it, it will seem quite simple

Please Login or Register  to view this content.

Any problems call back.
Regards Mick