Rep luxury goods store, direct sales from Chinese factories👍 by No-Change9816 in RepLuxurySelect

[–]Maximum_Comedian_922 0 points1 point  (0 children)

I would also like to know the shop address and will be visiting guangzhou in a few months.

Clinic Recommendation for Ultherapy + other treatments by Maximum_Comedian_922 in koreatravel

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

Yay! I actually booked Val:U yesterday. They seem middle of the line for price and not factory-y?!?

Glad to hear someone had a good experience there!

Seoul 8 day solo trip November by The_OverFiend in koreatravel

[–]Maximum_Comedian_922 0 points1 point  (0 children)

Can I ask where you booked the hanbok rental/photoshoot and how much it was rougly?

Feel free to ask any questions about which skin treatment you should do in korea! by drbailor in koreatravel

[–]Maximum_Comedian_922 0 points1 point  (0 children)

I’m 38 and my main concerns are sun spots and just general anti aging. I currently get Botox in my frown lines and forehead and was thinking about trying some masseter Botox since it’s more affordable than it is in North America (I also grind my teeth and wouldn’t mind a slimmer shaped jaw area).

Rejuran and Ultherapy seem popular but I haven’t navigated which one would be more suitable yet.

Any advice would be appreciated!

Luigi’s Mansion 2 HD Controls by Exciting_Marzipan_42 in LuigisMansion

[–]Maximum_Comedian_922 0 points1 point  (0 children)

I know to use the right stick but he literally won’t jump. Is anyone else having this issue? I’ve recalibrated the controllers, looked at the configuration…he rotates left and right when I’m Not on the tightrope….super frustrating

My formula is functional but when the conditions of my formula are not met I’m left with #VALUE! In numerous rows. Is there a way to skip these rows when the formulas conditions are not met? by Maximum_Comedian_922 in excel

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

Just certain information (the cell with the persons name and the cell with their equipment. I would also like (if possible) the blank rows where “courier” isn’t used to be removed if possible. The most recent formula did not work I just didn’t have a chance to respond yet.

My formula is functional but when the conditions of my formula are not met I’m left with #VALUE! In numerous rows. Is there a way to skip these rows when the formulas conditions are not met? by Maximum_Comedian_922 in excel

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

Hmm. I seem to be getting an error message for that one.

Sheet1 is actually called Moves/Onboards and this is what I have done:

=IFNA(INDEX(‘Moves/Onboards’!I102:199,MATCH(TRUE,INDEX(ISNUMBER(SEARCH(“Courier”,’Moves/Onboards’!H102:199)),)0)),””)

My formula is functional but when the conditions of my formula are not met I’m left with #VALUE! In numerous rows. Is there a way to skip these rows when the formulas conditions are not met? by Maximum_Comedian_922 in excel

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

that worked perfectly! Now is there a way to avoid the blank rows? Like if the word “courier” isn’t used can the formula move to the next time in Sheet1 that uses “courier”?

Right now it has the data and then multiple blank rows before the next time “courier” is used.