See likes
See likes given/taken
| Post info | No. of Likes |
|---|---|
Re: Car Insurance Master Thread
I am looking into getting insurance for the first time and had some questions, any help would be greatly appreciate.A lapse of over 30 days is considered a new driver May 02, 2019, 09:53:39 PM |
1 |
Re: Car Insurance Master Thread
Thanks, how can I avoid that? Keep insurance without a car (if that's even possible)? Be added to someone's else's policy?Being added to someone's policy should solve the problem May 03, 2019, 06:13:15 PM |
1 |
Re: National Emerald Club
Right, but I know (from experience) that with hertz its easier to get away with sketchy codes by an airport because those checkout people usually just confirm your ID. So I was wondering if it's the same at national/enterprise?My friend just got blacklisted for doing this. June 28, 2019, 12:38:20 PM |
1 |
Re: Excel Help and Problems
I'm trying to do a find and replace, but I only want to find the word in a specific format (color and shading) but when i try find format from cell it comes back with no results. Any ideas why this is?are you using conditional formatting September 15, 2019, 12:29:04 PM |
1 |
Re: Excel Help and Problems
I'm trying to do a find and replace, but I only want to find the word in a specific format (color and shading) but when i try find format from cell it comes back with no results. Any ideas why this is?How do you know that you have the exact shade? September 15, 2019, 12:49:31 PM |
1 |
Re: Excel Help and Problems
That's why I'm using find format from cell, shouldn't it match it exactly?You copied it from another file, so how do you know that the color you are selecting on the find/replace is the same color as on the sheet. Maybe the sheet is a custom color etc. September 15, 2019, 12:54:29 PM |
1 |
Re: Used Cars Master Thread
not sure if this is the right place, but I'm looking to buy a used car, and looking through craigslist there are a lot of cars that seem very legit but are significantly underpriced, is there a way of knowing when its too good to be true and when its just a guy looking to sell his car?What's an example URL of a listing that looks underpriced. Before they implemented the 5$ post thingy, the listings that looked like they were screenshots of pictures all looked fishy to me. September 27, 2019, 03:00:32 PM |
1 |
Re: Used Cars Master Thread
https://newyork.craigslist.org/brk/cto/d/brooklyn-2012-honda-civic-running/6987398275.html Looks too generic, and I'm generally suspicious of any seller that doesn't post a picture of the odometer with the stated mileage.... September 27, 2019, 03:24:28 PM |
1 |
Re: Used Cars Master Thread
https://newyork.craigslist.org/brk/cto/d/brooklyn-2012-honda-civic-running/6987398275.htmlYes those were the type of listings i saw. Although it seems they upped the picture quality and no duplicates. Always pictures on grass or in front of fancy houses. I don't know what their scam is but there's 0% chance that's a real listing based on that price. September 27, 2019, 03:38:27 PM |
1 |
Re: Used Cars Master Thread
so not even worth it to follow up at all IYO?It can't hurt as long as no money whatsoever is spent. Although I guess don't even call up with your main number/email. They might only be going after just basic contact info of people. September 27, 2019, 03:54:32 PM |
1 |
Re: Used Cars Master Thread
https://newyork.craigslist.org/brk/cto/d/brooklyn-2012-honda-civic-running/6987398275.htmlSeems way too cheap for me. September 27, 2019, 04:02:37 PM |
1 |
Re: Used Cars Master Thread
right, so assuming I see the car and the mileage, etc is real, is there anything else to worry about? stolen? very hidden flaws?You'll likely never see the car. They're probably scammers looking for people who will send them money to order the car. Not too long ago I tried replying to one of these ads to see what would happen (fake name, address, and throwaway email). Here are the emails that we traded, and screenshots of the very-ligit looking email that I got from 'Ebay'. Yehudaa: Hi. I'm very interested in your Rav4. Please send me more info, and please let me know when I can come test drive the car. Thanks! Patricia Davis: Hi there, thank you for your interest in buying my SUV. My 2013 Toyota Rav4 LE 4WD has 82,360 Kms, with a 2.5L I4 cylinders engine, automatic transmission. It is in perfect condition, no need for additional repairs,no scratches, dings or rust. The vehicle looks great. It runs like new and all services are up to date. Also, I need to mention that it was never involved in any accidents. The value is CAD $3,500. It belonged to my husband but he passed away(had a heart attack) so I decided to sell it because to be honest, it's only gathering dust in my garage.I just moved with my daughter in Saskatoon SK so I took the vehicle with me and gave it to eBay to handle the deal.The vehicle is at the shipping company, sealed and ready for delivery. It's quite hard for me to sell it in person because I'm 61 yo and age gets you eventually. But with eBay you'll get 5 days for inspection and if you're interested in purchasing it, send me your full name, shipping address and phone # so I can have them to send you an invoice, meaning more details about how they work. Also you are not obligated to buy it, no pressure...I've attached more pictures! Yehudaa: Hi Patricia. I'm so sorry to hear about your husband! Let's go ahead with this deal. My full legal name is (fake name). Shipping address is (fake address). Please let me know to pay for it and when it will be delivered. Thanks! Patricia Davis: Hello, I apologize for my delayed response but I am very busy with my work,I have received your complete delivery details and right now I will forward the information to eBay. They will send you the invoice shortly and you will receive it by email with all the instructions and details. Please get back after you receive the invoice from them so we can complete our deal. Thank you! Patricia Davis: I just got an email from eBay saying that they have sent you the invoice with all details you need in order to complete this deal. Please check your messages and let me know if you got it. Also,on the payment notification you will find their phone number where you can call and get more info from their operators. I will wait for your reply. September 27, 2019, 04:09:29 PM |
1 |
Re: Craigslist
cross-posting because this seems like a good place Always take it by a mechanic of YOUR choice, if seller doesn't agree run away. Always check CARFAX by your own, or that you see that's it's running it from the real carfax website, don't trust a paper Carfax preprint from the seller. And of course the first rule as always is : "if it's to good to be true" run away. Good luck. September 27, 2019, 04:42:53 PM |
1 |
Re: Excel Help and Problems
what kind of formula would I need if I want conditions of multiple columns to add to a total? for example, if column A is more than 10 add 1 to the total, and if its less than 5 subtract 1 from the total.This is a simple nested IF. Like (if the total is on column F...) Code: [Select] =IF(A1>10,F1+1,IF(A1<5,F1-1,"NOT DEFINED"))
October 25, 2019, 12:08:20 AM |
1 |
Re: Excel Help and Problems
thanks, but I tried using that but it's not working, I think because once a nestled IF reaches a "true" it stops reading so it never reaches the next column. (unless I'm mistaken)Do you need something like? Code: [Select] =SUM(IF(A1>10,A1+1,IF(A1<5,A1-1,"NOT DEFINED")),(IF(B1>10,B1+1,IF(B1<5,B1-1,"NOT DEFINED"))),(IF(C1>10,C1+1,IF(C1<5,C1-1,"NOT DEFINED"))))
October 25, 2019, 12:55:18 AM |
1 |
Re: Excel Help and Problems
It does, but I removed the reference to the cell by the "value if true" because I want the total in the new column (where I putting the code), does that make sense?If it's between 5 and 10, you'll want to refer to the column from where it should copy the number in that case. October 25, 2019, 07:57:58 AM |
1 |
Re: Excel Help and Problems
It does, but I removed the reference to the cell by the "value if true" because I want the total in the new column (where I putting the code), does that make sense?Like this? Code: [Select] =SUM(IF(A1>10,1,IF(A1<5,-1,0)),(IF(B1>10,1,IF(B1<5,-1,0))),(IF(C1>10,1,IF(C1<5,-1,0))))
October 25, 2019, 11:29:29 AM |
1 |
|
DEWALT 20-Volt Max 2-Tool Power Tool Combo Kit $79 pickup only
https://www.lowes.com/pd/DEWALT-20-Volt-Max-2-Tool-Power-Tool-Combo-Kit-with-Soft-Case-2-Batteries-Included-and-Charger-Included/3441524
November 04, 2019, 12:13:22 PM |
1 |
|
Re: microsoft mailmerge help
You can try making a second row in your table with all the same info but the other email address
January 06, 2020, 05:27:26 PM |
1 |
|
Re: microsoft mailmerge help
looks like you need to separate the addresses with a comma and a space https://support.yet-another-mail-merge.com/hc/en-us/articles/212124585-Send-email-to-multiple-recipients-at-the-same-time Can you try that? January 06, 2020, 11:39:18 PM |
1 |
Re: Stimulus Checks
I entered my bank info for DD, but I got this now... 
May 02, 2020, 10:53:12 PM |
1 |
|
Re: DansDeals SMS Alerts (DDF Beta Testing)
The post on DDMS regarding DDMS notifications should probably also include the GroupMe app push notification option for the (large amount of) DDMS readers with smartphones but with a filter that doesn’t allow Telegram.
May 08, 2020, 12:38:27 PM |
1 |
|
Re: t-mobile Wifi calling on non t-mobile phones
To start, what device are you trying to get it to work on? Wi-Fi calling is not necessarily supported on every phone carrier. Also in general , if you want to make a call over Wi-Fi you can use Google voice to accomplish the same thing. May 13, 2020, 08:55:46 PM |
1 |
Re: t-mobile Wifi calling on non t-mobile phones
LG v30 (from sprint) Right, it seems like that is the problem That is a good idea, thanksYour welcome. Just curious is there an app Wi-Fi calling installed on the phone? Or built into the phone settings? May 13, 2020, 10:06:11 PM |
1 |
Re: t-mobile Wifi calling on non t-mobile phones
Only using the built-in settings, is there an app for it?Well for the phones that don't have it usually there's an app. May 14, 2020, 04:53:13 AM |
1 |
Re: RV/Motorhome/Camper Master Thread
is it wishful thinking to try to get a good rate for a one-way rental during august?Not at all. Though it does depend what region you're thinking of, and from where to where. I don't know though if/how the pandemic affects this. Does anyone have experience?I did it and am hoping to do it again. May 19, 2020, 10:28:53 PM |
1 |
Re: RV/Motorhome/Camper Master Thread
is it wishful thinking to try to get a good rate for a one-way rental during august? Does anyone have experience?How far is the one-way? Do you plan to do a route that many people do in both directions? You may get a good rate on the rental itself, but one-way fees could be quite expensive. Also, are you prepared to disinfect all surfaces? May 20, 2020, 04:45:14 AM |
1 |
Re: Uber Eats
this is the most racist thing i have seenIt's called affirmative action and it's been around longer than you. June 04, 2020, 09:22:15 PM |
1 |
|
Re: Interesting Articles...
https://www.texasmonthly.com/articles/it-was-never-enough/
August 30, 2020, 10:52:08 PM |
1 |
|
Re: Sukkah rental
You can honestly just put together a cheap and easy one yourself - see here https://www.diysukkah.welearntogether.org/
September 02, 2020, 03:38:39 PM |
1 |
Re: Sukkah rental
anyone have any experience with renting a sukkah in Brooklyn?I'm pretty sure there are gemachs that give out used sukkahs for free in brooklyn and will take them back when you no longer need them. September 02, 2020, 08:26:51 PM |
1 |
Re: Sukkah rental
You can honestly just put together a cheap and easy one yourself - see here https://www.diysukkah.welearntogether.org/If you don't have storage space and/or you don't plan on living there long term it may not be worth it. September 02, 2020, 08:28:49 PM |
1 |
Re: Chase sapphire preferred 80,000 UR sign up bonus
Is there any risk of an A/A if I downgrade my preferred and get a new one a few days later? I've had it for about 4 years.No risk just wait a week after downgrade for system to update before applying September 16, 2020, 01:07:07 AM |
1 |
Re: Chase sapphire preferred 80,000 UR sign up bonus
Is there any risk of an A/A if I downgrade my preferred and get a new one a few days later? I've had it for about 4 yearsNever had issue. Just wait a few days in between September 16, 2020, 11:19:03 AM |
1 |
Re: Chase Sapphire Reserve
Where can I find the date that the SUB posted? Is it just the closing date of the statement it's listed on?I would assume so being that you only get the points when the statement closes. September 16, 2020, 12:18:16 PM |
1 |
Re: Chase Sapphire Reserve
Where can I find the date that the SUB posted? Is it just the closing date of the statement it's listed on?Correct. September 16, 2020, 12:54:28 PM |
1 |
|
Re: Re: Crown Heights as a COVID-19 lab
and here's me thinking that antibodies were in reshimos
November 04, 2020, 11:44:59 AM |
1 |
|
If Trump could tweet
I won this impeachment, by a lot! The most EVER for an impeached president! Wild Bill got 223, King Andy a pathetic 127. We won a record-breaking 232 Legal Votes in the House! My impeachments getting bigger, better, stronger!
January 13, 2021, 08:24:09 PM |
1 |
Re: South Florida Master Thread
How does it work in general to rent a car from Mia and return to FLL? Do they make a big deal about it?Price it out. It’s an option on every car rental site . Usually extra cost but sometimes it’s actually cheaper. January 13, 2021, 10:07:39 PM |
1 |
Re: South Florida Master Thread
ThanksProbably January 13, 2021, 10:53:23 PM |
1 |
|
Re: South Florida Master Thread
It depends on the car rental policy, some places charge extra for a one way rental and some not...
January 13, 2021, 11:42:11 PM |
1 |
Re: South Florida Master Thread
Thanksyou can end up with a very hefty fee. Don't do this without calling to adjust your contract first. January 14, 2021, 12:22:02 PM |
1 |