Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Column A contains the fund number. Column B contains the account number.
These columns are used to form a unique fund/account code. Column C contains the balance for each unique fund/account code. The same fund code will be used for multiple account codes; the account code could be used with multiple fund codes. I have downloaded updated information in columns D-F. I want to compare the new information (column D & E) with the old information (column A & B) and somehow identify information that has been added (new in D & E) since the last time (A & B). I know how to do this when comparing one column of information with another single column. It's the two-column criteria that is confusing me. Any thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing columns and returning max value | Excel Discussion (Misc queries) | |||
comparing two columns | Excel Discussion (Misc queries) | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
Comparing columns | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) |