| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
get unique result by selecting data from two lists
I would need to make formula in excel where from selecting the data from
different list (eg. object and period) will result with unique value specified by user (me). Is there possbility to make something like that. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
get unique result by selecting data from two lists
I don't quite understand your question. You can join the data
together, eg by: =Sheet1!A1&Sheet2!C1 assuming your "objects" are in column A of Sheet1 and "period" is in column C of Sheet2. Is this what you mean? Pete On Sep 17, 3:06 pm, Daniela Buric <Daniela wrote: I would need to make formula in excel where from selecting the data from different list (eg. object and period) will result with unique value specified by user (me). Is there possbility to make something like that. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting only rows of data with unique identifier | Excel Discussion (Misc queries) | |||
| Duplicate and unique items in 2 lists | Excel Discussion (Misc queries) | |||
| Help! I want to fill cells as a result of selecting a value from a list in another cell. | Excel Worksheet Functions | |||
| Extract Unique Records from two lists | Excel Worksheet Functions | |||
| AutoFilter lists unique values | Excel Discussion (Misc queries) | |||
Linear Mode
