Thread: Computers Microsoft Excel - How often do you use it?
View Single Post
Old 12-08-2018, 04:41 PM   #18
eDave eDave is offline
Banned
 

Join Date: Jan 2013
Casino cash: $9998560
Quote:
Originally Posted by Coach View Post
See attached.

As you can see, the left would have the full name while on the right, some will already have a full name (which can be easily found by using the conditional format for duplicate values). Others will have a partial due to missing middle initial/name or partial first name.

My end result would be is to find column A (which is like roughly 25-50 names) and on column C, it would have a complete roster of who joined (in excess of 700 names), in a yearly cycle.


Basically, I just want to find a functional or something that allows me to find the person's full name on the left to have a probability of matching the name on column C.

For example, Feunutes, Shannon Arnold on the left is Feunutes, S. But because of Column C is larger, I don't want to have to use search and find each individual names independently/manually, if that makes sense?
My own personal fetish I guess, but I prefer separate tabs for each table. Maybe sadistic is a better term.
Posts: 53,803
eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.
     Reply With Quote