Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Cordury2

    Excel *Wildcard* Question

    ...of characters varies in the cells so a left, right or mid is out. I want the formula to look to the cell and if any part of the text contains "ABC" then I want to return 1. =IF(C18="*ABC*",1,"") Cell C18 containts the letters ABC in order but my formula is still returning blanks? Any ideas?
  2. Cordury2

    SUMPRODUCT or ARRAY Formula

    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...
  3. Cordury2

    SUMPRODUCT or ARRAY Formula

    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)
  4. Cordury2

    SUMPRODUCT or ARRAY Formula

    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...
  5. Cordury2

    Vlookup function in excel not working! It's driving me crazy!

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

    Vlookup function in excel not working! It's driving me crazy!

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

    Vlookup function in excel not working! It's driving me crazy!

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

    Alternative to Pivot Tables?

    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.
  9. Cordury2

    Alternative to Pivot Tables?

    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.
  10. Cordury2

    Alternative to Pivot Tables?

    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.
  11. Cordury2

    Alternative to Pivot Tables?

    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...
  12. Cordury2

    Access Count function Question

    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.
  13. Cordury2

    Access Count function Question

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

    Access Count function Question

    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.
  15. Cordury2

    Access Count function Question

    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
  16. Cordury2

    Access Count function Question

    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.
  17. Cordury2

    Access Count function Question

    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.
  18. Cordury2

    Access Count function Question

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

    Access Count function Question

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

    Access Count function Question

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

Part and Inventory Search

Back
Top