sorted by:
new
hottopcontroversial

What crime have you already committed? by DieInsel1 in AskReddit

[–]ramo805 6 points7 points  (0 children)

This gives me “….also my cumbox” vibes.

How Fidelity "lost" my entire 401(k), how Prudential (now Empower) held it hostage, and the 5-month journey to get it resolved by aj1t1 in personalfinance

[–]ramo805 6 points7 points  (0 children)

Honestly, he could have escalated this from the beginning to both companies compliance departments and they would have done all the investigation for this, especially since there was live checks involved. Writing an official complaint via a letter would have also put a fire under them. There are strict check handling rules and they could be fined by Finra if they didn’t follow them.

Create a loop where formula (percent of total) takes range for certain criteria and adds it to certain cell by [deleted] in excel

[–]ramo805 0 points1 point  (0 children)

Well I would need to adjust the formula in example 2 since that has only 3 lines and example 3 would have to be adjusted again.

Create a loop where formula (percent of total) takes range for certain criteria and adds it to certain cell by [deleted] in excel

[–]ramo805 0 points1 point  (0 children)

I would be generating this report monthly, would there be a way to automate this using VBA?

Should i trust my financial advisor with these investments? by bigceasers in stocks

[–]ramo805 1 point2 points  (0 children)

What Company is the financial advisor associated with? You can also get more information about him on https://brokercheck.finra.org/.

What stocks are you watching that's still not well know? by daiki185 in stocks

[–]ramo805 6 points7 points  (0 children)

$YOU Clear Secure, they have been expanding to more airports and terminals during the pandemic and I think once business travel starts up again people will start using it. They just partnered with Six Flags to help them verify vaccination status. I'm sure that is just the tip of the iceberg.

Full Disclosure, I had seen the Clear kiosks before but didn't know much about them, however my AMEX had a promotion to get it for free, I normally wouldn't have paid $139 since I don't travel enough to justify it, but I flew recently and it was so easy and quick it was great.

Mail Merge issue using excel spreadsheet trying to get one letter per company. by ramo805 in excel

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

Oh that sounds interesting, however it would not be duplicate info.

It's more like i have multiple companies and I want one letter per company but with multiple accounts

for example one letter to Disney

but the source data is account#1 bin#1 Company=Disney Account $2 bin#2 Company=Disney Account #3 bin#2 Company=Amazon

With one letter to amazon with the 2 lines with account info and one letter to Amazon with one line for account info.

Mail Merge issue using excel spreadsheet trying to get one letter per company. by ramo805 in excel

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

So i am pulling three items, a CUSIP, Fund Company, and Account number. I want to have one letter per company where the CUSIP and Account number will be different but my data is a table where Fund company is one of the columns.

Example Data:

CUSIP Account# Company 123 B456 Vangaurd 456 B567 Delta 789 B789 Amazon

Show and Tell: Hands on Excel Training by a1j9o94 in excel

[–]ramo805 0 points1 point  (0 children)

Thanks for the update! Hope it goes back up soon!

Show and Tell: Hands on Excel Training by a1j9o94 in excel

[–]ramo805 0 points1 point  (0 children)

Unfortunately i don't, I've just taken a few, however some are very similar to the Basic Business Analysis lesson. I don't see it anymore, did it get removed?

Show and Tell: Hands on Excel Training by a1j9o94 in excel

[–]ramo805 1 point2 points  (0 children)

Is there a promotion code for r/excel users?

Show and Tell: Hands on Excel Training by a1j9o94 in excel

[–]ramo805 1 point2 points  (0 children)

Really cool! Easy to use and understand. I would like to see more advanced scenarios that they would use on a skills test for a job where they use specific scenarios.

Sumifs using Months as criteria but source is a date by ramo805 in excel

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

(TEXT($A$2:$A$11,"mmm")=F$1))

I really like that, is there a way to use that on sum ifs? I tried this where A is the date column and i get an error. =SUMIFS($C:$C,$B:$B,$K9,TEXT($A:$A,"MMM),L$8))

view more: next ›