Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 1137 points

luckyspec

Favourite answers14%
Answers14
  • Excel Formula for max repeated number?

    I created a spreadsheet where I have 1000 cells randomize a number output of -1 or x. Where X is determined by an input and is greater than 0. All the cells will either display -1 or x, and are all random, so I could have -1, x, -1,-1, x,x,x, etc.

    My question is how to determine the longest string of -1's repeated, or longest string of x's repeated. I can scroll through the list of course, but that is inefficient and I could miss something. Is there a formula that can tell me the maximum series of -1's next to each other?

    1 AnswerSoftware2 weeks ago
  • The dreadful grandmother?

    So, my gf and I had a baby this January, and we're living at her parents. We were kicked out of my mothers, because she was quite a treat to live with. Basically...we were supposed to go back to live at our own place, which I'm still paying for since December, but not living in. My gf keeps getting attacked by her mother, so am I. We were planning on going back together, and she told me so, but 4 days before that, yesterday, says she's staying because he needs a therapist that he's seen twice here, and this and that. It was the same 2 weeks ago, when I said I'm leaving, then she said no, stay I'll move his appointments and fly back here, and now this. Another reason why she can't go. I don't know what to do...I have friends saying, I should just take our son. I have friends saying I should try to get a job out here. I can't see myself doing either, even though he is my son, it won't go over well with me trying to take him and all of her family including her will stand in the way. Oh and she says she's confused. Her mom is a manipulator and abusive. I am at a loss for what to do. I have a place I'm paying for, and her mom says you shouldn't have got it. My gf is also upset about the loss of the twin due to stress at my mothers. I'm at my wits end, can't figure out what to do, and now might not see either of them for months, and I really can't stay here another week. Her mom keeps taking over watching him, which my gf says she needs help.

    2 AnswersFamily2 weeks ago
  • I was supposed to receive a cashiers check, and now the bank/purchaser is asking me to sign a hold harmless agreement.?

    I have not received the cashiers check. I asked the purchaser of the check to re issue the check, as the one they say they sent to me, never got here. Now they and the bank are asking me to sign a Hold Harmless Agreement. I do not understand why I have to sign this...

    1 AnswerLaw & Ethics3 weeks ago
  • We have found out from a mold report, toxic levels exist, what's next?

    We have sent the landlord our report from a mold inspector showing toxic levels of aspergillus and stachybotrys. Michigan. What is next that we should do, and expect? I know we must leave asap, but what steps are necessary regarding the landlord. Also what obligation do we have to them? Lastly what can we ask for back, monetarily, other than the security deposit? (We have asked for that). We have lived her approximately 2.5 months.

    6 AnswersRenting & Real Estate8 months ago
  • Is it legal for a landlord to have their mail delivered to a house they're renting out?

    We are leasing a house for 1 year term. The owner's mail keeps coming here, and we've asked the management company what to do, and they've said write "RTS" and leave it in mailbox. The mail person, does not pick it up, we've even written 'Return to Sender', and still they do not do so.

    11 AnswersRenting & Real Estate8 months ago
  • Port forwarding...I've done this and it worked but now it stopped working...why?

    I set up port forwarding and had my server running for a few days, so I know I did it right. But now all of a sudden it stopped working. After some time of digging up answers, I went into my netgear gateway, and looked at the forwarded port and it was gone. I redid it again...and then tried to run the game(fortresscraft) and it didn't work.

    www.openportchecktool.com says no route to host...what gives?

    1 AnswerOther - Computers5 years ago
  • What should I do about a room that is being flooded?

    I have a high water table, and when it rains...this room that is near the back of my house, gets flooded. I'm not sure how much it has to rain, but generally a good amount. The last few days it rained all the time, about 3 days in a row, and the room which is about 5x5 got something like 3 inches of water in it. It is lower then the rest of my house.

    Should I fill it with cement to raise it and will this fix the problem? or will it make it worse?

    3 AnswersMaintenance & Repairs5 years ago
  • Attachment image

    Hi, Just got video card for pc, and this weird image comes up, please help?

    During boot screen, the very first thing I see is the image here. All else seems to run fine, i played witcher 3 and it runs at about 30 fps and gta V also. The card seems to work ok, I had a bit of trouble getting the card into the case to install it as it's about 13 inches, so I had to use a little force...I know bad. Also the card was 'open box' purchase, so someone else had it first and returned it. Thoughts?

    2 AnswersDesktops6 years ago
  • Attachment image

    I have a stream behind my house and it floods up to my house ever time it rains..help?

    I've had this house for a few years and it keeps getting worse. The stream is about 20 feet from my house, and it floods toward it. Then the water sits there for days and days until it rains yet again and again. I can't even mow it anymore. I used to be able to. I thought about a french drain. Just not sure if I should do that or something else and who is responsible for it...me or the state, or city? The stream is considered state property I hear so I wonder if the state is responsible for helping me fix this problem? I can't prove this, but I heard that the stream was blocked up by a neighbor further down the stream.

    5 AnswersGarden & Landscape6 years ago
  • Trying to unclog a bathtub drain...?

    I watched youtube videos and tried using a plunger while plugging the top portion of the drain. I also have a little hand snake that I tried. Some of the hair did come out of the drain, but it is still slow, and when I try using the snake from either the bottom or the top of the drain, nothing comes out. I've done it last year and it worked, not sure why it's not working now, or if I did something different...help?

    2 AnswersDo It Yourself (DIY)7 years ago
  • I reinstalled windows 7 on a laptop, and can't get wifi to work?

    I installed windows 7 and everything seems fine, except my wifi doesn't work. I went to acer website and installed the Wireless LAN driver...there are 4 different selections. I didn't know which one, so I installed one and nothing, then another and another... Until I got all 4 and no wifi. Help plz

    4 AnswersLaptops & Notebooks7 years ago
  • Dating life...retaining power after rejection?

    You know this chic for a year...things are friendly most of that time, but heat up...Say..you've been doing good, and the girl...you got her, and things were fine for a while, but then she throws down the...lets be friends bull. You think to yourself...mixed signals right? Cuz she made sexual passes and all the good stuff, flirting on and on. What gives. Do you...get angry? Cuz I did, it pissed me off that she'd be playing this game. Or do you suck it up and be like Mike and wait it out, be cool and think she's just testing the *** out of you. But is the power loss too severe to recover after getting mad at her and saying stupid **** about it, and making her almost cry who knows...maybe she did cry. I do feel like a little biatch right now tho for doin it, but i'm over analyzing everything. Look, we're alright, but not alright...

    You can feel the tension when it's there, but right now it's like this bullshit cloud looming over head and I put way too many eggs in this basket in the first place. I know I know. Just help me out, this girl is fine right, but she doesn't think so. Whatever, that ain't important. What would you do now in this situation. Cuz I certainly don't want to bring it up and make it worse by beating a dead bush, but i do feel the power loss. Tell me oh wise ones.

    2 AnswersSingles & Dating7 years ago
  • I just woke up from a weird dream...of a curse...?

    I remember lots of people, maybe 30 of us...I didn't know anyone, but it seemed we knew each other somehow, maybe just because we were all in the same predicament. We were all in a building, or in a courtyard surrounded by a building. I remember death. There was incidents where someone would get hurt, or die or both. Less and less people would remain.

    I remember being in another place, maybe we went to some other giant building. We were together, walking in a hall...a giant hall. Strange things happened...most of which I don't remember upon waking. But I remember this: I turned around and saw a lady about 40 feet in the air hanging on a rope, spinning on a ceiling fan getting choked to death. She then cut herself loose somehow, falling the distance...and saying...in a low voice...Rasgul...we need to call on the curse eater. I could be wrong about the name..I am confused about it actually upon waking up. Because that name sounds like some character from a movie I saw a very long long time ago. But I do remember that if it came it would devour any demons in the place...that it would eat away at them. There was a danger though, it could destroy us as well. We had to stay together.

    I remember one companion, tying rope on my pants loop in the back. I didn't even know they did it, it was held by one and another person, as if I was to escape them. I untied it. I was angry and yelled at the man for doing this, and violently asked him why. I didn't get an answer. What is this all?

    1 AnswerDream Interpretation7 years ago
  • I have a sailboat and want to find a marina on Lake Huron that is inexpensive any suggestions?

    I would prefer it to be closer to Detroit as I live near. I have a 27' hunter sail. 4'3" draft. I called some places like Lexington(2k per season), and Sanilac(1988$ per year), and even Port Huron(2100$). Bay city is offering half off, of 1500 + storage. That is the cheapest I've heard so far. Is there anywhere else that would be inexpensive? I was told St. Clair shores might be not deep enough and crowded plus I don't know about prices. Please advise :)

    2 AnswersBoats & Boating7 years ago
  • Co-worker called me ...I was late..she didn't hang up and said something rude without realizing that she had not hung up...?

    She called this morning 7/1/2014 at about 7:10 am EST. I immediately woke up as my alarm didn't wake me and rushed off for work without being able to answer or call her back since my house phone was not charged. My answering machine was charged though which is how I heard the msg. Later in the evening after work, I found out that she didn't hang up the phone after she said I'm late. She must have thought she did, because on the message you can hear 'A##hole' at the end.

    Any advice about what to do...or not do, in this situation.

    Clearly it was my fault that I was late. But that can be dealt by other means. What would you do?

    6 AnswersEtiquette7 years ago
  • I got glasses online but they make me see things weirdly...why?

    I got a prescription at an optometrist and went on coastal to buy glasses. I had to find out the PD number for them too, so I went back to the doctor. I ordered the glasses online and received them but something is wrong. I can see things clearly, but when i move ...walk, or turn my head, I ..can't even explain it right...I feel weird?

    I wore glasses before and I don't remember them making me feel like this. I don't feel dizzy or something...just something is off. Is it the PD? I don't think it's the prescription of the actual lenses...I was told that hasn't changed from my old prescription 2 years ago.

    1 AnswerOptical7 years ago
  • I dreamt I was squatting in a house that I was going to buy.?

    I recently met someone online, and we simply started talking...

    She then said she was very into Carl Jung. So as I was falling asleep I was listening to something about him...one thing I recall as I then turned off the video was that Reincarnation was part of Maya...or an illusion.

    I then fell asleep and had a dream I was a squatter in some house.

    When I tried making phone calls, it would not let me, and some man called back saying I am supposed to dial some extension. Also, this lady, who was a realtor, was trying to sell me this house and was walking me through it. I remember trying to call my mother to come see it. The house was owned, and I feel intuitively about this...by the girl I am now talking to. I tried to interpret this, and could not. Also, my mother did show up and we walked the house with her, as the realtor was showing. The walls had no paint...were looking like they need to be done, but not the dry wall, just the paint part.

    1 AnswerDream Interpretation7 years ago
  • I dreamt I was squatting in a house that I was going to buy.?

    I recently met someone online, and we simply started talking...

    She then said she was very into Carl Jung. So as I was falling asleep I was listening to something about him...one thing I recall as I then turned off the video was that Reincarnation was part of Maya...or an illusion.

    I then fell asleep and had a dream I was a squatter in some house.

    When I tried making phone calls, it would not let me, and some man called back saying I am supposed to dial some extension. Also, this lady, who was a realtor, was trying to sell me this house and was walking me through it. I remember trying to call my mother to come see it. The house was owned, and I feel intuitively about this...by the girl I am now talking to. I tried to interpret this, and could not. Also, my mother did show up and we walked the house with her, as the realtor was showing. The walls had no paint...were looking like they need to be done, but not the dry wall, just the paint part.

    2 AnswersRenting & Real Estate7 years ago