get unique result by selecting data from two lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top