Recent content by frantzx

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