Search results for query: *

I have a huge excel spreadsheet Number description code date 1234 Test1 A 12/31/1998 1234 Test2 B 04/13/2020 7890 Test3 C 05/06/1999 4567 Test4 D 01/03/1999 4567 Test5 E 09/03/2020 4567 Test6 F 06/07/2020 What I want is that if...

I have an excel spreadsheet as follows 123456 abc def 123456. Xyz Mano 7890 Tyu iOS 7890. Min opu 7890 Ire xyz 6789. Abc 5678. Mano So i need a script which will do the following Should check the first column and if the numbers are repeated the remaining two columns should be...

I am new to autosys and I have multiple files comming in for example File1 File 2 File3 I want a file watcher which will watch for these files one by one and then call another job. Can I pass the file names to the other job one by one as that will be used as a variable. This is running on windows

How can I use a dos scripting to check for files with current date I get 4 files daily File1_yyyymmdd file2_yyyymmdd file3_yyyymmdd file4_yyyymmdd

I need a window script which will check if I have 4 files existing in a folder with current date. The file naming convention are File1_yyyymmdd.csv File2_yyyymmdd.csv file3_yyyymmdd.csv File4_yyyymmdd.csv

I am trying a simple Index and Match and it seems not to work. I cannot use a vlookup as the format on the columns are different. ColumnA ColumnB A C B E C A D B i want a simple INDEX MAtch formula which will lookup column A and see if it is in...

I have two spreadsheet Spreadsheet A Location City 3789 DALE 45678 AUSTIN Spreadsheet B Description Number 123 DALE SHORT XYTSYSYS CITY OF AUSTIN AJAKSJSK I want to look for CITY in spreadsheet A to match from Spreadsheet B and retrun the value from Number...

I have about 10 columns and 300 rows which has formulas . I want to get the output of the formulas only into Notepad. Doing a cut paste is causing error to he fact that sometimes i miss data. Is there a easy way to do it . I am not conversant with macro

I have an excel spreadsheet which is like this: ABC XYX The above mention is all in one single cell . How can i parse this and seperate them out into multiple cell.

I have 2 spreadsheets ( sheet 1 and Sheet 2). I wrote a macro which compares the data between two sheets and highights the difference . The macro is given below which works , but the issue is that the columns in sheet2 is changing for ex: In Sheet 1 Name Zipcode email In sheet 2...

I have 2 huge excel spreadsheet sheet 1 and sheet 2 I need to compare columnA in Sheet2 with Column A in sheet1 and if a match is found i need to copy the entire row from Sheet1 to sheet3. I am not used to macro but i guess that will do it. Any help is appreciated

I have a huge file ( Excel) around 40,000 rows and the data in column A will get repeated only twice and for those duplicate values in column A i need to compare each values for that respective columns. For example ColumnA ColumnB ColumnC 123 ABC MNY 123 XYZ MNY...

I have a CSV file and i need to validate the column length for various fields for example 1;2013;ABC ; How can i check that column 1 has length of 1 and column 2 has a length of 4 and column 3 has a length of 16 . I can also get this same file in text format where each data is seperated...

In excel i have a bunch of data as follows 3456.89 788888.90 The total length of the field is 13 and the (.) gets replaced by (,) i want to do it as follows 0000003456,89 0000788888,90 Any easy way to write a formula

Worksheet 1 data is as follows Column1 Column2 Column3 1 ABC XYZ 2 ABC DEF 3 DEF LMO 4 LMO ABC In Worksheet 2 data is as follows 1 2 3 4 How can i get data as follows by comparing sheet 1 and Sheet 2: ABC...

I have an 2 excel worksheet as follows : Worksheet 1 has only one column with rows as follows( This is the master worksheet): 1 2 3 4 5 Worksheet 2 has two columns as follows: ColumnA ColumnB 1 XYZ 2 ABC 1 MEJ 1. How can i compare column A with...

I have 2 speradsheet ( A and B) In spreadsheet A i have 2 columns ColumnA ColumnB Name1 YYYYMMDD Name2 YYYYMMDD Name3 YYYYMMDD In spreadsheet b I have 2 columns ColumnA ColumnB Name1 </XML/jobdate=YYYYMMDD Name2 </XML/jobdate=YYYYMMDD I need to find a match for Names...

I have an excel speradsheet having two columns and i would need to create txt files from these wherein the text file names should come from cell A1 and the data within that text file should come from cell b1. These files should be created in C:\jobs ( local directory) Example Column A...

I'm looking to create a .txt file for each value in column A containing the corresponding values in columns B

In an excel spreadsheet(1) have 2 columns A and B Column A has dates and column B has names like this Column A Column B 20130102 City 20120811 Country In Spreadsheet (2) i have 2 columns Column A Column B Date=19990102 City Date=19980810 Country...