Search results for query: *

...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/")

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

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

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

@ anotherhiggins That worked, Thank you!

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

Ah ha! That worked! Thank you so much.

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)

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.

Still nothing

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

I'm not sure I follow. Like I said I'm still a noob at 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...

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.

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

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

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

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

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

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