1 :select a cell in coloumn A (0002)
2: Fix this cell
3 : search this data (0002) is present in column E . If yes move to next step 4 , if no choose another data(0016) in coloumn A and proceed step 2
4: get all the data in coloun B 000292 000224 0002F5 0002F6 AND also get all the data in...
KINDLY GIVE SINGLE FORMULA FOR THE BELOW EXAMPLES:
EXAMPLE 1)I018_002_003_S-Qualite sonore _ mauvaise quelque soit la source/000000-General/402-Diag procedure/0016
FROM THIS I NEED TO GET : I018_002_003_S/000000/402/0016
EXAMPLE 2)I000_010_018_O-"hands-free"...
hi team,
how to display with colour differentiation...."green" for present in master and "red" for Not Present in master in this formula....
Thanks and regards,
guna
I have a Master data in Coloumn A and Input data in Coloumn B.
Now, I need to search each data of Coloumn B in all the range of datas of Coloumn A(i.e Master).
If that Input Data is present in Master Data,then I need to display “Present in Master” in Coloumn C, if it is not present then I...
Dear Team,
Onbehalf of all , I am expressing my thanks to all the team members of this forum for brillant work you people doing here.
Now, i have a request to you to create a macro for my problem.
http://www.fileconvoy.com/dfl.php?id=g4a2be19f43ed25dc999245625bc7a8967ebda5473
In this in...
IF ME A FORMULA TO HAVE ONLY 6 DIGIT OUPUT DATA WHATEVER MAY BE THE GIVEN INPUT DATA :
eXAMPLE:
INPUT: OUTPUT
154689 154689
123 000123
124567875 124567
1 000001
36 000036
1548 001548
http://www.fileconvoy.com/dfl.php?id=gb550979ca0ce64159992452101f4624ee477621e6
please solve the above prob,,
data in colA after x has to be converted to 4 digit by adding "0".suppose after "x" 2 digit is present.add 2 zeros ,so that colA dat will be 4 digit. ColB has just to extracted after...
dEAR TEAM,
As per your suggestion, i have reframmed my input data to a pdf file.
there are two types of data extarct problem i attatched both types input in pdfand as well as my required data output in excel.
http://www.fileconvoy.com/dfl.php?id=ge33f09a1fc56275c9992451478194d174b0b7ebae...
Can anyone do give me favour by giving a software to cut the unwanted pages of pdf before sending. So that i will send my data in pdf after cutting the confidential data and sending only required to you hereafter:).
http://www.fileconvoy.com/dfl.php?id=g1db570a2a619b7c1999244637638331e31775d7e8
can u plesse check this zip data where there will be two file for solving my prob