Test...

L.T. Fan said:
I understand this to be the proper response. Sound track or GTFO.
Click to expand...


I'm working on it, but they are very few and far between. Maybe one a week, but it's just so damn unnerving that I sit there for a few seconds wondering if it can really be real.

Might not be that bad to most folks, but it drives me crazy.
 
Might be easier if you used a formula to put an 'x' in an adjacent column for the rows that contain your (x) variable. Then, you could auto filter the heading to only show rows with the 'x'. No scrolling through your spreadsheet to find colors. You could also do pivot table off of the identified rows.
 
pdom said:
Might be easier if you used a formula to put an 'x' in an adjacent column for the rows that contain your (x) variable. Then, you could auto filter the heading to only show rows with the 'x'. No scrolling through your spreadsheet to find colors. You could also do pivot table off of the identified rows.
Click to expand...

That would have been the fallback plan, but I wanted to be able to note the offending cell directly, making it easier to reference. I don't half-ass shit, Phil.
 
pdom said:
Might be easier if you used a formula to put an 'x' in an adjacent column for the rows that contain your (x) variable. Then, you could auto filter the heading to only show rows with the 'x'. No scrolling through your spreadsheet to find colors. You could also do pivot table off of the identified rows.
Click to expand...

I have multiple identifiers in this SS, so the color scheme worked best. Now, a pivot table is a damn good idea. I think I will add one.
 
Iamtdg said:
That would have been the fallback plan, but I wanted to be able to note the offending cell directly, making it easier to reference. I don't half-ass shit, Phil.
Click to expand...

You could do both then, even with multiple identifiers.
 
pdom said:
Janice laugh from Seinfeld?
Click to expand...

I am not familiar with this one.

It's kind of like a "hehehehe" squeaky mouse on helium giggle that is totally fake and lasts for maybe a second.
 
Iamtdg said:
BTW, I figured it out. Essentially. it's a substring formula. Very similar to =ISNUMBER(SEARCH(substring,A1)) replacing "substring" with the variable I want triggered on. In this case it is (X) that I want triggered. Works like a charm. :towel
Click to expand...

Glad that's fixed.

Now can anyone help me get into my Yahoo?
 
Kbrown said:
Glad that's fixed.

Now can anyone help me get into my Yahoo?
Click to expand...

You might want to start a thread for that. The answer to that will not be an easy one.
 
Kbrown said:
Glad that's fixed.

Now can anyone help me get into my Yahoo?
Click to expand...

You can message Jiggy for that. Just keep him tied up for awhile with that if you don't mind.
 
Trying to decide whether or not to leave work early.
 
Just pulled the trigger on getting my daughter's Xmas present, which is what she wanted a MacBook.

Pisses me off. Never spent that kind of money on a laptop for myself.

And she's an Apple person.

You try to raise them right and you get this shit.
 
boozeman said:
Just pulled the trigger on getting my daughter's Xmas present, which is what she wanted a MacBook.

Pisses me off. Never spent that kind of money on a laptop for myself.

And she's an Apple person.

You try to raise them right and you get this shit.
Click to expand...
:lol. It doesn't get easier.
 
You must log in or register to reply here.
Back
Top Bottom