I have a workbook with a couple of custom lists that we use every month in my department. I'm handing off this responsibility to someone else who will be using their own laptop to do it. Will the custom lists pull over to their version, or do we have to set them up in their version of excel on their laptop?

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

As long as they have Excel, and you share access to those lists with them, they will have access to make changes. I’d save a backup copy.

like

Amazing, thank you!

Related Posts

Deloitte Manager or IBM Manager?? Please suggest.
Almost same fixed package.. skill SAP Functional Close to 10 Yrs experience.

Can I have 11 likes to enable chat option

Thanks in advance

likefunnyuplifting

Anyone in tiger working with pepsiCo client?
Please dm me.

Hi can anybody let me know what is salary ra ge of PySpark Developer in Tiger Analytics. YOE - 5 yrs.

like

Anyone have an idea what kind of plant this is? My boyfriend brought it home without any tags or info 😅 I have it beneath the my north facing windowsill so it’s slightly shady and it seems to be happy enough so far if a bit thirsty. Any insight would help!

Post Photo
like

My spouse’s health insurance no longer covers her antidepressant. The generic version of the drug doesn’t work for her. What can I do to get her on my health insurance plan?

I am one point away from passing edTPA but can't resubmit now that schools are closed. What other ways are there to get my license???

like

Hi all,

Need 11 likes for dm to be activated. Please help

like

Hi all,

I am currently working as a SAS developer, 1 YOE, but want to switch to data analyst role. What skill should I acquire? All inputs/insights appreciated.

like

Anyone from Harman international, please help need to know information regarding the company. @harman international

like

Hey folks i am recently done with offer letter for senior analyst Novartis Hyderabad. So I just wanted to know how will be the further process like employment verification and background verification. Is EPFO compulsory during bgv as my previous don't provide pf .. please let me know..

like

Going back to the office next week. Are people still doing suits these days? Seems a bit odd to go from sweatpants back to suits.

like

Is anyone wondering what life will really be like for all the new Diversity, Equity, and Inclusion executives that many companies are hiring and bragging about now? I wonder how much power they will actually have to effect change. I wonder how long the trend will last.

like

Why are town Hall meetings so impersonal? They are all about awards / the number of people hired. I know FCB health is large, but we never hear from people who aren’t Executives. Last town hall, when discussing inclusion efforts, there were no people of color represented and one of the 4 pillars of diversity was centered around our “reputation as an organization” (that really rubbed me the wrong way). At my last agency those conversations were always led by people of color from every level.

like

Hi 🐠! Has anyone in the NYC-area had smartlipo done with a surgeon they really liked or other helpful info? Thank you!!

like

Can I be rejected if I ask for 27LPA (30% hike) from Nagarro?
YOE: 5.5 yrs
Tech: UI ReactJS
Current: 21LPA

like
like

Anyone in KPMG Procurement consulting?

Interested to hear how it is from a project, WLB, compensation standpoint..
KPMG

like

Technology (ERP) consultant looking to make the switch to a supply chain transformation/tech strategy role. Any suggestions on how to make that transition? I have a CSCP credential and am starting an MS in supply chain soon.

like

Has anyone ever been on an online dating site and saw one of their co-workers on there? 😂 🙋🏾‍♀️

likehelpfulfunny

Additional Posts in Excel Genius

Hi guys!

I need help with something: I recently started using xlookup in excel to automate recurring tasks (accounting) but I have found that my peers and supervisors have difficulties understanding how the numbers are pulled, which makes their understanding of the files difficult.

What would be the best way to convert the result of an xlookup cell to a reference to the found cell?

Is there any way that could be applied to all the xlookups in an excel file?

Thanks in advance!!

like

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

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Hello,
How do I randomly pick one name from a list in excel that has identical names?
Example:
Warehouses names
Ana
Ana
Hou
Hou
Aus
Aus

Every name repeats itself several times. But each of them has different lot numbers associated with them. I only need to pick one lot number number from each warehouse randomly. Is there a formula for that in excel?

like

I am trying to do a sumif formula for values that fall with specific dates. It worked for all but one of my cases. Not sure what I am doing wrong. Every other case worked. For some reason it’s adding more than it should. When I move the sum range up one it resolves the issue but that throws everything else off. Any help would be appreciated

like

Does anyone know if there is an excel plug-in that links brokerage data (i.e. account info from fidelity/Schwab, etc.) so I can track/analyze on excel?

likefunny

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

like

Best way to learn Spotfire? Just watch YouTube videos?

If I’m creating a comp set and a row of numbers will not adjust the number of decimals no matter how many times I adjust it in the “format cells” window, what could be the reason for this and how can I get around it

like

What’s the best way to go about taking a massive data file (300,000 rows, 634 columns and turning it into something more usable? I’m familiar with PowerQuery and PowerBI and the end goal is to get all the data into PowerBI. It’s basically item attributes by item by store and sales dollars, units, and on hands from 2019-present by week.

like

Formula to convert the date on the left to the date on the right? I’ve been using text to columns then concatenation but I feel there must be a better way...thoughts? Thanks!

Post Photo
likehelpful

why is index match superior to vlookup?

likefunny

Public schools use Google for everything. So they use Microsoft Office as little as possible. Even Office 365 isn’t used much. I teach an exploratory class to 8th graders for Google docs and sheets since the school tech doesn’t support the educational MS Office 365. I like the MS Office desktop version because it does so much more than 365. I relate how Google does things similar to MS Office but not to the level that Office does.
Do businesses use Google docs, sheets, & the rest for anything?

like

Anyone have a easy formula to turn “2 years 6 months” into 2.5? Thanks!

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

like

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

like

Is there a key to press to go to the bottom of the row you just copy and pasted into? Ctrl +shift + down goes to the bottom of all the text but I want to see where i stopped the pasting.

like

Not really excel - trying to convert a “text formula” result into a number result but I’m stuck

IF (AND(Monthly_Unique_Visitors__c  >= 0, Monthly_Unique_Visitors__c <= 50000), "-50",
IF (AND(Monthly_Unique_Visitors__c  >= 50001, Monthly_Unique_Visitors__c  <= 100000), "-20",
IF (AND(Monthly_Unique_Visitors__c  >= 100001, Monthly_Unique_Visitors__c  <= 250000), "0",
IF (AND(Monthly_Unique_Visitors__c  >= 250001, Monthly_Unique_Visitors__c  <= 500000), "7.5",
IF (AND(Monthly_Unique_Visitors__c

like

Is there a way to easily create all the permutations of 315 possible combinations of numbers in excel?

like

I’m 26 y/o and working as a sales coordinator (basically an assistant) for 5 national account managers in the investment banking industry. I have a BS in Finance and am series SIE, 7 and 63 licensed. I’m only making $50k a year (before taxes). There are a lot of aspects I enjoy about my job but the pay is not cutting it. Recently, I have found a passion for working with data in excel and I want to try to make a career pivot into business analytics but not sure where to start. Advice?

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

Scan your QR code to download
Fishbowl app on your mobile

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