How to querry data or can I use SQL ?

's Computer Specifications

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

's Computer Specifications

screw Excel, use Access

grow up

"Piotr" <(E-Mail Removed)> wrote in message news:cq47bi$sql$(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: querry to seperate data	John W. Vinson	Microsoft Access Queries	2	24th Mar 2010 04:56 PM
Querry for selected time in time series data	JBrady	Microsoft Access Queries	0	9th Aug 2008 01:24 AM
Excel Data Querry using criteria from Cell	=?Utf-8?B?THVrZSBCYWlsZXk=?=	Microsoft Excel Discussion	5	10th Oct 2007 07:09 PM
moving selected data from table_1 to table_2 via querry?	Will	Microsoft Access	3	19th Aug 2005 01:19 AM
Data shows in MS Querry, won't return to Excel.	=?Utf-8?B?RG91ZyBMYWhkZQ==?=	Microsoft Excel Crashes	0	28th Dec 2004 07:49 PM