Hi,

Does anybody knows of a formula to bring in the previous quarter in format “QX” based of another cell with a format “QX”?

This is for a live formula and I will need it to work for the 4 preceding quarters. My live formula is looking at a cell with today’s date and bringing in the quarter based on a bunch of if formulas (quarters do no align with calendar year)

For example, I need it to look at Q1 and bring me Q4 and when I drag it across it would bring me Q3 when looking at Q4 and so on

Did booth say when decisions would be announced for R1?

What is an NFT?

Can we use salesforce mobile for personal purpose like clicking photos and transfer it to another mobile

I am fairly new to LGL (10 months in). I had been practicing criminal law before. I really like LGL because I get to work on something new every day and most of the questions posed to me require creative thinking/solutions. But I do find myself feeling discouraged many days bc there is just so much I don’t know. I understand things will get better and may come easier to me with time and experience. How long did it take for you to feel comfortable and feel like you have a handle on most issues?

Has anyone ever been "let go of"? Either laid off or fired. How did you get through it?

I moved from being customer service at a call center to doing it remotely from home, and it's such a game changer. I just sit around in my pajamas, relaxed. Has anyone else switched to 100% remote work?

I have an asset purchase of a retail store transaction. Seller is keeping the second location. Seller is licensing the name from the buyer. The licensing agreement is supposed to contain provisions so that the seller cannot offer promotions or discounts that the buyer does not also offer (i.e., seller cannot undercut buyer's pricing). I know very little about antitrust. Can anyone give me some suggestions how to enforceably draft this agreement, or is this arrangement impossible?

Any input on job offerings I’ve received. Morgan Stanley CRU risk officer pay is $70k with a less than 10% bonus. And KeyBank position is a private client advisor pay is $67k but bonus can range from $10k -$25k depending on performance and other compensation factors. Currently a Investment Consiltant at WFA making $62k with a $7k bonus. Both are in office positions in SLC, UT. TIA

Before taking resignation they were saying will get letter in 2 days max, now Delay in offer letter even after more than month from the day I took my resignation back.

Any suggestions will be much appreciated.

Just saw a posting by a recruiter on LinkedIn - great opp for those who would like to work remote! DM ME If interested: “Big 4 Senior’s in Texas- looking for a Senior Accoutant for a rapidly growing, pre IPO industry leader in Austin, TX! Open to candidates who want to relo OR work 100% remote! Position is on the INTERNAL REPORTING side. SEC Reporting a plus for assistance purposes only (team focused, highly collaborative environment), but not the primary requirement of the role. “

Who are considered the top consulting firms for Executive Coaching? Thanks!

In terms of taking the next step to elevate your career- what items are you heavily focusing on? I have speciality in data governance as well as product counseling, but curious to know what others find most helpful in their practice areas.

Anyone figured out a good way to keep hearings public? I'm trying to figure out if I can get the courts to post zoom links for hearings somewhere.

Is there a Gym facility in DTTI office in mumbai?

What should be the Salary ask be for Sr. Consultant @ EY India Tech Risk practise?
Relevant YOE - 5 years.

How is the market in Canada for BAs? I’m looking for tips and recommendation to find a job in CA.

Getting ready to leave my role - looking for community ops, comm ops, member support, account management - anything in those customer facing roles that is paying minimum 75k. Remote preferred, based in Chicago. Background in freight/logistics and healthcare.

Tired of hearing all the "account people suck” comments on this app. Get some new material creatives.

Looking for procurement jobs any lead??

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

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.

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 🙏

Hi there,
Which Excel courses you recommend for a beginner?

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Would anyone be willing to teach me vlookup?

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

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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?

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

What are your top Excel ninja tricks? Ones that few people know...

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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

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 🙏

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

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted