Recent content by Bokazoit

tx very much that did the work...The only problem is that I do not hope that there will be more stores 'cause then excel can't handle the amount of lines in the formula :p

I need a function that can do the following: The function reads a textstring from sheet1, that look as follows - lets call that variable var1: var1: DK10, DK12,...,DK30,...,DK65 In coloumn Q I have var1 represented in random amounts depending on search criterias. In coloumn P I have another...

I have a small problem (I hope) I have created an advanced filter using this code: code: -------------------------------------------------------------------------------- Sub Filter_Copy() Worksheets("Kampagneprioritering").Range("N4:AB1004").Delete Application.ScreenUpdating =...

The sumproduct function seems great to do the last part of the job, but in Coloumn C I need to find the array of each chain before I can move to use the sumproduct function :p Anyone? :)

Coloumn C in my worksheet has several chainnames, something like this: Bilka Bilka Bilka Bilka Føtex Føtex Føtex CK CK CK CK CK SB SB SB etc. Is there a formula that can return the array of each chain in column C? in the coloumns from D and onwards there will be a list of...

Okey I try again. If I don't wanna use the filterfunction then what? If I have the list above in sheet1 (copied again for Your convinience :)): Konzs Chainnr Storenr Sales District Customer Number Customer Name 1 Street Postcode City K DK601 DK60109 DK10 DK110999 URTH SUPER SPAR HJØRRINGVEJ...

Yes and the autofilter is fine but it's not what I need. The user (for now me) should enter some criterias in some cells and few of the criterias is used to sort the list a gave above (the real list has almost 1000 rows though) and other criterias incorporates timedefinitions (workhours)...

I have this sheet with close to 1000 rows. Each row contains a store (it's address, phone, etc.), and it also contains information about visitfrequencies for our salesstaff. The sheet looks like this: Konzs Chainnr Storenr Sales District Customer Number Customer Name 1 Street Postcode City K...

Some of my the data in my report is 'empty' cells. How to change an empty cell with a 0 (Zero)?

If You think that, then how? Here is the SQL from my Crosstab-table which I build my report on: TRANSFORM Sum(Dataopsamlingstabel.Omsætning) AS SumOfOmsætning SELECT Dataopsamlingstabel.Kæde, Dataopsamlingstabel.[Kæde-Sub], Dataopsamlingstabel.Butiksnavn, Dataopsamlingstabel.[CP kategori] FROM...

Yes I read it, but plz read my threads again then. My variables are dynamic. Each of the 6 variables can take the value of 3 months for 2003 and 2004 respectivily depending on the quarter I choose. In contrary to the dynamic report as described in Your link, the current month is Mth0, last...

@dhookom: You said: 'You can set the Column Headings property of your crosstab' What You mean? Well they are dynamic since they aren't depended on the actual month. They change depending on the quarter I look at. The only problem is that when looking at this quarter we have some unfinished...

Perhaps I explain myself badly (Don't hesitate to tell me that) I simply need a way to filter out a variable in a report if the variable isn't present in the query as it's the case in my problem. So for 3. quarter I have these periods: LYKV1 (July 2003) LYKV2 (August 2003) LYKV3 (September...

It gives me #error ?:(

I create a crosstab table that includes a quarter for 2003 and 2004 respectivly. But since we are in the middle of a quarter right now November and december data is still missing. In my crosstab I have the following variables LYKV1 (Last year 1. month in the quarter) LYKV2 (Last year 2. month...