Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Matching cells that have unrelated information
Hello all,
I would greatly appreciate if someone could please asisst me with my issue. I'm trying to figure out a way to pair up information in two cells with different values. Please see example.... Col1(Ticker Client) Col2(Share Position) Col3(Ticker Company) Col4(Par) TKxxx 1,200.000 ^Tkuxx 1,200.000 What I'm trying to do is find a function, formula or macro that will allow me to take the "client ticker" and pair it with the "companies ticker" so I can make sure I don't have share variances to the client. The clients ticker is always different from the companies ticker and I have thousands of positions to reconcile. I tried sorting Col1 and then sorting Col3 but I still have to many securities(tickers) that are not matched. Does anyone know a functions that can match the companies info to the clients info other than sorting? Please advise. Your help is greatly appreciated. Thank you |
#2
|
|||
|
|||
Troy,
I think that you are probably confusing people by the way you have phrased your question. Col1 (Client Ticker) Col2 (Share Postiion) Col 3(Company ticker) TKXXX $120,000 ^TKXXX If you want to match items up then you need at least something that is COMMON between the CLIENT TICKER and the COMPANY TICKER (but you have said the these are different...just your wording) So what is the common bit of information that will allow a join of these two fields? If there isn't one then you have no chance of joining them to begin with. James "Troy S." wrote: Hello all, I would greatly appreciate if someone could please asisst me with my issue. I'm trying to figure out a way to pair up information in two cells with different values. Please see example.... Col1(Ticker Client) Col2(Share Position) Col3(Ticker Company) Col4(Par) TKxxx 1,200.000 ^Tkuxx 1,200.000 What I'm trying to do is find a function, formula or macro that will allow me to take the "client ticker" and pair it with the "companies ticker" so I can make sure I don't have share variances to the client. The clients ticker is always different from the companies ticker and I have thousands of positions to reconcile. I tried sorting Col1 and then sorting Col3 but I still have to many securities(tickers) that are not matched. Does anyone know a functions that can match the companies info to the clients info other than sorting? Please advise. Your help is greatly appreciated. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel - Grouping and Sorting Cells | Excel Discussion (Misc queries) | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Matching cells | Excel Discussion (Misc queries) | |||
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) |