Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server

I have a MS-QUERY that retrieves 4 columns from an SQL server. I want to create a fith column that is evaluated as formula in excel, not in the SQL server

The fith column should compare column 4 with the value on an excel function (in this case percentile):

=if(column4 percentile(sheet1!ReferenceName, 0.25), 1, 0 )

I have two options
- Create a manual formula everytime the data is refreshed from the server
- Using vba to trap the Query AfterRefresh event, then get a range of the fifth column and update every cell formula

However, i want to know if is posible to create a retrieve data using MS-query that is only evaluated in excel and not treated as string nor evaluated in the SQL server. Something like this

Select col1, col2, col3, col4, '=if(col4percentile(param1, 0.25),1,0)' from Table
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel with SQL Query (*.sql) and SQL Server Kode Excel Discussion (Misc queries) 2 May 8th 07 01:10 PM
SQL Server Query to Excel Nick Hodge Excel Programming 0 February 13th 07 08:27 AM
Query SQL Server from Excel Doctorjones_md Excel Discussion (Misc queries) 1 January 6th 07 09:35 AM
Query SQL Server from Excel Doctorjones_md Excel Worksheet Functions 1 January 6th 07 09:35 AM
Query SQL Server from Excel Doctorjones_md Excel Programming 1 January 6th 07 09:35 AM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"