Recent content by Corgano

Are you sure they don't have some unusual or incorrectly configured rule setup?

Thank to both of you. I'm stubborn and got both solutions working! Not sure why PHV's gave me troubles are first but revisiting it worked smoothly.

Skip, Thanks! To the five columns, as you seem to have guessed, they are unnecessary. Just me trying to work around the problem with my limited knowledge. I have your solution mostly working (I think!). I left unclear one large item, the color codes need to be in ranges. I.e. be green if the...

Hello all, I'm a pure VBA beginner, working on some conditional formatting for eight conditions. The conditional formatting works fine but I'm recycling some basic internet found code and locking down the location in the spreadsheet I'm testing against is causing me problems. Here's the code...

Thanks, will do!

Hello all, I'm a pure VBA beginner, working on some conditional formatting for eight conditions. The conditional formatting works fine but I'm recycling some basic internet found code and locking down the location in the spreadsheet I'm testing against is causing me problems. Here's the code...

If you have all of the data setup the correct way in sheet 1, why do you need to use formulas to get it onto sheet 2? A better way to ask: What are you changing from sheet 1 to sheet 2?

Good afternoon! I'm getting a generic error message using Impromptu 7.1 that doesn't help me troubleshoot: NCR TDATA.DLL "Continue request submitted but no response to return." The query works fine when I'm filtered for only a few lines of results. I'm looking to remove the filter to pull...

Bah! Anotherhiggins beat me to it! :)

You just need to modify the formula a tad: =SUMIF(D1:D5,"X",E1:E5) Good luck!

It's forth from the bottom (sorry for the double post, there's no edit feature >< )

This website has some cool chart info including what I think you're looking for: http://andypope.info/charts.htm

Sorry, change H to =COUNTIF($C$2:$C$50000,G2) in order to maintain the references!

Ugly, processor intensive, drawn out method: I'm sure a VBA or cleaner solution is available but... Column A = Company Column B = Tag Carry each of these down to whatever: Column C: =A2&" "&B2 Column D: =COUNTIF($C$2:C2,C2) Column E: =IF(C8<>"",IF(D8=1,COUNTIF($C$2:D8,1),0),0) Column F: 1, 2...

I know you're looking for an Excel solution but this sounds like it would be a snap if you imported the table into access. Just a thought.