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.

likefunny
Posting as :
works at
You are currently posting as works at

LGBTQ

funnylike

Lol

Go to Page Layout, pick a different color scheme and (voilà!) the table will change color.

Alternatively, in Table Design you can change the color scheme of individual tables.

No mysterious meaning behind any of this.

like

That's not what I mean. Tables color-coded by default could be indicative of having a query as a data source, for example

Lol Accenture color palette maybe

likefunny

Is it not just a format option?

likehelpful

No

You all need to check your egos. SMH

Go and learn something.

https://www.airweb.org/article/2020/02/20/excel-power-query-saves-time

Post Photo
like

Hahaha thanks for posting though

I HAVE TO KNOW NOW

like

Purple? Wdym

OP, could you share your color coding. I am just curious what you learned and w he at was hammered into you 😂

Related Posts

Hi Guys,
Which one to choose PWC AC or IBM GBS for better career growth,WLB and Benifits like hikes?
YOE:10
Salary:IBM is offered 3 lakh more than PWC offer
TIA

like

Anyone have good daily updated podcast recommendations? Looking for stuff that loads early in the morning and gives an overview of three key areas:
1. Domestic policy
2. Foreign policy
3. Financial markets

Any recs? I have domestic policy pretty well covered, but would love recommendations on foreign affairs and equity markets. My current stack is below in the comments ⬇️

like

Hi all, does anyone know of any good recruiters in UK that can help find junior account manager/AE roles, looking to take the next step up and influence a sales cycle.

Thank you!

like

I’ll be honest - slacking on my GMAT / EA prep in between of job hunt, but I really want to apply to top schools this year for EMBA. Is there any online paid / unpaid tutorial that you highly recommend to crack in ~3 months? Please guide 🙏🏼

like

Are there any fun holiday pop-up bars this weekend? I would love a reason to wear my ugly sweater!!

like

400k in combined base comp + RSUs & VC with 850k+ in savings and liquid funds. Should we buy a 2.35m dual family property? Expecting 2.5k for the rental

No kids and plans for

like

I am open for the investment Banking profile having more than 8yrs of experience if you can refer please do the needful, need a change now.

like

Any good recommendations for a dinner and cocktails spot with a good bar near(ish) to SoFi Stadium?

like

When do we hop out of doge ?

likehelpful

Holy F! I’ve gotten like 20 robocalls from the same area code number today (didn’t pick them up after the first call)... what is going on?? Help!!!

like
like
like

It angers me when medically obese people complain about their weight and then don’t bother changing their eating habits.

like
like

Has anyone tried orange wine? If so what were your thoughts?

like

Can I use my insurance to buy my wife’s contacts if she maxed her coverage on her plan out already?

like

I started my in-housing adventure only a few months ago but I’m already feeling so much momentum and potential in this space versus the vibe I felt agency side, which was constant fear and anxiety.

like
like

Additional Posts in Excel Genius

Hello Magic Fingers, Looking for your quick suggestions - how to deal with the Trace errors? I am getting trace errors on certain cells whenever I download any datasets out of JDE. For example if an item code is only Numeric then JDE returns that as a Trace error and whenever I use a Vlookup or Index-Match to find something, it always returns NA , because lookup value is 123 and the lookup array has ‘000123. Since I work on more than 200K lines, Excel takes forever if I try to convert to number

like

I have a table of different tickers of stocks and their according prices on different dates and times (hour and minute shown, no seconds). I'm trying to extract a singular price for each ticker based on date and time, but am having trouble doing so as there's multiple prices for each time (i.e. one row has $10 for 2:50pm, another has $11 for 2:50pm, etc) and was wondering if there was a way to pull only one price, let's say the highest, for a time?

like

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

What are your favorite excel macros to make you more efficient at work?

like

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Hi,
I am trying to match in a specific row of a different sheet, although I want to use a calculated row value to specify the array to look in, see the photo for the logic I am trying to do… any ideas on how to get this to work?

Post Photo
like

So xlookup? How is it going for you? Still haven’t use it.

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

There has to be a way to restrict access on a worksheet so that only specific cells can be edited.

No matter how many times I’ve tried to automate and simplify generating reports to just inputting data into specific highlighted boxes, someone just have to try to edit a completely different cell then asking why the worksheet is “broken.”

likefunny

Do you guys use specific color scheme to make you spreadsheet looks pretty?

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

Are there any great market sizing and business case spreadsheet templates that you guys have come across? I came across this SaaS valuation template in this bowl which was super helpful, but nothing for sizing or business casing. Appreciate any help.

likehelpful

Hoping someone can help me write a formula for the blue cells. Trying to return the unique ID from my data using 2 lookup criteria where the first is the Name in column A and the second is the date in column B that falls between the appropriate date range for that Name in my data. All names are spelled/formatted exact same in lookup table and data table so no issues with respect to extra spaces, periods, etc. Picture attached for reference. Any help is greatly appreciated.

Post Photo
like

How can I make these dates sortable with a filter?

Post Photo
like

I have a large spreadsheet with lots of dates, how can I identify classification based on the dates below? I.e. if your hire date was in between these parameters, it flags you. nested IFAND?

Post Photo
like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

What are the most typical models you all build

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal