How to querry data or can I use SQL ?

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Hi,
I have one two worksheets in Excel one is simple and the second is pivot
table, what i want to do is:
I want to do something what would be in SQL like:
SELECT averange_field_from_pivot_table WHERE field_from_Worksheet1 =
field_from_Worksheet2

How can I handle this in excel ?

regards
Peter
 
Back
Top