Search results for query: *

Tried to bump this old thread thread68-679182 but it is now closed...only 5 years old :) Is it possible to use the wildcard in an IF formula? For instance, I have a spreadsheet with text and numbers in the cells, the number of characters varies in the cells so a left, right or mid is out. I...

Thanks Skip. Column N had just had the number 1 in it. And the formula was summing the amount of occurrences in between the dates regardless of store number (and still is). When I enter in the corresponding store numbers in column N, I am getting some very large numbers. The set up of the...

Below if the formula I am using and it works (suming the date between the dates) but I want to count specific stores and dates, not just dates. =SUMPRODUCT(('Top 50 Data'!$A$2:$A$205>=Sheet1!F6)*('Top 50 Data'!$A$2:$A$205<=Sheet1!E6),'Top 50 Data'!$N$2:$N$205)

Is it possible to count the number of occurrences in between a date range if you have a unique identifier? I can use the SumProduct function to sum the date but I want to count the # of times a 'Store Number' appears in my data dump. Any help would be appreciated. Or just I just try an IF...

I think that function just displays the actual formulas in the cells and not just the formula bar...but am not sure.

Oh, I did not read the entire post. Hit Ctrl + the "tilde" key to the left of the 1 key.

Is your lookup value a number? Multiply D7 by one and see if that helps.

Thank you all for the tips. I may try the sumproduct function... Right now I have created a unigue identifier with the concatenate function using the store&date&sku as well as using the rank formula with each sku.

No real issue with pivots myself, I was just wondering if I could use the choose formula with a lookup or something like that. VBA is out for me since I am not at that level.

I guess I am just looking for suggestions of another way to approach this than using a pivot table. Ideally, I want to set up one sheet that will pull the worst variances by the sku column.

I have a list where the unique identifying number repeats several times because of multiple items (different sku numbers). This data also contains an inventory column, sku count column, and variance column. Other than a pivot table, is there another way where I could rank the variance of each...

I got the original table and PV's code seems to be working. Again, thank you both so much for your time and patience as well as expertise.

The Compact and Repair won't work either. I am working on getting the original table.

It was Number but I changed it to Text. Now when I try and change it back to Number and save I get a Not enough disk space or memory error so it is stuck at text. I am a nightmare, I know.

PHV SELECT bytran.CDay, Count(bytran.Sales) AS CountOfSales FROM ByTran WHERE bytran.Sales>50 GROUP BY bytran.CDay I am sorry, I did try your suggestion and the following error occured: "Data type mismatch criteria in expression

Randy, First off, thank you for your patience. But the SQL is SELECT ByTran.CDay, Count(ByTran.Sales) AS CountOfSales FROM ByTran GROUP BY ByTran.CDay WHERE ByTran.Sales > 25 and I am stillg getting the same error.

Now if I do this: SELECT ByTran.CDay, ByTran.Sales FROM ByTran GROUP BY ByTran.CDay, ByTran.Sales HAVING (((ByTran.Sales)>"50")); it returns all records over 50 which I could throw into Excel and a Pivot table but I am looking to get it all through Access.

Syntax Error (missing operator) in query expression 'ByTran.CDay WHERE By.Tran.Sales > 25'

Here is the SQL SELECT ByTran.CDay, Count(ByTran.Sales) AS CountOfSales FROM ByTran GROUP BY ByTran.CDay HAVING (((Count(ByTran.Sales))>50));

Hi Randy, The dollar amount is in the Sales column and that is where I am placing the criteria.