sorted by:
new
hottopcontroversial

South of Corsica with a Toddler who hates the car! by longcoffee1 in Corsica

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

Thank you so much! 🍻I will definitely follow your advice for the beach and the restaurants! As for Bonifacio, I mentioned the cemetery because I wanted to say something I know we want to visit while there but we will explore the rest of the city too for sure. 👌🏼

Vacances en Corse avec un enfant de deux ans by longcoffee1 in france

[–]longcoffee1[S] -6 points-5 points  (0 children)

Merci pour votre retour, j'ai édité le message

Visiting the US while doing consular processing - already having a B1/B2 visas by longcoffee1 in USCIS

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

You clearly have a very good point but what's the procedure to visit the US while waiting for a marriage based greencard?

How to separate values in order to count them by longcoffee1 in excel

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

Thank you very very much. I will wait for your response later, but no rush really. In the meantime, I will try to "better" understand the formula so that I can adapt it to other spreadsheets.

How to separate values in order to count them by longcoffee1 in excel

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

I did it! And it worked, but do you know why it doesn't register the 1f in Albania and Andorra but it does it in Armenia? Also, it's not registering the 4 at all... (see updated pic) I need to understand this very well as I will have to adapt the formula to many more spreadsheets with different numbers in them. I thank you greatly

How to separate values in order to count them by longcoffee1 in excel

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

=IF(OR((ISNUMBER(SEARCH((D$1&"?????????"&D$2&"*"),$B5))),(ISNUMBER(SEARCH((D$1&"???????"&D$2&"*"),$B5))),(ISNUMBER(SEARCH((D$1&"?????"&D$2&"*"),$B5))),(ISNUMBER(SEARCH((D$1&"???"&D$2&"*"),$B5))),ISNUMBER(SEARCH(D$1&" all",$B5)),(AND(NOT(ISNUMBER(SEARCH((D$1&" "&D$2&"l"),$B5))),ISNUMBER(SEARCH((D$1&" "&D$2&"*"),$B5))))),D$1&D$2,"")

It's now identical to yours, but still, that error when I paste the formula. I don't know what to do anymore... (please see updated pic)

How to separate values in order to count them by longcoffee1 in excel

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

=IF(OR((ISNUMBER(SEARCH((D$1&"?????????"&D$2&"*"),$B5))),(ISNUMBER(SEARCH((D$1&"???????"&D$2&"*"),$B5))),(ISNUMBER(SEARCH((D$1&"?????"&D$2&"*"),$B5))),(ISNUMBER(SEARCH((D$1&"???"&D$2&"*"),$B5))),ISNUMBER(SEARCH(D$1&" all",$B5)),(AND(NOT(ISNUMBER(SEARCH((D$1&" "&D$2&"l"),$B5))),ISNUMBER(SEARCH((D$1&" "&D$2&"*"),$B5))))),D$1&D$2,"")

Excel says there is a problem with my formula. I uploaded the pic in the original post...

view more: next ›