Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

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

Conditional formatting with a countif formula. =countif(lookuprange, cell to highlight if found in the lookup range)

likehelpful

Let me guess...Are you working on the Marriott merger?

funnylike

Copy the lists side by side and do a match function, and then filter the “N/A”s

like

Advance filter using criteria remove duplicates

like

Do a vlookup and filter for cells with no errors

There is a standard conditional format that will do this now...

Related Posts

I have been offered supply chain advisory consultant role at IBM. Fixed CTC: 32.5 lakhs.
I have 4.5 years of experience and MBA from IIM Indore. Current CTC in an Indian MNC is 27.8 with 24.8 as fixed.
Should I take up offer from IBM as yearly increments and variable pay would be negligible?

like

I wasted so much time on other bowls, now I wish I had found this one sooner...

Post Photo
likeupliftinghelpful

Apollo Global, Mumbai, is hiring Analysts/Associate for
• Financial Controllers in Private Equity, Credit, and Real Estate - NAV/management fee/carried interest estimation etc.
• Risk team - Developing quant models for valuing Annuities, ALM management etc.
• Risk Developer – Risk measure, Stress scenarios, Java/C#/RESTful/RDBMS
• Financial Reporting – Quarterly financial statement/analysis, 10-K/10-Q etc.
If you have relevant experience, and are looking for a change, please DM me.

like

DTF = Digitize the framework

likefunny

Need advice: My Lady just got laid off today.. Valentines day.. Any advice on how to go about tonight?

like

How much can I expect from GlobalLogic with 2.10 years of experience? Already holding an offer for 16 Lpa from some other company. Please help!

like

Any insight on BCG interview process?

like

Does any one apply for adjustment of status or GC at EY. Can they apply adjustment of status at senior level or you have to be at Manager level ? They filled PWD for a Manager position

Hello anyone can help me with a referral to Salesforce, Zoom or Splunk or any other great tech companies to work for ? I have 5 years of sales experience so I would be looking at a SDR or account executive roles.
Thanks guys!

like

Folks that intermittent fast to lose weight, what does your meal plan look like everyday? Basically what do you eat in a day? Struggling to eat enough (funny enough), my metabolism is slow which is not helping me lose weight as consistently as I’d like too

like

Hi all!

Just wondering how many cases you would aim to do before an interview (MBB/T2)
I’ve done 7 live cases and general read up over the last month and one of the MBB’s recruiting has opened in my city. Is it worth applying, rather than waiting when im more ready but risk missing the window for hiring?
thanks :)

like

Is America a failed state? And I mean literally.

likefunny

Hi fishes can someone suggest me the range for IN3 level at wallmart

like

Hi fishes ..

Which one to choose

1) Offer 46 lpa with 3 moths notice period
2) Offer 38 with 2 months notice period

Any idea on these

like

Does anyone have any experience with General Motor’s HireVue process?

like

Which firm has the best overall comp and benefits for tech consulting in a HCOL city?

Thinking about raises&bonuses, healthcare, PTO/holidays, other perks (wellness subsidies, grad school sponsorship, training/cert reimbursements), etc. Obviously understand exact salary varies based on level/practice/location.

like

Just sold my first property as a realtor! So freaking excited to have joined such an amazing industry.

like

Anybody here transitioned from QA to UX design? I am learning UX design and I loved it. I have checked JDs for UX designer post and I find it very interesting than QA. Also we as QA are already exposed to user experience testing so should be a smooth transition. Anyone wants to share their experience on this?

like

Hi Everyone! I'm actively looking out for a change. I currently have 7 years of experience in social media marketing and advertising. Please let me know if there is any opportunity available to which you can refer me. Location: Gurugram

like

I don't want people to think I'm just a "diversity hire" because I'm a minority female. Not sure what to do about this. Any input or advice would be appreciated. Thank you

like

Additional Posts in Excel Genius

Any one good with Tableau I have a question

like

Hi Geniuses. I’m needing to write some compounded if statements and use VSlookup to analyze, group and report based on data in a dataset. Anyone have a decent learning source? Google and YouTube have returned some hard to follow, bad results that miss the mark.

like

Alternatives to Power BI for Mac users? Trying to branch out of excel. Reports aren’t too stable with excel

likefunny

Need some urgent help with using if and vlookup together. Anyone willing to help via direct messages please?

like

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

like

In VBA when sending an email. How do I change the reply to email?

like

I have to revert a scale of 1-13 to 1-5, any advice on how to do / automate this? TIA 🙌🏽

like

Hi! Disclaimer: not an excel genius…

I’m trying to use the lookup function to grab data from a worksheet within the same workbook. I want the column to reference the cost code in one worksheet, find the cost code in the other and display the billed to date associated with it. The problem is that it repeats an amount randomly. There will be multiples then a blank cell in one that I know has a cost associated with it.
Formula=LOOKUP(D3,!Sheet!$D:$D,!Sheet!$H:$H)

like

Anyone know how to delete multiple custom cell styles at once without running a macro?

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

Hi hoping someone can help me with the below two problems:

- How do I stop people from overriding my data validation rules? Users are able to override the rules in place by copying a blank cell and pasting it within the cell which has the rules in place. I am aiming to prevent this from happening, simply telling users isn't enough.

-How do I freeze a table I have in rows 2-16 so that it can not be hidden and out of sight? It needs to be visible at all times.

like

Is there a way to calculate the sum to $150. Sum if doesn’t work assuming Col A is only counted in 1 cell. Prefer not to change the layout of column A-C. . Thanks

Post Photo
like

Hi Gang, I have voluminous pdf bank statements that I want to convert to excel with the formatting. What’s the easiest way out?

like

Is there a way/shortcut, without using a mouse to drag cells down, to fill a range of data following a trend? I want a column with the first day of each month up to a certain date (row number). Thanks

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

like

I’m using a pivot table to show how different initiatives fall under broader themes. If I’m screen sharing the pivot table w my audience and we make a live edit to one of the initiatives on the table itself, is there a way this can also change the initiative in the source data?

like

Best excel time-saving tips?

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

Has anyone ever taken an Excel course? Or do you recommend any other courses on organizing data and information? Just looking to up my skills and maybe have a little competitive edge.

like

Can anybody tell me how one can open a list off all tabs to navigate in a workbook with many tabs?

like

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