Looking for an efficient way to pull a bunch of addresses from various websites into an Excel sheet. I’ve tried Power Query but the data isn’t in tables on the various sites. I’ve tried ChatGPT but it’s not pulling all addresses and the accuracy is about 60%. Any ideas?

Anyone else get frustrated when the partner brags about their billable hour amount for the month? Like congrats, you get to bill .2 for each piece of mail. You also get .2 for every letter your secretary types up as a "form letter" you never even look at. As an Associate, I don't get those easy/automatic hours.

I have an associate's degree in graphic design and work designing wedding stationery. I've been at my company since 2016, and am now a design consultant - speaking to customers directly and creating custom artwork and designs for them. I know I'm underpaid (50k/year in the SF Bay Area) but I thought the benefits and stability were worth it. I'm now severely burnt out (most of my team is) and not sure which way to go, or how to grow. Any tips/advice?

Thanks!

Accounting and tax prep for growers - is it something to get into since so many states are easing up restrictions?? Currently in FL, but wonder if I need to move to get the skill set and then come back when it is fully legal here.

This bowl has been dead forever. I’m still powering through my corporate America career all fake smiles to eventually retire early and live like my hero, Tommy Chong. Stay up my professional 420 friends, the end is near!

Hello team,

What should be good package for a 5yr old IAM consultant in UK? Thanks in advance!

How to get from 18 LPA to 50LPA, presently have architecture exposure along with DevOps and Operations for microservices with automation
I can guess few replies , still checking :D

Is there a list of agencies and clients that don’t pay on time or at all? If not, can we start one here?

I've offers from tiger & fractal
Yoe: 9 years
Role:
Tiger: manager
Fractal: senior consultant
Difference:
1 Tiger offers 4 lakhs more than fractal
2 Role in fractal matches my current role. Whereas the role is tiger in 2 level above current role & i need to boot up for the bigger responsibility which I'm a little worried about being new co
3 Insurance benefits are good in fractal.
Barring salary difference help me choose which is better w.r.t wlb,job security,benifits, growth,culture,learning

Is booking 40hrs a week freelancing for one company a good idea? Or does that seem like you don’t have anything else going on? I would like a good work life balance with the ability to take off weeks at a time in the middle of all this.

How does one find solid alpha groups?

Is HCL calling to work from office?

I'm not sure if I love this life! I was entirely sure when I decided to enroll in the military, but after a few months, I felt exhausted. Could I have made a mistake?

What is the up or out mentality at BDO? Close to Senior manager and thinking about path to be a partner

Got 3 weeks to study both Far and reg before NTS expires. 😞 should I cram for both and take them? Or give up on 1. Would prefer to pass in 1 window & not retake

I switched to industry recently! My boss told us we can go home after lunch at 1. Lol ok I can get used to this.

Can you get fired for having low utilization as a senior? My billable hours this busy season have been much lower than my peers.

Select an item -> select a box -> ctrl + shift and drag. Creates aligned copies

Are there any Open Group Certified Master Architects that would be willing to answer a few questions about the certification process?

I’ve very fortunate to have a new job. I wanted WFH, but I guess it wasn’t in the cards. Do you think people who work from home are that much happier?

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

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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?

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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.

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

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?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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”

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

How do you fix microsoft excel cannot paste data error?

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Would anyone be willing to teach me vlookup?

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

How do I compare two sheets to make sure they are identical?

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.