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

Hey Guys, Slightly an off topic question. I along with my wife and kid are planning to move to Bangalore and looking for rentals in Hebbal Kempapura. Would be great if anyone staying in this area could suggest some good apartments complexes.

I know there are multiple posts about this but I still can’t think of the right way to play United Wholesale Mortgages. Too nervous to sell covered calls with the ex div date and high OI for calls in March. Anyone considered averaging down?

CNN HL: DOW back in bull market, should it be?
The talking head says industries will crumble and its doom day!!!
Your take?

I’m looking for a new job, working remotely, that doesn’t require a Bachelor’s. (I’m currently going back to school to get one, as I only have an Associate’s in Mathematics right now)
I had positions in private sector that allowed me to supplement having a degree with experience but not in public sector. I’ve seen coworkers get positions they aren’t able to do simply because they have a degree and then leave a mess for me to clean up but I’m not allowed to have the position. Any suggestions?

Hi Guys, Need to unlock DM's. Appreciate your help in liking the post!

Ladies, any options that are comparable to lululemon but not as pricey?

Anyone from Leidos? Anyone? ...... *crickets*

Mastercard default hike for the new joiners? Also what is the salary range for level 7

Hello All,

Hope we are doing well.

I am in the UAE on a Visit Visa and looking for opportunities here.

Please let me know if we have any references or recommendations you may be able to help with.

My last held designation is Operations Manager - Customer Engagement

I have a total of 13.5 years of experience in Operations and customer services.

I am unemployed since May 18' 2022 and your assistance will be really appreciated.

Anyone from McKinsey want to provide a referral of have feedback on how the implementation push is going?

Hi all- new to fishbowl. Not really sure how to use and explore the app yet but I saw this bowl and figured I would introduce myself. I am a wholesaler for 401K and I am able to partner with advisors who currently uncover 401K opportunities or are looking to learn how to. Reply if you are an advisor in the NYC area and interested in learning about how to expand your business.

Currently doing data analytics under operations team at a financial services company. I went to school for data analytics, so I don’t have much financial domain knowledge. What would you recommend me to learn to break into investment or PE some day later?

Anyone here broken into real estate private equity from big 4 consulting? What steps did you take to jump into RE PE? What gaps in knowledge did you have and how did you fill them? Outside of the knowledge gaps what other things do you think you needed in order to get into RE PE?

What % annual VP increase should you expect? 1Y VP to 2nd

Did your firm’s leadership send a message re the horrific shooting? Before I lateraled we always got emails from leadership, which IMO were very humanizing and appreciated. New firm leadership seems to just avoid — probably to not appear politically involved. Your thoughts on these types of current events and firm acknowledgment?

Off topic ---

Has anyone bought nothing phone 1 ? Hows experience ?

What are the companies I can switch from Eli Lilly? Can I try for product based companies like Amazon and Uber?

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?

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.

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”

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

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

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)

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?

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?

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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 I compare two sheets to make sure they are identical?

I have some data extracted from SAP and though the size is not relatively high lets say about 45000 line items. My excel keeps crashing anything i do with it 🙄! Any clue why it is happening ?

How long did it take you to become good at excel? Like fast?

What would you consider "Advanced" or "Expert" level Excel usage?

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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.