ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   CUBEMEMBER (https://www.excelbanter.com/excel-worksheet-functions/256559-cubemember.html)

shairal

CUBEMEMBER
 
Does anyone know if you can use a wildcard with the cubemember function, and
if so, how? I am trying to pick up all product IDs that start with KRLMJ129*
(ie, KRLMJ129arj, KRLMJ129lik, KRLMJ129pwr, etc.). Is this possible? I have
tried adding the * at the end of the ID, but it doesn't work.

Using Excel 2007 with OLAP data source from SQL Server '08.
Thanks in advance!


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com