Anyone have an experience creating a scorecard in excel? End goal is to have a red amber green status tie to a main group which is comprised of statuses of the sub groups. Appreciate any suggestions thanks

Off topic
I have been trying to activate the material ledger but it throws this error: ml currencies are not allowed in fi

* I have maintained the controlling group, assigned to CC. 10 maintained
* In ledger, my local and global currency is 10 and 10
* Material ledger type is 9000 (currency 10: company code)

Struggling for 2 days now. Unable to identify the issue

Does anyone know what the dress code is for the upcoming CAALA Trial Skills seminar? Do people usually wear suits or is it business casual? Thank you!

Is the mega backdoor Roth looking like it’ll survive into 2022 at this stage?

If I decline one FAANG offer for another, Will I get blacklisted at the one I declined??

What TF is “BizOps”??? What do you do? I know it’s not like supply chain or some other more classic operations roles but what does BizOps do in tech?

What is this grade and level in JLR india - data science role
GRADE:
D - TM5

How many times have you felt that business/operations/"xyz" dept. folks are ruining the product by controlling what features need to be built rather than focusing on the problem statement.?

Hi all i have a 3 year experience as Datascientist in industry with masters in ML im completely tiered of my current job due to politics , work env and projects .want to switch to other companies..please help me which one has good work env and proper pay nd projects

I don't want to ask the Mck recruiter more questions. Can someone explain the differences in the Profit Sharing Retirement Plan and the Money Purchase Pension Plan? Does Mck contribute to both?

If you’re working with a freelance recruiter/ headhunter but know of open positions outside the ones they’ve brought to you, is it best to reach out to the agencies yourself or through the recruiter?

Anyone know of any headhunter/recruitment firms for client-side marketing roles? (Nyc)

Anyone looking for a resource manager or creative recruiter?

Does sap lab considers internship as work experience?

I’m 35, and going on a first date. Thinking about bringing her flowers. Yea on No? And what would be the perception?

How is Telco client in Tech Mahindra

Need to recommend a hotel to my family who's visiting from the USA in a couple of weeks. They like to stay in local boutique type places and BnBs, not chains. Any suggestions?

looking for any resources about creating messaging matrices for brands. links are appreciated!

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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

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 🙏

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?

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?

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.

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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?

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!

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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.

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 😭

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Still don't have xlookup. #fomo

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

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?

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