I've been asked to make a testing issue tracker. The challenge is that there's a many-to-many relationship between test cases & issues (i.e. a case would be impacted by multiple issues, & an issue can impact multiple cases).

I was planning to solve this with Excel's Power Pivot tool so I could put multiple tables into a single data model, but my company's on MacBooks (and won't allow Basecamp Windows OS) and Mac's Excel doesn't have this.

How can I solve? I'm open to any tools, not just Excel.

Hi all,

i got a call today after accepting the offer that there is an automation drive happening in infosys and they want me to enrol to that. should I attend it? it's over the weekend. anyone got such a call. please let me know

I'm hiring soon for a clinical pharmacist roles to do prior authorizations from home. It's state programs and mainly 9 to 5. What should the compensation be? It'll include 3 weeks vacation and all holidays off btw.

I’m thinking about accepting a job at Gulfstream in Savannah, GA. Does anyone know the pay range of Gulfstream? The posting is for a Engineer Technical Specialist 1

I have just got an options trader job at a prop trading firm. But I knew nothing about options/trading/finance. The firms said they’ll be officially training us once we start. But in the meantime, what are some books/resources that you would recommend to start learning first?

Reposting this:
Has anyone ever worked in Bytedance/ Amazon (APAC)? How’s the culture like and are the compensation package competitive?

Going through couple interviews with both companies at the moment, unsure which is the better company to work in.

I work at a Financial Institution and have recently been approached about a Director role with my prior company. It’s a great opportunity but I have 2 young kids (Preschool/Elementary ages) and I don’t want to sacrifice time with them for career advancement. I would love to hear from working moms in senior leadership roles to understand if it’s possible to balance both, or is it best to wait a few more years? Not happy currently and looking to move, but unsure of pursuing lateral vs. a promotion

Anybody know any good directors based in Iceland? Cheaper to shoot there ?

Ok production companies. Say I’ve got 3 weeks for you to divide up until I need to shoot. How much time do you want to bid/treat the job and how much do you want to prep? 1 week bid/treat, 2 weeks prep?

@BC what do you think about SHOP puts?

If I am having 15.30 Lpa offer@LTI, how much I will get in hand salary.

Current situation: company A- was hired as a specialist and proved my worth to become a category manager but ended up on the low end of the salary range because of my lack of experience. Have voice my concern about my pay several times to my director, with no action in return.
Company B - Recruiter on LinkedIn approached me regarding a position open at an out of state healthcare facility for the same thing I do now, I would be working remotely where I currently am today. Cont in comments..

FIRE Newbie here - wondering how everyone is retiring early (30’s 40’s 50’s) if the majority of your savings are tied up in tax preferential retirement vehicles you can’t really touch for another few decades?

Any idea wat would be the payscale for Senior 2 technology consulting in 3EY GDS with 9 YOE?

Heyy!! What kind of questions does Accenture ask for Application developer (frontend) YOE: 3years

Any idea if someone had take covesheild vaccine in India . Can they take boaster Moderna shot here

Is there a paper or hardware wallet for smaller coin like factom/golem/stratis??!!

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

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

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)

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?

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

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.

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

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.

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

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

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

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!

Would anyone be willing to teach me vlookup?

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)