Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Taking FAR soon! Currently reviewing the book and wanted to see if y’all had any advice on what modules/sections to cover more then others? Been hearing Gov/NFP is a big one. Anyone care to share what the exam was like for them and what it mainly covered?

Is it possible for a vet tech to make 6 figures?

Where is GME going today?

Looking to break into investment banking M&A as a lateral analyst. Been doing Valuations for almost a year (graduated spring 2018 from ug). I've practiced modeling and finance questions. Cont...

Tcs Hr has said to me that you will receive welcome mail by today EOD. What time frame I can expect the mail.

I'm a senior and started out over a year ago. What would be some good low risk investment options? Have about $15k to invest. Open to investing in India or in the US too. (No crypto pls)

Hi ,

Can someone refer me in Citibank for mainframe developer

Only sentence that matters... not a single Republican objecting to the election results is objecting to the victory they won on exactly the same day on exactly the same ballots.

I handleda very difficult and convoluted succession for a black family. My client was astute and intelligent. We got along great. His family was difficult. Willfully ignorant.

Part of the succession dealt with clawing back $450,000 in insurance proceeds that a niece fraudulent received from the decedent by making herself the beneficiary on policies. A separate attorney was hired to handle that part before I was hired to handle all other matters, including settling a $500,000 debt with the...

Hey people

I have recently received an offer letter from PwC and have signed and accepted the offer (via Workday portal).
Now when I check the tasks against the job on workday, I can see no tasks pending and under completed tasks: a green tick against 'review and sign offer letter (step complete)' (and I can see the offer)
I am told that I would receive onboarding emails from HR, but I haven't yet.
My DoJ is in the fourth week of July. When do we generally expect these communications?

Hi fishes, anyone here who can refer me for mechanical engineering roles? I'm aero engine design engineer with 10 years experience working at Bangalore right now. Any referral is really nice appreciated. Thanks

Junior IT developer looking to break into Customer Success to continue my coding practice on the side.
Anyone looking to hire? Worked at a unicorn SAAS company as a SDR. Great performer with references to back it up! Before that it’s been all sales! Mostly car sales and was able to travel to Aussies how to sell cars as well! I love being able to take my time to establish and building meaningful rapport with just about anyone! Lookin go for open environment, structure and great training!

Hi Fishes,
I belong to construction industry with PGDM from NICMAR in Advance Construction Management having expirence of 2yrs. I want to know how can I boom my career even after so much of higher education and expirence industry has slow career growth and toxic work culture. Iam not getting how to move further with such underpaid industry even sometime I get the thoughts for switching the career with data science which again needs time and money investment please suggest DS scope for Civil eng

“Those glasses don’t make you look younger, they make you look older—but slightly more cool.”

🥺

Compliance question here, I have always thought of the SALT deduction on the fed return as a perm item & have treated as such in such sch M-3. I see that some people put it as a temp on sch M-3. What is the justification for treating it as a temp on the M-3. You don’t set up a deferred on the def RF for the state tax deduct & it is also a rate impacting item (I know that some temps can be rate impacting). But this all leaves me to side with perm. Does anyone know the logic behind temp treatment?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

How long did it take you to become good at excel? Like fast?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

Would anyone be willing to teach me vlookup?