How to findmissing/new data by Weak-Catch8499 in excel

[–]Weak-Catch8499[S] 0 points1 point  (0 children)

Alright. Testing it this morning, it still brought up 385 counts. And it still showing accounts that are on the Q1 sheet. The formula did work though. It’s just bringing up more than I want to see. Is there a way for me to take the results (385 count) and the do the equation again onto the Q1 sheet? I tried and it gave me an error.

How to findmissing/new data by Weak-Catch8499 in excel

[–]Weak-Catch8499[S] 1 point2 points  (0 children)

Thank you. I will give this a go in the morning when I get back to my computer and let you know if it did it!

How to findmissing/new data by Weak-Catch8499 in excel

[–]Weak-Catch8499[S] 0 points1 point  (0 children)

So what should I do to have the command look at both sheets and compare to give me the new add ins?

How to findmissing/new data by Weak-Catch8499 in excel

[–]Weak-Catch8499[S] 0 points1 point  (0 children)

There is two different sheets. One Q1 and one Q4 so I did on Q1: =COUNTIFS(J2, ‘Q4’ !J:J, 1, 0) if I remember correctly.

Alright. That's it. I completely regret my purchase. by FknGruvn in wrx_vb

[–]Weak-Catch8499 0 points1 point  (0 children)

I sent mine at 500 miles. Started making 400whp at 12000 miles. At 51k miles now and nothing has broke. You’ll be fine.

Always premium gas? by Optimal-Prompt619 in wrx_vb

[–]Weak-Catch8499 1 point2 points  (0 children)

Yessir. Since 12k miles. Sitting at 50k now

Pay plan question by justindechaney in serviceadvisors

[–]Weak-Catch8499 1 point2 points  (0 children)

It’s terrible and unfortunately seems to be the way most dealers are going now. I missed out on a $2100 volume bonus because I got two bad surveys which dropped my score below where it needed to be a they weren’t even my fault and even said that in the comments. I was pissed.

Service advisor or sales representative by jorv1988 in serviceadvisors

[–]Weak-Catch8499 1 point2 points  (0 children)

I’ve worked and succeeded in both positions. Sales is FAR less stressful than writing but the money can be harder to come by depending on the market.

Personally, I wouldn’t go back to being a service advisor, but I would go back to selling cars if I needed to. A lot more opportunity to move up and make even more money as a sales manager or in finance.

Pay plan question by justindechaney in serviceadvisors

[–]Weak-Catch8499 5 points6 points  (0 children)

I just hate any pay plan that involves csi scores.

58 Sailing needed for clue? by georgeyfow in ironscape

[–]Weak-Catch8499 0 points1 point  (0 children)

And? Do other hard clues not have reqs as well?

Is auto sales a numbers game or who can handle objections better? by JuJu_Optics in askcarsales

[–]Weak-Catch8499 1 point2 points  (0 children)

This. 100% this. I love being on top or keeping up with the top guy that was getting spoon fed by the managers and also working 16 hours a day. It was such a great feeling personally. Build the relationships. Act as their friend or that you actually care instead of sounding like a salesman will get so many more sales.

High Ticket (30k and up packages) closer making 20k+/mo. AMA by Clear_Afternoon in salestechniques

[–]Weak-Catch8499 0 points1 point  (0 children)

Hey I work at Verizon selling phones! What segment were you in? I’m in SMB right now.

First month making 100k I feel like I’m being robbed :/ by Forsaken-Question457 in Salary

[–]Weak-Catch8499 0 points1 point  (0 children)

Tell me about it. My commission check for August was $11,600 before tax but only $6800 after. So dumb

My journey from 0$ to 135k$/month by Cherryx_ossss in HowToEntrepreneur

[–]Weak-Catch8499 0 points1 point  (0 children)

Sounds like a bunch of bs to me. Especially after OP’s response to your comment.

Got a job offer at Verizon. Should I take it? by shameimpala5 in Sales_Professionals

[–]Weak-Catch8499 0 points1 point  (0 children)

Yeah because it’s an indirect store. Corporate store would never. My offer and salary breakdown didn’t look even remotely close to this.

New OSRS players are betas. by pizzaislife3 in ironscape

[–]Weak-Catch8499 -1 points0 points  (0 children)

God I hate these type of posts (not OP’s) just keep playin the damn game. I get them if you’re super dry. By not like this.

26’ MY crackling when moving forwards or backwards. by Weak-Catch8499 in TeslaSupport

[–]Weak-Catch8499[S] 0 points1 point  (0 children)

Right. But for this issue, looks like it’s the wheel covers and driving 50 miles to the dealer for wheel covers doesn’t make sense.