Identify New Customers & Returning Customers in Excel

The video offers a short tutorial on how to identify new customers and returning customers in Excel.

[colinshyamalan]

Can you put the formula in description instead?

[singhkishore]

can we add continued every month customer flag so it mark as a continued customer (For Example: X customer in jan (new), feb (continued), mar(continued), may(return), jun (continued).

[diptisharma]

its really help me a lot. Thanks for video. but it would be great if you use your voice.

[emmanuelidonije]

Anyone know what would be the best way to represent this in a chart?

[plakshmi]

Great video, Can you please make one for lost thanks

[plavali_znaem]

The formula worked for me! But I yet don't really understand, how

[Excel_Gimmick_]

dont understand the formula, though it worked

[deepudumbre]

this formula has a limitation - if a customer purchases on the same date it does not count them as a returning customer.

[fuadjinnah]

I find it assuming that Satan is on the customer list above :)

[joystickxd]

It work but i cant understand it formula.

[Xdianaandini]

It worked but I don't understand the logic

[venkatavula]

Sir I need how many days he returned i.e I have huge data then how to find how many days coustomers returning monthly how many time return

[moorejs]

=IF(COUNTIFS($M:$M, "<"&M2, $E:$E, E2), "REPEAT", "NEW")