I’m trying to check numeric values in a column and classify them. For example, if it’s within 0-10, group 1. 10-20, group 2. I have four such groups. I’ve been using a vlookup but I get a ref error. My formula is vlookup(value, range1:range10,columnnum, True). What am I doing wrong?

Choosing between industries for Big 4 Audit. Asset Management or Technology Media and Telecommunications to transition into TAS down the line for Major Metro Markets?

Interview tomorrow for a tax associate opening at RSM. Been working in a mid-size city (different firm) that is about 70 minutes from this new home office in a larger metro. How flexible is WFH or dual model going forward post Covid? Am interested in this position and going to tax, but not be able to relocate for family reasons. Don’t want to drive 700 miles per week M-F. What will dual model be like going forward? 1-2 times week, 4-5 month? Seems like tax was more flexible than audit pre-Covid

For those of us working with Healthcare clients or in Healthcare, what can we start doing to accelerate healthy change in the industry. It seems like so many people need support and guidance with OCM.

Does being a first generation college student drastically help you when applying to mba programs?

There’s no reason you have to put up with a job you hate. I spent many years working in a toxic environment with a boss who gossiped and lead through fear. He wasn’t really much of a leader but basically a foreman. And he could make my existence miserable. I admit that it wasn’t easy to find another job but the bottom line is: trust your guts. If you feel something is wrong it’s because it probably is. Don’t second guess yourself. Look for options and and fight for your mental health.

Does coforge renegotiate if we show counter offer as earlier they offered very low. ? Remaining joining time is 20 days

Hope to find some pumping mamas to talk work place challenges and balancing the constant pull from our industry with being a new mom with

How is Allstate India Internal Audit(SOX) Profile?

Started at a big firm in July with high hopes- in the career path I wanted and I would be joining with other new grads.
After onboarding, it’s as if my team forgets about us every day. The training is non existent, there doesn’t seem to be any initiative to invest in new hires, my manager scolds me for not knowing enough yet gives no direction. I don’t want to waste time (colleagues mentioned it doesn’t get much better from here). Do I embrace the suck or look for other opportunities?

Doing a trip with my parents to South Spain for a week ish. Thinking of structuring it as:
3 days in Seville
1 day trip to Cordoba
3 days in Granada

My parents love the moorish architecture / shopping at those little shops. Is the above a fair itinerary?

Does anyone here do project consulting for start ups/tech companies? If so, what is a typical hourly consulting rate for non-clinical work?

Barber recs in Manhattan that can do a nice fade and scissor cut?

How much does a biomedical bench tech make in Toronto area?

Looking to make a jump. SVP/EVP media agency/client side. 20+ years experience in planning, buying, partnerships, content. NYC or North Jersey
Know any client side recruiters or good agencies looking?

Has anyone bought a commercial space and eventually rented it out that resulted in a positive cash flow? If so? In which city?
I’m on a visa in U.S and looking to potentially invest in commercial spaces rather than residential places.
Age:25
T.C: 102K

What’s the meaning of life before FIRE and after FIRE?

FIRE newbie here. Is it possible to reach FIRE with a special needs kid? Has someone done it? Are there any alternatives to fund therapies beside insurance?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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.

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.

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.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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.

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Still don't have xlookup. #fomo

Would anyone be willing to teach me vlookup?

Best websites to get more of a handle on Excel as a beginner-intermediate?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any 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”

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..

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.