| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pull in 2 different rows and compare them
What I am trying to do is automatically compare totals in column F fro
two different excel sheets according to their account ID. What I nee is to be able to pull both row F into the 3rd sheet and have th account ID match side-by-side along with its corresponding total. Th reason is because sometimes Sheet 1 has an account that does not exis in Sheet 2. The look I am trying to accomplish is manually displaye below: Account ID 1 Account ID 2 100 100 101 101 102 103 103 104 104 Thanks in advance for any assistance. yale -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare two columns and pull out differences | Excel Discussion (Misc queries) | |||
| what formula do I use to pull rows containing a number? | Excel Discussion (Misc queries) | |||
| Pull user-specified rows from data set | Excel Discussion (Misc queries) | |||
| How do I write formula to compare two values and pull the resulta. | Excel Worksheet Functions | |||
| how to format pull down rows | Excel Worksheet Functions | |||
![yalex[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
