Hi All,

For instance let us consider I have a excel sheet(Assoc_list.xlsx) which has list of associates with their employee id’s, name and other details

• The requirement is to open the first excel and group them based on location and add two rows to differentiate between different locations and sum up the credit points of same location and highlight them and save the excel as shown in the second excel (Assoc_Updated.xlsx)

Can the above functionality be acheived by using only excel connectors?? If yes can anyone explain me how to do this

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.