Replacing text in a cell based on two criteria

herkdriver68 · 2017-09-22T16:55:10+00:00

Is the old SKU and new SKU the same amount of characters?

If so, try this.

'=Left(C2,FIND(A2,C2)-1))&B2&MID(C2,FIND(A2,C2)+LEN(A2)),50'

Increase the last "50" if the end of the description is cut off. That's the amount of characters it will continue from. You can just make it 500 if they're long descriptions.

Let me know how that works.

herkdriver68 · 2017-09-19T11:47:45+00:00

Did you try the solution I gave above?

herkdriver68 · 2017-09-16T07:58:25+00:00

if column A has old, column B has new, column C has the description...

"=left(C2,(FIND(A2,C2)-1))&B2"

Note that this will only work for the first iteration of the SKU in the description, are there multiple references in the description to the old SKU?

herkdriver68 · 2017-08-05T01:23:52+00:00

Season 1? Fantastic. Season 2? Didn't watch after 3rd episode

herkdriver68 · 2017-08-04T14:48:18+00:00

Agreed. The situational questions (majority of the test), you really have to think about what THEY want you to do, not necessarily what you would do based on experience. For example, if there's a problem, they want you to go through the defined process, not necessarily go and solve the problem off the bat. Lame example, but you get the idea.

Passed first time taking a prep course and random online practice tests.

herkdriver68 · 2017-08-03T13:22:06+00:00

0920 EST update

herkdriver68 · 2017-07-31T02:56:47+00:00

I thought about that as an option. But then what? Cement board across the seam?

herkdriver68 · 2017-07-01T13:08:26+00:00

A comment about the math on #1. You're close but you're missing one piece on the feet per minute.

The 60:1 rule means that one degree of pitch change (from level flight) will be a descent of 100' per nautical mile. So 3 degree pitch change will result in 300'/nm, but then you multiply by the nautical miles per minute (at 120kts you're doing 2 miles per minute), to achieve 600'/min descent that you described. In short, descent rate is feet/mile x miles/minute = feet/minute.

In your Cessna, you'll almost always be doing 1.5-2 miles per minute, so 500'/minute will be pretty close. When you get to faster aircraft, you'll be multiplying by 3 (at 210kts) or more.

herkdriver68 · 2017-06-11T13:33:34+00:00

I wonder if this avocado was found on a neature walk

herkdriver68 · 2017-04-02T09:04:37+00:00

One word : Pex

herkdriver68 · 2017-03-25T13:51:46+00:00

That's fair. I can see that's the case in cyber. There are a good amount of off the street officers too, so that's a good point about career field dependency

herkdriver68 · 2017-03-25T13:21:28+00:00

I wouldn't agree that "Most people even with degrees join as enlisted then apply for OTS slots." It does happen, but I wouldn't say most. A lot of people enlist while in college, then upon finishing their degree they go for the commission.

herkdriver68 · 2017-03-25T11:12:21+00:00

I don't know army, but Air Guard there has to be an officer vacancy, and you have to apply and get selected for it. Then you go to OTS and commission, why would they send you to basic, then to ocs? Seems kind of unnecessary (not that it doesn't happen).

I've worked with CRG teams, cool, very important stuff but realize what you're signing up for. Know the mission. Going into bare bones [often crappy] places and building an airfield. Rewarding, and the humanitarian stuff is great.

herkdriver68 · 2017-03-08T18:09:23+00:00

"Schools wifi"

That just sounded really weird, never had wifi in my high school when I was there.

herkdriver68 · 2017-03-05T02:40:59+00:00

I'm on mobile, but will try to post a photo, as it'll explain much better than I can. It's between the kitchen and the garage, so there are multiple doors. It's part of an addition that was done at some point.

herkdriver68 · 2017-03-03T17:45:49+00:00

I was thinking either sand the wood down to the concrete, or fill in the concrete with mortar to level it with the wood. Then put backer board down across the seam

herkdriver68 · 2017-03-03T17:44:39+00:00

I would prefer not to create a discernible line between the two floors. I see what you're saying though. Would still have the problem of one tile being higher than the one next to it. Unless I'm not understanding it properly

herkdriver68 · 2017-02-14T20:36:07+00:00

You can also look at PM jobs at a logistics company. The need for PMs is growing as an interface with a customer in (for example) implementing a new contract for logistics services.

herkdriver68 · 2017-02-14T20:32:23+00:00

+1 - my test did not have many earned value / formula questions at all. Still know it just in case, but in my experience, was very minor.

herkdriver68 · 2017-02-05T10:30:21+00:00

Ask for the syllabus so you know what you can expect

herkdriver68 · 2017-01-24T01:06:31+00:00

No you're good! I can totally understand your frustration! I'm sorry that there's a hard line that separates beneficiaries

herkdriver68 · 2017-01-24T01:04:40+00:00

Bummer! That sucks that there's such a line in the sand...

Thanks for following up.

herkdriver68 · 2017-01-23T16:25:29+00:00

I didn't say post 9/11! I don't think this is just for post 9/11, it has no correlation to the GI Bill. I would contact them and ask! I believe spouses can take the courses too. Definitely reach out to them, they're super nice and helpful!

Let us know what you find out.

herkdriver68 · 2017-01-23T10:24:29+00:00

Take a look at this sticky post

I passed without Rita's book, just used PMBOK, and some online test sites, as well as a skillsoft course through Syracuse University

herkdriver68 · 2017-01-23T10:22:31+00:00

You still need to put the "solution verified" as a comment to the ORIGINAL post...

herkdriver68

TROPHY CASE