So i have a list of companies in a list (column A), and a “Y” next to them (column B) if i want to include them in my dataset.
Is there any way i can make a variable list, ie below the full dataset, of just the companies with “Y”, and it being dynamic?
Can post a screenshot tomorrow if useful to explain

How do account directors differ from sales executives?

Anyone from Google Finance kind enough to review my resume before I apply? I promise to do the same for someone in my shoes one day when the opportunity arises.

You’re an incoming analyst in the M&A division at a big 4 consulting firm... you (should) buy a ____ as your first watch.

How is Projects assigned to laterals in HCL?

Can someone please help me refer at Bain for a Business Analyst position? I am looking for something in the Pharmaceutical domain

#Opentowork

Any production Support role/Application Support role/Technical Support Role opening available please refer me

Years of experience : 4
Skill set : Autosys , Unix shell scripting, Oracle SQL Basic SQL , Servicenow , Informatica Powercenter Minor enhancement.

I'm applying to some roles at Apple that aren't completely related to my major (in Master's)? I'm curious to know if hiring at Apple considers people from different backgrounds? Would also appreciate any tips to apply to such roles?

(PS: I come from an Aero background)

Rejected a offer from Salesforce. Now considering to join again. Any advice on how to win an interview?

Help, I made a mistake! A recruiter emailed me and I agreed to a phone interview. I did little research on the company and none on the salary… (I know my mistake) One of the first questions I was asked was about compensation to which I answered 45k-50k. (to quote the recruiter this is a “upper level entry level job”) the recruiter told me the base is $45,500. I got home, did research, and found the company paying the same position 55k on Glassdoor. Is it too late to ask for money?

Hi Sharks,

I am looking for job opportunity at Accenture in Pharmacovigilance. I am having an experience of 1 year in Pharmacovigilance. Can anyone help me with referrals?

#pharmacovigilance#ICSRcaseprocessing #Accenture

How much time does work related travel expense take to be reimbursed at EY India, had submitted bills a month ago.

I've just made my career change to Finance happen and love the fact I am passionate about my job. Even though I already have some financial knowledge, I'm looking for fellow knowledgeable Finance professionals who are interested in regular discussions about current affairs and/or hot topics in the financial sector.
Would anyone be interested in forming a small group to lift each other up and bring each other further in our learning journeys and careers?

Hello Fishes,
Do you think it will be of any benefit from career standpoint to pursue Post Graduate Diploma in Management(PGDM) from Grade A (IMT/NMMIS etc.) college in India through Distance learning. I’m having 11 years of experience and currently working as an Individual Contributor.

Hi guys,

Can someone refer me in Bangalore?
I have 2.5 years front end experience.
I have quit my previous job due to accident.

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

Is it possible to make a VBA userform that let's me interact with the workbook? I know how to create the form but default seems to be that I can't do anything else in the workbook until the form is closed.

If i have a # set and a # that is the sum of a subset of #s, but don’t know what #s make up the sum, is there an excel/python function that will give all possible combos that cud make up the given sum

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

Does anyone use XLOOKUP over Index Match? Why /why not?

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

My company has locked down our Excel so that we can no longer access the VBA Editor (it’s greyed out and Alt F11 doesn’t work). However I can still access the Word VBA Editor. Is there a creative way I can launch the Excel VBA editor via the Word version, or somehow run Excel VBA code via the Word version?

Alright. I am very much so not an Excel genius; I have the Excel skills of your 90 year old grandma who just owns a Jitterbug. Im semi-tech savvy (young millennial), but I’m new to corporate after transitioning into my role from the classroom. Among some skills I know I need, understanding basic Excel functionality is the most immediate. Does anyone have any recommendations for a very novice look into Excel? Thank you in advance!

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

Need to create an P&L for a physical therapy center without using existing excel templates. Just cap payment info, lease price, team member salaries and supply costs.

Seeking formula support…,and open to other tips and tricks.

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

Does anyone know how you can create a pivot table that results in calculations being performed from that pivot table, where if the pivot table changes, resulting in more/fewer rows, it moves the formulas up or down depending on the additions/removals?
Basically, have a dataset, trying to select all rows where the answer in one column is Yes and answer in another column is (for example "X"), and multiplying the amount in another column by 16%.

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

Would you rather use Excel versus CRM to store data and manage records? If so, why?

What is the most useful macro for my tax accounting professionals?

hoping this illustrative post makes sense.
column A=state; B=city. Cells in each column are drop downs, i.e.,can select countries/states. And, current dataset/selected choices is indicative of a category i.e., top locations. I want to build scenarios or addtl categories that ultimately auto changes values in the drop down cells. this is doable w/ lookups, but want to avoid formulas as i need the client to be able to customize the dataset/selections to view scenarios , hence drop downs. 😬😬

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

I’m trying to do a crosswalk of sorts. Look up a GL account number in one cell in an array and bring back a number from a specified column. Not having great luck with a vlookup. Can’t remember the exact rules (order, etc.) is there an easier way?