Search results

Hi arnelgp, That last formula is not quite working for me. In column A I have a list of non-sequential dates i.e. May 5 May 5 May 6 May 7 May 8 May 9 May11 May 15 I'd like the formula to check each date in column A, then return the number of unique days listed in Column A that occur before...

i have a followup question, how would I only count the number of days that proceed a a given date (i.e. the days in Column A) for up to 4 prior days? For example, for May 9 from my initial post, return 2 (May 5, May 6). Thanks in advance.

this website keeps me employed, thanks!

THis is excel actually, is there a way to do it without a pivot table?

Let's say I have a column A: May 1 May 2 May 5 May 6 May 6 May 9 The cells are formatted as dates. How can I return the count of the number of days in this range? i.e. 5 Thanks!

Hi plog, I was able to query it successfully using pbaldy's method. I appreciate the time and effort you put in for putting together your method though. Thanks!

Hi, I have a customer table (Name, Address), Product table (SKU, Type, Cost), and Orders Table (customer name, ProductSKU, Revenue, Date) I'd like to query which customers have NOT ever ordered a specific product type (i.e. "Potato Chips"). How would I make this query? Thanks!

Hi everyone, My attempt is a complete failure. Please help. Right now, I have both lists in Excel, but I think I can put them into Access to implement whichever a solution is designed for. TABLE 1 In Customer table 1, I have the [Customer] column(excel: A), it is the name, i.e. McDonalds 99...

thanks everyone for their input, i haven't had time to tackle this, i'm going to research the ideas pitched here and try to implement them before asking for more help. Thanks!

I have two tables, each with customer sales data where the same customer may exist in both data but under a different name (i.e. McDonalds #194 -USA vs #194 McDonalds,USA) Is there a simple, straightfoward way to merge records that belong to the same customer into a table? I'm baffled

I would like to query the average monthly revenue each year for a list of stores. My Orders table has the fields Store, Revenue, Order Month (yyyy-mm). I would like to see something like: Store AverageRevenuePerMonth Year 1 $20 2015 1...

Hi, Upon more inspection, it's not actually returning quite the right numbers. The dataset can contain many orders in a given month, it seems the query is averaging the sales across the orders, even if they are in the same month. I tried to divide the total sales by the count of number of...

Greetings y'all, I have an Order table featuring different store names (StoreName) as text, sales (Sales) as currency, and order date (Order) as Date (yyyy-mm) I would like to query the average monthly revenue for each store by year. In Query Design, I add the fields StoreName, OrderDate...