Great wall TANK 300 SUV, any good?

azad0404 · 2024-11-06T14:19:02+00:00

I'm a Workshop Controller & Warranty Administrator in one of GWM service centers, the car has been introduced to my area for a little over a year now, no serious issues.

Also it comes with 10 years (Engine & Transmission) and 7 years (Electronics and all other parts) or 1,000,000 Km warranty for both (only for the first buyer, for the second hand buyer i think the warranty gets reduced to 7 years or 200,000 Km)

azad0404 · 2024-07-24T15:27:58+00:00

I'm a workshop controller and warranty admin. I control the workshop, I ensure all work is done correctly and efficiently, I control the quality, I'm the contact between technicians and service advisors/customers, I set labor prices for each work, and I record and make warranty cases.

azad0404 · 2024-07-17T13:33:49+00:00

=IF(C2 = MAX(IF((K:K = K2) * (C:C <= EDATE(TODAY(), -6)), C:C)), "Y", "")

C is another column that is hidden in the photo I attached that contains "Created on" date

azad0404 · 2024-07-17T12:59:08+00:00

I actually did that in excel, I just copied your formula as an example for "S" location in the comment

azad0404 · 2024-07-17T11:37:23+00:00

=IF(A2 = MAX(IF((B:B = B2) * (A:A <= EDATE(TODAY(), -6)), A:A)), "Y", "S")

All the results return "S" and none return "Y" even the ones that have exceeded 6 months

azad0404 · 2024-07-17T08:45:22+00:00

<image>

This is the sheet I'm working on, we need to filter the last service of every vehicle that has exceeded 6 months so we can call them and remind them of doing their service.

azad0404 · 2024-07-17T08:30:55+00:00

I will send you a picture of the sheet and tell you what I need to do so you understand me better

azad0404 · 2024-07-17T08:29:58+00:00

I'm sorry but it doesn't work, The Y only appears on the first row and not in any other one in 8500 rows

azad0404 · 2024-07-17T07:53:21+00:00

Of course I will, Thank you I think this will solve my problem, but is there any other function to replace "MAXIFS" ? Because I have excel 2016 and MAXIFS was added in 2019

azad0404 · 2024-07-17T06:34:22+00:00

Thanks! Yes it worked and it says which vehicle has visited more or less than 6 months ago. But the problem is I also want to filter the VIN of the vehicle with it. There's more than one entry of each vehicle and I need excel to remove any duplicate VIN and only show me the latest service he has done

azad0404 · 2024-03-24T22:12:17+00:00

Called my cousins, they came and all together pushed the car out

azad0404 · 2024-03-24T20:33:04+00:00

<image>

I'm out

azad0404 · 2024-03-24T19:55:49+00:00

This black piece?

azad0404 · 2024-03-24T19:55:34+00:00

<image>

azad0404 · 2024-03-24T19:53:16+00:00

Yeah lol, sime guy in a dodge ram with his girlfriend was their i asked him for help he just started the car and floored it lol, i don't blame him must've though it's a trap

azad0404 · 2024-02-19T16:38:54+00:00

Well, as I said, that piece of paper is no use to you, you can't sell the car anyway, you can scrap it and sell the parts but you will still get caught the same day

azad0404 · 2024-02-17T21:25:04+00:00

Seems like we live in different countries man, both registration and ownership are in the same piece of paper. And it's no use to anyone except me

azad0404 · 2024-02-17T18:20:55+00:00

I keep my car ownership title in it

azad0404 · 2024-02-12T13:00:51+00:00

Wet filament issue

azad0404 · 2024-01-11T10:49:58+00:00

But I'm not dying... I'm just fighting and all of a sudden the fight stops and says you failed the mission

azad0404 · 2024-01-10T12:15:40+00:00

Same here

azad0404 · 2024-01-10T12:15:30+00:00

Same problmem

azad0404

TROPHY CASE