Search results

Hi SirJB7 after a long search I was not able to find something that fit what I was trying to do.

Hi I am looking for a macro that will export my data into two new workbooks based on the information in column E (primary or secondary). Here is a sample and I included a file https://www.dropbox.com/s/af6bvmoaluikb94/7064378F.xlsx C1 4642.5 1447.28 180...

Hi NARAYANK991 I think conditional format would be the easiest way to go on this comparison after searching aroung the site. Sorry, to waste your time. Thanks

I must admit it is a little difficult to follow, so how about a simple true or false depending on whether the data is different.

That is comparing them vertically< I want to campare horizontally just across row 1. My data above did not format well, so I will include a sample file https://www.dropbox.com/s/679s32yp62d58lh/Sample.xlsx

Hi I would like to compare data in A1:B1 with the data in D1:E1 and ouput the difference in G1:H1. Here is a sample C1 C0603C101J5GACT C1 C0603C101J5GACT C10 C2012X7R1E105K C10 C2012X7R1E105K C100 C0603C104K3RAC C100 C0603C104K3RAC C101 C0603C102K5RACT C101...

Hi That just copied the first cell and then copied it down the column. What I am looking for is to sort Column A and B according to Column A. I would like to do this with a macro. Here is a sample https://www.dropbox.com/sh/67unlewr92vgm3z/XAGscYaB7G

Hi SirJB7 I get a Syntax Error

Hi the formula works great when I manually use it , but I would like to use it in a macro where it sorts column B as well. This is part of the macro Dim F As Range 'Add Formula For Each F In Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row) F.Offset(, 3).FormulaArray = _...

Thanks Hui it worked perfectly.

Hi Hui, is there any way to make column D only fill in false for same about of cells that are in column B, instead of all the way down to the end. The number of cells in Column B will very depending on my data and the macro has a problem when the False go all the way to the bottom. Thanks

Hi Hui that worked perfectly. However, is there a way to insert the formula =AND(LEN(B1)>=2,IF(ISNUMBER(1*MID(B1,2,1))=TRUE,ISNUMBER(1*MID(B1,2,1)),ISNUMBER(1*MID(B1,3,1)))) (from Luke M and Faseeh) to create the true/false column and insert it into your sort and delete macro. Thanks

Hi I am looking for a macro that will take my data, sort it (True or False) and then delete all the false results. I have supplied sample data and sample results https://www.dropbox.com/sh/67unlewr92vgm3z/XAGscYaB7G Thank You

Thanks shrivallabha it work perfectly.

Hi, I am trouble getting this array formula...

Thanks SirJB7 it works perfectly

Hi Luke M After some though I think it would be better if the macro just opened another worksheet, not another workbook. Could you help me out?

Faseeh that worked. Thank you all once again.

Luke M it worked, except for a small portion of the list. Can you look at my file? https://www.dropbox.com/sh/rhffk9zwqy0b6yw/TP-BfxVSic

Hi, Sorry the format did not show the way I intended it to, so I will link an example of my data and the results I would like. https://www.dropbox.com/sh/rhffk9zwqy0b6yw/TP-BfxVSic

Hi I would like to only delete certain cells in a column that do not match a certain format. For example I have this data 706832-02 0 REFERENCE 706831-02 1 S706831-02 0 706830-02 0 REFERENCE C0603C102K5RACT 1 C46 C0603C104K3RAC 1 C31 C0805N101K201N 3 C19,32,33 0805N221K201NXT 1 C11...

Thanks Luke M, works perfectly.

Hello, another question. Can that macro form Luke M include a way to open the new data in a new excel file with the same name as the first except with _prn at the end of it. Example: Origanl Name PL706485-02 New Name PL706485-02_prn

Sorry about the mix up with the data.

Hi SirJB7, the spaces were a result of me trying a different approach they are a contuation of the reference designators from the above cell, hence the comma at the end of the last number the data is this R6,R30,R40,R50,R52,R53,R13,R25, RMC1/16 10K .1% R35,R65,R74,R93,R104,R105...