Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to compare 2 tables to generate 3rd table
I have a table with a list of items and another table that explains what each
item is. How do I have excel compare the 2 tables and generate a 3rd table with the items and description matched up? thanks -kev |
#2
|
|||
|
|||
Ok.
Maybe this is finite and you already know this but here it goes. In order to have an automatic response for the third table. You have to enter in a dedicated formula in the column in the third table. Let's say for example on your first table A:1 represents the number of hours "so-so" has left on a work order on your second table the column let's say F:1 represents the number of hours they put in on that day. On your third column you must go to the select cell (or column) and enter a formula on the first cell of the column. Ex. =A1-F1 . You can also click on the blank taskbar at the top of the screen and click Fx (function) and choose your function. You activate all this function in all cells in the column, just highlight the column and THEN click on function. Hope this helps, sorry if you already knew this. "Kevin" wrote: I have a table with a list of items and another table that explains what each item is. How do I have excel compare the 2 tables and generate a 3rd table with the items and description matched up? thanks -kev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically compare two slightly different copies of a table | Excel Worksheet Functions | |||
Is there a way to compare a pivot table refreshed data to old one | Excel Discussion (Misc queries) | |||
How to compare two tables in Access 2000? | Excel Discussion (Misc queries) | |||
compare tables | Excel Discussion (Misc queries) | |||
Is this simple I'm trying to compare values from 4 excel tables | Excel Worksheet Functions |