What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Joining Accenture Strategy in the Fall – any notable benefits I should be aware of?

How do Rolex waitlists work with respect to different models? Like if an AD could let me have a Sub, Exp 1 or 2, DJ, GMT, etc I would honestly take whatever is available first. Are there lists for specific models or is it sort of just one big pool?

When is bonus paid. If someone resigns and serve notice period in Dec, will they be getting bonus?

Best ways to use whiskey in culinary/baking adventures? Has anyone does this? Looking for ideas for my husband. Want to surprise him

Is step sibling relations incest to you?

Wild to think some people don’t use excel as part of their everyday work life.

Any recipe book recommendations for making cocktails?😋

Are text message breakups acceptable? Better than complete ghosting right

What is the associate comp at firms like RGRD? Lower with larger potential bonuses? What is the upside compared to Biglaw, just more substantive experience early on?

Refer me please. Currently working in Goldman Sachs’ Global Compliance Division, looking for new opportunities. DM me

Anyone recently joined Infosys as a lateral haired
Pls DM me

Anyone have any suggestions for front end guis for users to run python code? I’ve created a few tools for webscraping data, automation, and modeling but non technical users freak out when they try to run the code themselves. Any suggestions? (Have tried Juypter Notebooks and a few other IDEs)

Fellow data 🐟, plz recommend me something to do tomorrow. Existing weekend plans went up in smoke and I'm feeling like trying something new

Something to think about... If you awakened tomorrow and your skin was a different color, ask yourself how you might feel and why? Don’t respond directly just think about that. Imagine you are not the enlightened person you are. 😬

Answer this: What does that say about what has become subconsciously engrained within most of us?

How much an application development team lead gets @ accenture YOE 6 ?

Hi Fishes,
I have 2 years experience in similar domain in Amazon Ecommerce.
I had recently interviewed for SAP Ariba for the role of CFE Consultant- Catalog Advisor, while the manager asked for my expected salary i mentioned 8.5 LPA, is it good?

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

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!

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

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)

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

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?

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

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.

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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

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

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?