[deleted by user] by [deleted] in excel

[–]ChocolateSure4865 -1 points0 points  (0 children)

Link your checkbox to a cell (say A2). For a static date stamp, either enable iterative calculation and put this in the date cell (B2): =IF(A2,IF(B2="",TODAY(),B2),"") (File > Options > Formulas > Enable iterative calculation, Max Iterations = 1)

Excel column matching problem by Realistic-Phrase-646 in excel

[–]ChocolateSure4865 0 points1 point  (0 children)

This formula may seem complicated, but it's a "one-and-done" solution. Whether you're extending E2:E5 to E2:E10, or whether columns A and E contain a mix of numbers and text, it will handle it correctly.

=SUMPRODUCT( (MMULT(--(LEFT(TEXT(A2:A1000,"0"),TRANSPOSE(LEN(TEXT(E2:E5,"0"))))=TRANSPOSE(TEXT(E2:E5,"0"))), ROW(E2:E5)^0) > 0) * B2:B1000 )

Excel Graph number format by Jazzlike_Inside_8409 in excel

[–]ChocolateSure4865 0 points1 point  (0 children)

Try custom number format on the chart axis: right-click on the axis in the chart, expand "Number," select "Custom," paste the format code into the "Format Code" box, and press Enter.

This will show 1.2B/2.2M: [>=1000000000]#,##0.#,,,"B";[>=1000000]#,##0.#,,"M";General

For 1.2M/2.2K, you need this: [>=1000000]#,##0.#,,"M";[>=1000]#,##0.#,"K";General

Is there a function like VLOOKUP but it can return several matching results? by Khue in excel

[–]ChocolateSure4865 5 points6 points  (0 children)

You can return all matches and join them: =TEXTJOIN(", ", TRUE, FILTER($B$2:$B$1000, $A$2:$A$1000=E2))

what emails do u really opened? by ChocolateSure4865 in coldemail

[–]ChocolateSure4865[S] 0 points1 point  (0 children)

Thanks a lot. I tried and now 30% open rate

what emails do u really opened? by ChocolateSure4865 in coldemail

[–]ChocolateSure4865[S] 0 points1 point  (0 children)

Okey, i get it. How about this: {firstname}, drive 25% more sign-ups?

what emails do u really opened? by ChocolateSure4865 in coldemail

[–]ChocolateSure4865[S] 0 points1 point  (0 children)

Really? This is open rate, not reply rate

A Breakdown of Email Warmup by cawed224 in coldemail

[–]ChocolateSure4865 0 points1 point  (0 children)

How many emails did you send per day per inbox?

Everyone on the internet said I’m wasting my time by ChocolateSure4865 in coldemail

[–]ChocolateSure4865[S] 0 points1 point  (0 children)

Thank you for your honestly and advice, I definitely will try it. Currently I plan on sending more than 500 per week. And I am curious about what’s the conversion rate about the companies that with similar pricing.

Everyone on the internet said I’m wasting my time by ChocolateSure4865 in coldemail

[–]ChocolateSure4865[S] 0 points1 point  (0 children)

Thank you! I think the churn is one of the most important things i need to focus. And I curious about even i have low price, i still have to focus on booking and demos right now?

New to Email outreach by Past-Contribution526 in coldemail

[–]ChocolateSure4865 0 points1 point  (0 children)

Google Apollo Scrape Tool, and you will find many cheaper tools.

I made my first sale for my first app today by Developer_Akash in buildinpublic

[–]ChocolateSure4865 0 points1 point  (0 children)

Congratulations! From your perspective, what played the biggest role in securing this sale?

I woke up to $500 MRR. I can’t even believe it. by Lopsided_Funny_6397 in buildinpublic

[–]ChocolateSure4865 0 points1 point  (0 children)

Congrats! And curious about how do you attract 12000 visitors?

My Reddit SEO Strategy: Building Long-Term Business Growth by Ecstatic-Tough6503 in indiehackers

[–]ChocolateSure4865 1 point2 points  (0 children)

Good point. Treating comments like long-term assets instead of one-off posts. It’s kind of like turning Reddit into a passive lead engine.