Linked cells don't dynamically update when I change row positions in the original (link-from) sheet. What formula should I use?

Moving to Boston from NYC and work in Cambridge. I’ve been recommended Back Bay, South End, and Seaport. Where do you recommend? Where is best for dating life?

How is @Happay as an organisation for an enterprise sales role? How's job security, product acceptance and T&E learning curve.

Hi fishes,

I'm appointed as a senior engineer (Front end developer), will bosch provide WFH option if we demand before joining itself ? or its mandatory to start work from home ?

So hard to date while being a consultant. Any luck fellow fish ?

I keep watching Schitt's Creek reruns now and then. It makes me feel warm and mushy, but also super lonely. So tired of being perpetually single. I know it's been posted about here a bunch of times before but it still sucks. Venting and knowing you're not alone, helps a tiny bit. =) Also does anybody else thing Patrick is essentially just a 'too good to be true' fantasy boyfriend Dan Levy dreamed up and put on the show?

considering a trip to Hawaii, looking for Marriott properties that have a beach access, probably October through December. Would prefer more on the value side than all glitz and glam. Any recommendations

For new hire who’s struggling, will going back to office actually makes things better and easier?

For those with corporate banking expertise, how do you typically go about calculating debt capacity for a company?

Is it common practice in Singapore for firms to have a probation period for new joiners (duration at their discretion), during which new joiners can be fired at a week’s notice period?

Is it good to hpe seeing current layoffs. Is there good work life balance? Job security?

If you were offered a job at a great agency but working on just one brand, but it was a big one like Nike or McDonalds, would you do it? Being siloed sucks, but maybe worth it for a big account?

Anyone have experience in raising capital out of the Middle East (Jordan, Kuwait, SA)? Any experience in delivering solutions in that area? I am trying to figure out if a pursuit in that area is to much of a risk. Any insight is appreciated.

Since housing is going crazy (atleast in FL) I am still thinking to buy or not. Or should I invest in REIT to gain some profit by riding the wave?

Will Amex restricting guess access for Centurion Lounge actually make any difference?

I can see short term changes but the way Amex has been aggressively marketing Platinum card, we just will have overcrowding of primary card holders 🤷🏻‍♂️

What's next, everyone has to spend min. 50k a year to get Centurion lounge access or pay per visit.

Hi Fishes,

How much to expect from Telstra, for 7.5 yrs of experience, CTC - 18 lpa, tech- pytest python

Please advice

TIA

Can I get 11 likes to DM. Thanks 🙏🏽

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”

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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.

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Any book recommendations on excel modeling for real world business applications?

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)

Would anyone be willing to teach me vlookup?

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.

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

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)

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.

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?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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?

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.

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)