excek 2013

Hi Friends, I spent few hours to findout a solution for my task. Trying to partial match first 2 or 3 words from ColumnB(B1) data with First 2 or 3 words from ColumnG(G1) If found the partial match then mark as "Yes", If not, "No". I do not need to input range like G1:G10 because the correct...

Hi All, Sub SavePDF() ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:="D:\Users\51441884\Desktop\Tracking tool\CAPA Form.pdf", _ OpenAfterPublish:=True End Sub Sub Copier() Dim x As Integer x = InputBox("Enter number of times to copy Sheet1") For numtimes = 1 To...

hi everyone, i have one excel file, i want rename several word or number with another, for example: 6037991816468777 --> jack 6037991845127846 --> john . . . how can i do it? thanks in advance.

Hi, i have huge date contain text/number/combined devises. sample data as below A B A2 21411111 A3 21412232 A4 24600221 A5 24600000 A6 2K221212 A7 2K221213 A8 2D221213 A9 2D221212 A10 71717777 A11 3458 A12 3587 I wanted to get the devises model, result should...

I have an excel 2013 spreadsheet where I need to load data into sql server 2012 for a onetime load. I am using the data-> workbook connections -> and I am required to select a table from the database that I am pointing to. Thus to me it looks like I need to have a table created in advance on sql...

Thanks for your support in advance:) I would like to know is there any possibility using IF function with MID to get result ? i am using formula is =IF(MID(A2,1,3)+0,IF(A2<=201,"TT,IF(A2<=202,"MT",IF(A2>3000,"ECT"))) Note! i have three types of ID's (starting id is from 201 & second starting...

Hi Guys, I have two vlookup formulas in two columns of a sheet which validates the value whether it is "Pass" or "fail" from another sheet of the same workbook. Here are the below 2 formulas :- 1) =IF(VLOOKUP(BY2&G2&BG2,Sheet2!A:I,9,0)>=BV2,"Pass","Fail") 2)...