Recent content by leader2k

Thanks a lot,i appreciate the help i will try it today and let you know. My regards

Hi i have a sheet with 6 columns (A1:F3000) when i hit a command button it copy 50 rows randomly ,but i end up having duplicate rows.i use the code bellow . [/Private Sub CommandButton1_Click() Dim rndRow As Long, i As Integer Rows(1).Copy Sheets("Sheet2").Range("A1") For i =...

Hi No i have a sheet with 6 columns of data and i want to randomly choose some rows and copy them to another sheet . My regards

Hi How to copy random rows without duplicates from one sheet to another in vba? your help will be appreciated

Hi p45cal And on my way it did, you’re absolutely on the money, I couldn’t thank you enough, I’ll make a donation as a gesture of appreciation, of the good work. My regards

Hi p45cal Thanx a lot for the smart reply, it’s immensely appreciated, if not much to ask ,is it possible to simply loop Q1:V1 row through A:F range and if it match 4,5 or 6 to delete the entire row from the A:F range, and go to Q2:V2 and do the same(loop through A:F range if it match 4,5 or 6...

Vba filter Here is a sample ,I use for filtering one combination at time , using the sumproduct/countif function, and I do the filtering manually as it’s shown on my sample,it’s time consuming when you have hundreds of thousands of rows, I will appreciate, if a gentleman/women could provide me...

Thanx anyway My regards

First of all I thank you very kindley for the help,it’s appreciated,but the solution it’s coming short of what I want ,which consist of running each row from table 2 against each row from table 1 and display the the rows that containing 4 matching numbers and up. I can use the function...

Hi Order doesn't matter ,each row from database No2 compaired against database No1 and highlight rows that contain at least 4 matches out of 6. very appreciatif of the help. My regards

Hi i have a worksheet with database No:1 A1 to F100000 (A1,B1,C1,D1,E1,F1 TO A100000,B100000,C100000,D100000,E100000,F100000) and i have database No:2(H1,I1,J1,K1,L1,M1TO H3000,I3000,J3000,K3000,L3000,M3000)so i want to loop through database1 against database2 and show rows that match 4,5 or 6...

How to filter rows of numbers 6 cells,and show only rows containing 4_5_6 matching numbers? i 'm compairing 3000 rows list against 100000 rows list. Assistance will be immensly appreciated.

Thanks NARAYANK991 for the reply ,but your formulas(array) gave me the same result as the one already using' =SUMPRODUCT(COUNTIF($H$2:$M$2,A3:F3))' i need the matches 3 and above showing not the 0-1-2 showing. My regards.

Hi sorry about the confusion and i appreciat your patience here is a link to the sample,if you look at the output i don't need the 0-1-2 matches i need it to display when it maches 3-4-5-6 (VBA if possible) thanks hopefully this time i've been more to the point. My regards...

Sorry Hui discard the previous post it was a formating mishab my project is a lottery like so when verifying the draw i need only the matching 3-4-5-6 numbers to show in the output column. thanks .