| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching Data
I have two Columns of data "Previous" and "Current" and I want to combine
them in to a column "Answer" that has both columns combined and only a single unique entry. I tried advanced filter but this destroyed the format I require by hiding the rows. Is their a formula you can use instead ? Previous Current Answer 1058 1063 1058 1059 1065 1059 1060 1066 1060 1061 1067 1061 1063 1069 1063 1065 1071 1065 1066 1072 1066 1067 1073 1067 1069 1074 1069 1071 1075 1071 1072 1076 1072 1073 1077 1073 1074 1078 1074 1075 1080 1075 1076 1081 1076 1077 1082 1077 1078 1084 1078 1080 1085 1080 1081 1086 1081 1082 1087 1082 1084 1088 1084 1089 1085 1090 1086 1093 1087 1088 1089 1090 1093 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter Data on one tab, then find matching data on another tab | Excel Worksheet Functions | |||
| Matching a column of new data to existing larger data set. | Excel Worksheet Functions | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Threaded Mode
