How to get Function names?

Need help withmacro/function

• I need to create a macro or some kind of formula to compare two differentbooks. My knowledge in this area is less. I have a long list of servers arranged in a column cell by cell. This format can be kept fixed. for ex. the names can be abc2wct01, abc2wct02 etc and so on I usually get lots of other spreadsheets with 100's of such names. most of the names are not useful for me. It takes lot of time going through the list and find out if our server name is on that list or not. So I want a function/macro any format which I can run on the new workbook and find out which of my servers on the list there. That means it should check each cell from the new workbook with all the names from the master list. If found a match, just popup the names or highlight the matching names. Let me know if you need more details. Swapnil

• Answer:

  It sounds as though a simple COUNTIF function should do the job for you =countif(YourList,ValueToCheck) where YourList is the location of the valid list, and ValueToCheck the new name - you can then filter on the 1's as these are the matches. There is no problem having this formula as an external reference, and you COULD record entering it into the first cell as a macro which you can then run as and when you want and autofill down.