Jon316G

iTrader: (1)

Thanks for the offer, but I shouldn't need too many hands today.
And we've moved a ton of boxes the past couple days, so tomorrow shouldn't be bad either (just the heavy stuff).

docgatorx8er

iTrader: (10)

Per Marlin on the NORA site:
http://www.noraracing.net/forum/view...p=24086#p24086

[quote]
Wait guys there's more! I met with the powers that be @ Montrose Auto Group, formerly Westside and they want in!!! They will be offering us parts, service and accessory discount not only at Westside, but any amd all of their dealerships. So no matter what you drive, they will hook you up.

I will be finalizing things on Monday to put some packages together with Chris Dunn, he 's the Accessories Manager @ Westside and has connections to a number of aftermarket companies as well.[quote]

Vyndictive

iTrader: (28)

Ugh! I need another car! That way I won't have to worry about busting the 8 and it being the daily driver.
I'm probably awful at autoX and/or on a track anyway.

Stupid money.

docgatorx8er

iTrader: (10)

I can't do Auto Show. Dates are Feb 28- Mar 8. I'll be in El Salvador. AutoRama (whatever that is) is March 20-22.

Vyndictive

iTrader: (28)

Can't you go to Mexico some other time?

(Saw this somewhere else on the forums and it applies to how I see the world.)

docgatorx8er

iTrader: (10)

I need help with an excel spreadsheet function. If a cell contains the letters "OH" (for ohio), then cell =another cell.

I've got "=IF(U7282=OH, =J7282,"") But it's not working. Anybody know the correct semantics.

docgatorx8er

iTrader: (10)

You explain that to the kids in the orphanage!

Vyndictive

iTrader: (28)

I'd need to brush up on my spanish... but, I'll go with ya!

docgatorx8er

iTrader: (10)

check out the videos;
http://drdomo.com/ElSalvadorVideo.aspx

Vyndictive

iTrader: (28)

Doc; you're lucky you do something that actually ads value to society.

No one ever requests a meeting with human resources, and managing benefits doesn't really enhance anyone's life
... Plus I had to beg just to get time off to go to Germany and China (for my MBA) Stupid tether attaching me to my desk...

VezRX

Holy crap this a bunch of snow. Still going to take a shot at moving tomorrow Jon?

DeViLbOi

iTrader: (1)

=IF(U7282="OH",J7282,"")

DeViLbOi

iTrader: (1)

Jon has asked that everyone call him in the morning to verify if the move is a go. With the weather the way things are he wants to see what it is like before we all drive down there. He has no internet at the house and his cell phone does not allow him to read txt messages. Please call him.

docgatorx8er

iTrader: (10)

Tnx John. Gotta search out ohio sales for sales tax. Getting too big to do manually.

How can I write it to say if U7282 contains "oh", instead of equals "oh"?

DeViLbOi

iTrader: (1)

=IF(U7282="OH,J7282,IF(U7282="Ohio",J7282,""))

docgatorx8er

iTrader: (10)

Doesn't' like that. Error message with "Ohio"

EDIT- Never mind, was just missing the " after oh above. Figured it out. Tnx

Will that work if there's other data in the cell, like city or zip code. Or only if only state data is present?

DeViLbOi

iTrader: (1)

It will only trigger if the cell contains OH or Ohio...nothing else. Best bet is to go through the data and clean it up. Best way to do that would be to go to Tools >> Filter >> Auto Filter and find the weird data and correct it.

docgatorx8er

iTrader: (10)

I sell on several different venues. Amazon, Ebay, My own site, Google.

Each venue provides data in a different format. Some provide the state as a separate entry, others combine city, state, zip in a single cell. I really can't remove the extraneous data, because I need that record. Unless you can suggest a way to.

docgatorx8er

iTrader: (10)

I used to do this manually, but now have over 11,000 sales entries and growing! Too much to do manually.

DeViLbOi

iTrader: (1)

Try this....

=IF(ISNUMBER(SEARCH("OH",U7282)),J7282,"")

docgatorx8er

iTrader: (10)

I think that works!!! Now. the only false answer is if the city has "oh" in it somewhere. Any way to also highlight the cell so I can go back and verify data. (I know, I'm pushing it here) I really appreciate it!


BTW - I owe you a non-alcoholic umbrella drink!

DeViLbOi

iTrader: (1)

Format >> Conditional Formatting

Use the same formula for it

docgatorx8er

iTrader: (10)

I owe you a virgin boat drink!!!!! THANKS!

Now can you get it to PAY the taxes?????

DeViLbOi

iTrader: (1)

rofl...I can get them paid by making the calculation to total them and get the citizen that owes the taxes a figure to write on a check.

Jon316G

iTrader: (1)

Well I'm at my dad's now.
Obviously snow was HORRIBLE and I had to get the U-Haul today because they are closed tomorrow, will charge me a $50 fine for canceling, AND my utilities are being shut off Monday.
But with the Akron streets so horrible I drove the U-Haul to my dad's and he is going to bring it down tomorrow morning.
I have no choice but to move tomorrow, so hopefully the weather & roads are better.
Then to make matters worse, my snow blower started back-firing!
I replaced the spark plug because it was bad looking, but that didn't work.
So I took it to my dad's and we took it apart.
It runs better, but I'll need to take it apart again to tweak it more (which I can do in my new garage).

Anyway... if anyone still wants to help tomorrow, give me a call.
If its still bad out, I would rather you guys be safe and stay off the roads.
I'll be back online Monday night... so I'll talk to everyone then.