<Excel Automation> COmparing columns in Excel

Help Studio
,
1

Request to delete this post. Wrong question it was. Please delete this post. Thank you. Don’t need this right now.

2

@anjasing

Let original data in dt

  1. Use filter datatable activity on dt and give only E column which has required names and wave in filtereddt
  2. Now use a join activity on the filtereddt and dt on process chain as needed…

Then you can arrange or filter columns and write to excel

Cheers

3

Can we have some excel formula, we have preference for using Excel only for this

4

@anjasing

=IFERROR(VLOOKUP(E2,$A$2:$A$4,1,0),"")

=IFERROR(VLOOKUP(E2,$A$2:$B$4,2,0),"")

sample vlookup formula change as per you rows and columns

image
image743×337 14.2 KB

cheers