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. frantzx

    Wondering if this is possible

    ...infact I did figure it out: =SUMIFS(C:C,A:A,"over",B:B,"3/3/") =SUMIFS(C:C,A:A,"short",B:B,"3/3/")
  2. frantzx

    Wondering if this is possible

    Nevermind, I'll figure it out. Thanks anyway.
  3. frantzx

    Wondering if this is possible

    Pivot tables would work, but the data in this sheet is constanly updating and would add different varible each time it updates. Plus the data I'm wanting is going into a different sheet. If I put it in a pivot table the cell I use to pull the data from will move once the new varibles are added...
  4. frantzx

    Wondering if this is possible

    One more question, If I wanted this info by date how would I go about it? Sample of what I'm looking for: A B C D E Exception Date Units 3/1 total short 3/1 total over short 3/1 2 5 0 short 3/2 3 short...
  5. frantzx

    Wondering if this is possible

    @ anotherhiggins That worked, Thank you!
  6. frantzx

    Wondering if this is possible

    I have a spreadsheet I'm trying to figure out. Below is my data: A B C Exception Date Units short 3/3 2 over 3/3 3 short 3/3 4 short 3/3 1 over 3/3 5 What I want is in a seperate column to show how...
  7. frantzx

    Listing matches in Excel

    Ah ha! That worked! Thank you so much.
  8. frantzx

    Listing matches in Excel

    F1: =IF(ISNA(MATCH($A1,B$1:B$4,0)),IF(ISNA(MATCH($A1,C$1:C$4,0)),IF(ISNA(MATCH($A1,D$1:D$4,0)),IF(ISNA(MATCH($A1,E$1:F$4,0)),"",$A1),$A1),$A1),$A1) F2: =IF(ISNA(MATCH($A2,B$1:B$4,0)),IF(ISNA(MATCH($A2,C$1:C$4,0)),IF(ISNA(MATCH($A2,D$1:D$4,0)),IF(ISNA(MATCH($A2,E$1:F$4,0)),"",$A2),$A2),$A2),$A2)
  9. frantzx

    Listing matches in Excel

    I did that, the formula will paste but nothing shows up in the cell. I pasted in F1, copied down, hit F9 to calculate and nothing happens.
  10. frantzx

    Listing matches in Excel

    Still nothing
  11. frantzx

    Listing matches in Excel

    I'm just getting blank cells, none of the matches are showing up in column F.
  12. frantzx

    Listing matches in Excel

    I'm not sure I follow. Like I said I'm still a noob at excel ;)
  13. frantzx

    Listing matches in Excel

    Sorry if this has been posted before, I'm fairly new to this. I'm looking to list matches or duplicate cells found in my spread sheet. Here's an example of what I have: A B C D E R-1-A1A1 R-1-B3A2 R-2-S1W4 R-3-G23P4 R-4-Y4I7 R-1-A30M2...
  14. frantzx

    Macro Help

    I have 6 different query tables. I will need to leave the workbook open throughout the day and run the macro once an hour to update it. I could do a manual refresh then run the macro, but I wanted a macro that would do all that for me with one click.
  15. frantzx

    Macro Help

    If I do that none of my external data will refresh, correct? I need it to.
  16. frantzx

    Macro Help

    Added that in and now I get: Run-time error '1004': This operation cannot be done because the data is refreshing in the background.
  17. frantzx

    Macro Help

    Yes, sorry what I meant to put was everything after ActiveWorkbook.RefreshAll. I ran the F8 and seen what all was going on. What happens is that it will refresh the workbook, then do the text to columns, but after the text to columns is done the info I am refreshing will actually load on to...
  18. frantzx

    Macro Help

    Sorry yes that Is what I meant, everything after ActiveWorkbook.RefreshAll. I'll give the f8 a shot and see whats happening....
  19. frantzx

    Macro Help

    I have a question regarding macros. I built a macro in the order I want things done in my work book. But for some reason when I run the macro it will do the last part first, then it will run the rest of the macro.I think it may be doing this because the last part of my macro is a quicker process...
  20. frantzx

    Ms Office background red

    Any way you could post a screenshot of what you are seeing?

Part and Inventory Search

Back
Top