I am having a sheet where data is in the form shown below [image] Here, Column A B C D and H I J K have same name excet difference of _1 and _2. I want the result like [image] where WR SD OP and XX are the last words in the column name and if column contains any value other than 0 then it sho…

@Swara_Soni Let’s define a dictionary with the column index and the Code like following for the first and second set: [grafik] Within a for each row we can collect the values by using the dictionaries Keys and Column Index and the dictionary values as code if value is not null and other as 0 e.g…

Find which column has values and match the case

Help

balupad14 (Balamurugan (BalaReva)) October 26, 2020, 7:39am 4

Hi @Swara_Soni,

Here is the activity called “Find” to find the value in the sheet. It will return the cell info and rowindex.

Sample :

Video Explanation :

Regards
Balamurugan.S

Topic		Replies	Views
Excel Lookup Range Studio excel , studio , lookup	5	1521	March 23, 2023
How to find dynamic Column name which contain string? Studio	5	1415	June 7, 2022
How to check for every cell if it contains a particular string in a datatable Help excel , activities	3	1726	September 4, 2020
Excel column operation Help datatable , activities , question	5	1609	January 8, 2020
Plz solovemy issues Studio studio , question , workflow_diff	9	535	May 3, 2023

Find which column has values and match the case

Related topics