Excel advice

_Jimlad_

_Jimlad_

_Jimlad_

Soldato
Joined
5 Jun 2005
Posts
20,866
Location
Southampton
Hi all

I am not the greatest at excel but using one daily to track a migration at work. The first column has names of the merchants (600 rows) however I have found some are linked. So that is what I want to do, link then without changing the name or moving the position. If that makes sense.

For example the fields in row 7, 50 and 234 are the same merchant and I want to flag that to show some how but not alter the positions or names or add any more columns or rows

Any ideas?
 
Conditional formatting? Set it so "Merchant Alias 1", "Alias 2" and "Alias 3" all go to the same colour?

In newer versions of Excel, the drop down filter allows you to filter by particular colours so you could easily show just the linked ones.

Can't think of anything else without altering names or adding columns.
 
Theres a highlight duplicates option in Excel :) Does exactly what you want it to.

No need to play around with Conditional Formatting (as good as it is) then :)
 
Hi! I have been working with Google spreadsheets for about 5 years. There is a filter that changes the color, you can try to click there. I like working with them because they have many different useful features. Recently, I was transferred to a new job, and I had to learn salesforce, but I didn't understand much, and it was inconvenient to work in it. Then I went to read this article https://blog.coupler.io/salesforce-data-export/ where I saw that the entire database, absolutely everything can be moved through coupler in a Google or Excel spreadsheet. I was very happy with this news because a lot of useful data from my business was in Google spreadsheet, and so I moved everything. I advise you to read some article, maybe you will find something useful.
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom