Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple values question
I have 2 cols of data and need Col 3 which inserts a value the same as column
2 but in a different range. Col 3 has been populated here to show as example. I've been working on if statements but can't find the right one, I've tried if and statements also. BTW I've only include Col 1 because it might help to uniquely identify the values, but may not be necessary. Using Excel 2003 SP3 Col 1 Col 2 Col 3 4 91610 37513 5 91610 37513 4 91611 37514 5 91611 37514 4 91612 37515 5 91612 37515 1 91613 37516 4 91613 37517 5 91613 37517 1 91614 37518 4 91614 37519 5 91614 37519 1 91615 37520 4 91615 37521 5 91615 37521 1 91616 37522 4 91616 37522 5 91616 37522 1 91617 37523 4 91617 37523 5 91617 37523 1 91618 37524 4 91618 37524 5 91618 37524 1 91619 37525 4 91619 37525 5 91619 37525 1 91620 37526 4 91620 37526 5 91620 37526 1 91621 37527 4 91621 37527 5 91621 37527 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
create a list of single values from multiple values | Excel Worksheet Functions | |||
Search multiple values to return single values | Excel Worksheet Functions | |||
multiple series of values graphed with indep. x values -possible? | Charts and Charting in Excel |