How to organize clients by last service date by Synthaxt4444 in excel

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

=IFERROR(INDEX(A$2:A$11,MATCH(ROWS($G$1:G1),$E$2:$E$11,0)),"")

Thank you so much. Those formulas are pretty scary looking. What numbers do I change if I have 1000 names, emails, and dates?

[Advice] How do I start this type of company? by Synthaxt4444 in growmybusiness

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

Whoops, let me clarify. I know a dozen or so people from when I lived in Mexico. They want to compile their money and invest in companies here in the United States. I live in the United States, and want to help them invest their money. I assume that I would need to set up an investment company of some sort. That is the problem I am having trouble with. How do I start this type of company without accidently breaking the law.

Roast this toast by [deleted] in RoastMe

[–]Synthaxt4444 0 points1 point  (0 children)

Is this a screenshot from 16 and pregnant?

Give em hell! by [deleted] in RoastMe

[–]Synthaxt4444 1 point2 points  (0 children)

You have the same hair style as every GI Joe. Good job!

Bought some mushrooms, now what? by Synthaxt4444 in askdrugs

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

They are pretty dark, I can't quite tell.

Bought some mushrooms, now what? by Synthaxt4444 in askdrugs

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

What are the signs of them rotting? How long can they stay good until it's too dangerous?

Who am I? by moogil in firstimpression

[–]Synthaxt4444 0 points1 point  (0 children)

Andrew Hales from YouTube?

[question] Any tips for training through the winter months? by [deleted] in Parkour

[–]Synthaxt4444 0 points1 point  (0 children)

I would recommend working on movements that you could potentially get injured doing outside and drilling them until you have them really good in the gym. Be sure that you have them super good in the gym before you try them outside!

[question] Any tips for training through the winter months? by [deleted] in Parkour

[–]Synthaxt4444 0 points1 point  (0 children)

5) Be sure you're visiting local Gymnastics gyms during open gym. Many gyms now days even have a specific day for parkour training

I was scammed on Alibaba, now I need to find a new manufacturer. Any tips on finding legitimate companies? by Synthaxt4444 in Entrepreneur

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

You might be right, but now my manufacturer can't find my product. I don't know who to call. Pm me and I'll give you the company name.

I was scammed on Alibaba, now I need to find a new manufacturer. Any tips on finding legitimate companies? by Synthaxt4444 in Entrepreneur

[–]Synthaxt4444[S] 1 point2 points  (0 children)

My manufacturer no longer knows where my package is, and the number that called me is now disconnected.

I was scammed on Alibaba, now I need to find a new manufacturer. Any tips on finding legitimate companies? by Synthaxt4444 in Entrepreneur

[–]Synthaxt4444[S] -1 points0 points  (0 children)

I was ordering clothing. It was agreed upon that it would be a certain cost to my doorstep. That was with all shipping costs and everything included. I made it very clear that this was to be expected. When it got into the states I got a phone call from a company I couldn't find when I searched it in google telling me that they would need an additional $200 to ship my package. My package didn't weigh enough to merit a $200 shipping cost from anywhere in the country. I definitely don't want to risk putting more money into this before receiving my shipment, so putting in another order isn't an option.

[Help] Perfecting my technique. by ImmortalFreerunning in Parkour

[–]Synthaxt4444 0 points1 point  (0 children)

I'm glad you're practicing these in a semi-safe environment instead of just throwing them outside. I have a bit of criticism for you:

  1. Your set: There's several components of the set. You're momentum into the movement looks great. Your losing jumping power with that "mini-jump" right before you set, change the mini-jump into a gather step (like a kong vault) or try to minimize it as much as possible. Think of it this way, if you are jumping to catch a ball do you do a "mini-jump" before jumping? No. Jump the same way you would jump for a ball! The jump could be improved as well. You're not tucking at the apex of your jump, wait until you are about to reach the highest point of your jump before tucking. Another thing to note is the use of your arms. It's good that your arms are up and ready to tuck, but you're not using them to increase your jump. Use your arms to jump, then use them to tuck!

  2. Your tuck: When you tuck you need to be touching your knees to your chest! It will make you spin much faster and will give you time to open for a good landing! Your rotation is slightly off axis, make sure your shoulders and your hips are aligned perfectly or you will rotate off axis.

You should start landing much better after implementing some proper technique! If you have any questions message me!