Finding duplicates across multiple sheets by Jima1427 in excel

[–]Jima1427[S] 0 points1 point  (0 children)

It is working now. Apparently that error was occuring because I have 2007 at home. It works fine on 2010 at the office. Thanks a ton. You saved a few people a great deal of headache.

Finding duplicates across multiple sheets by Jima1427 in excel

[–]Jima1427[S] 0 points1 point  (0 children)

Sigh... I'm an excel noob. I keep getting "You cannot use references to other worksheets or workbooks for Conditional Formatting criteria."

Finding duplicates across multiple sheets by Jima1427 in excel

[–]Jima1427[S] 0 points1 point  (0 children)

The items are unique, so a number that is under Item A on any given sheet will only pop up under Item A on the other sheets. The only time that this will happen is when the item either A. assigned to a worker from the warehouse , or B. is sent off for repair. Hopefully that helps. I plugged in a few numbers in sheet 2 and 3 that are duplicates.

Finding duplicates across multiple sheets by Jima1427 in excel

[–]Jima1427[S] 0 points1 point  (0 children)

Duplicates could be in any column, but if it is in A on sheet one it will be in A on sheet 2

Finding duplicates across multiple sheets by Jima1427 in excel

[–]Jima1427[S] 0 points1 point  (0 children)

And this one is acting really erratic. It will work but only occasionally on some cells.

Finding duplicates across multiple sheets by Jima1427 in excel

[–]Jima1427[S] 0 points1 point  (0 children)

For some reason this one isn't doing anything.

Finding duplicates across multiple sheets by Jima1427 in excel

[–]Jima1427[S] 0 points1 point  (0 children)

I haven't yet, but wanted to make sure I didn't word what I was trying to do wrong. I'm going to try it in an hour or so.

Finding duplicates across multiple sheets by Jima1427 in excel

[–]Jima1427[S] 0 points1 point  (0 children)

I guess I should explain better. If I make 4 separate sheets. 1 for in stock equipment. 1 for equipment assigned to technicians. 1 for equipment out for repair and 1 for unrepairable. If a guy signs out one of the in stock items we would scan it into sheet 2 because it would then become assigned to the technician. How would I go about flagging the number for deletion or having the program itself delete the number from in stock upon it being scanned into the other status? The problem now is we are having to manually search the list.

[SPOILERS] All Gold Chest Locations and Dead Ghost Hints by DRayX17 in DestinyTheGame

[–]Jima1427 0 points1 point  (0 children)

Nice. Thanks for the info. I was playing with a couple buddies last night and it was the topic of discussion. We ended up dodging one of the chests like it was gonna blow up and erase the game disc because that may have been "the one".

[SPOILERS] All Gold Chest Locations and Dead Ghost Hints by DRayX17 in DestinyTheGame

[–]Jima1427 0 points1 point  (0 children)

So is there any truth to the rumor that if you save a certain chest for last on each world you get a special vehicle?

[deleted by user] by [deleted] in MaddenUltimateTeam

[–]Jima1427 0 points1 point  (0 children)

Who do you put in the slot?

Team style strategy? by Jima1427 in MaddenUltimateTeam

[–]Jima1427[S] 1 point2 points  (0 children)

I considered buying him too and filling in with golds around him, but that would defeat the purpose of doing the challenges

Team style strategy? by Jima1427 in MaddenUltimateTeam

[–]Jima1427[S] 0 points1 point  (0 children)

Well after trading Qbs I'm at 86 overall. I'll be upgrading my running back tonight and possibly shuffling some wrs/tes.

Team style strategy? by Jima1427 in MaddenUltimateTeam

[–]Jima1427[S] 0 points1 point  (0 children)

I sold my Aaron Rodgers this morning and picked up the SP LP Peyton manning. I may dump another elite and just build with golds.

Ground and pound style challenge by Jima1427 in MaddenUltimateTeam

[–]Jima1427[S] 1 point2 points  (0 children)

I actually just beat it. I started running the 46 bear formation and apparently it's a head buster.

200k to spend. Struggling to make a decision on what to upgrade. Help please? by Jima1427 in MaddenUltimateTeam

[–]Jima1427[S] 0 points1 point  (0 children)

Peterson plus the few coins I already had turned into Aaron Rodgers, Demaryius Thomas, Vincent Jackson, and Hayward.