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!

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!