VBA macro code need for extracting non duplicate values ?

Hi All

I need the vba macro code for extracting non duplicate values with below conditions


Column D have fixed values,
The values in D1 have to check with B1 and C1
the extracted non duplicate value should copy to F1
same as D All rows.
Image and excel attached for reference.test2.PNG
in that excel have already different function macro code adding the above condition is advantage

the above code working fine , I need one more help , let me ask you ?

Hi I need vba , hep with inserting row with prefix value with below functions

excel sheet attached or reference.Attachment 735721

I have excel with sheet1
Sheet1 have some value in column A & B
wants output in-column C (Row 1 to 6) print some text mentioned in excel redcolour
Row 7 value comes from Sheet1 A1 with prefix "pick"
Row 8 value comes form sheet1 B1 with prefix "pick"
row 9 value comes from sheet1 B1 with prefix "prepopup"
row 10 print pop Next
Row 11 value comes from Sheet1 A2 with prefix "pick"
Row 12 value comes form sheet1 B2 with prefix "pick"
row 13 value comes from sheet1 B2 with prefix "prepopup"
row 10 print pop Next

its function should repeat entire column A &B row count.

Hi

Excel file attached , information in sheet2 please do he needful.

Originally Posted by yugeshkumar

the extracted non duplicate value should copy to F1

Hi, easy with Excel basics like any Excel beginner operating manually so without looping :

PHP Code: 

Sub Demo1()
    With [A1].CurrentRegion.Columns(6)
        .Value2 = Evaluate(Replace("IF(C1:C#=D1:D#,B1:B#,C1:C#)", "#", .Rows.Count))
    End With
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄