| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return value from specific column if not in new column previously
I have a spreadsheet where a user enters values in column B for a specific
set of rows, i.e. rows 1 - 6. For purposes of this example, the user enters 1, 2, or 3 in cell range B1:B6. In column J, I want Excel to automatically pick up what the user entered in column B and insert the same data in column J. However, I do not want multiple instances of the same data in column J, just one instance. For example, in column B if a user enters the following in rows cell range B1:B6: 1, 2, 2, 1, 1, 3; I want column J to only display 1, 2, 3 and not 3-1's, 2-2's and 1-3. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum specific column rows based on 2 different column criteria | Excel Worksheet Functions | |||
| Return Values in a specific column | Excel Discussion (Misc queries) | |||
| Return column number from column header text | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
Threaded Mode
