View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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!