Really wish my clients didn’t use Google Sheets. This sucks.

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

I personally find them better than teams’ hosted word docs /Excels . What do you find so annoying ?

like

Do you not like using excel in teams? If so, just open in the desktop app.

Or do you not like the auto save back to sharepoint (teams)?

Rip

Related Posts

Looking to take a trip to the Galapagos—any recommendations for tour companies or did you plan it yourself? Rough cost estimate for two people? We’re flexible on what time of year we go. Thanks in advance.

like

Hello all! I'm a clinical research professional with up to 5 years' of diverse experience featuring lab/bench side work, data management and information, and clinical administrative work. I am also currently pursuing my CCRP SOCRA certification as I am actively looking to switch jobs. I currently work as a Lead Research Associate& Protocol Coordinator at NIAID as a contractor and I'm looking for clinical research opportunities that are remote amd exciting! Would love a referral please!

like

Hi strategists! The social strategy team I’m on at Reprise Digital is growing and we are hiring for Associate Strategist, Social Strategist and Senior Social Strategist roles out of the NY office (mostly remote, various clients). We’re also looking for 3 Social Strategists on the West (potential for full remote but depends on location). Message me if you’re interested or want more info! Legitimately a really great team and management!

like

Unpopular opinion? One Show > Cannes. More real, brand-building work. Less of it arbitrarily connected to a cause. And they get humor

like

How much ILT training content are you and your teams self-producing annually?

It would be most useful to hear total training hours produced. Would also be helpful to hear how many learners you serve and how many people are in your department, including any consultants that assist with content creation.

Thanks!

Hello! Looking for a referral or pointed in the right direction for Nike. I’ve been in Logistics for almost 10 years primarily focused on sales and account management. I just finished up my MBA and will have finished my LSSGB this September. I am looking for new opportunities in their Supply Chain, Distribution, and Logistics department.

like

Hi everyone,

I am joining
Walmart in August. Anyone else joining in August? Please DM.

like

Hi Fishes,

I joined PwC on July in Kolkata location as a fresher out of college. I want to change the location to Chennai/Bangalore as i am from South and have some personal issues to take care of. Asked my manager already about this but no change. Any idea what can be done?

like
like

Really interesting perspective on aging from McKinsey institute of health

Post Photo

How would feel when a college hire is promoted mid-year after only 1 1/2 yrs as associate to senior, then, promoted to Supervisor in Oct same year? Really!

like

I need help. Where do I start? (No I’m not suicidal. I just see the downward spiral ahead.)

Hi, Should i join Deloitte USI for Deloitte Application studio domain as an Sap Abap HR - senior analyst? Yoe - 4 Pls give genuine comments..

like

ETL developer, skills : Python, RDBMS, SQL, Power BI, SSIS, SSMS, SSRS, Informatica data quality, alteryx, ADF, Azure synapse, Azure services.
Planning to switch role to Data Analyst / BI Analyst.
Current CTC: 14LPA. EOE 6yrs
What CTC and roles can I expect with these skills?

like

Is Mulesoft on downhill?

Integration is losing its glory?

like

Are we absolutely unable to get a pump that is not the Limerick one?

Hello, I’m currently looking for Operational risk management roles in office, hybrid, or remote. I’m currently the Portfolio Accounting and Control Manager for a power sports lending company, with 5YOE in risk management and controls and 10 YOE in financial services. Any leads or referrals would be greatly appreciated. Thank you!

like

Is FAR 1 & 2 heavily tested in MCQ & SIMs?

like

can you be friends with an ex? We dated less than 3 mos, have some mutual friends but live in different cities.
We love each other but needed to break up. He had a recent family trauma & other stressors (law school mostly) that initiated the breakup. He couldnt afford to be emotionally present within us and the things at home (which i dont blame him for and fully respect)
I want to support him but also balance my own desires and expectations. Ive accepted we’re broken up fr. ended over 1mo ago

like

Any physicians/researchers in here specializing in multiple myeloma? Working on a project and had a few questions

Additional Posts in Excel Genius

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

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

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

like

Anyone use teammates analytics? Does it work well with large worksheet? I am cleaning up this large Excel sheet, it's taking so long I don't even know if it's taking it's time or what.

like

*help plz* I have about 150 tabs of TBs all formatted the exact same in my eorkbook. I have a lead sheet that lists all the tabs. I am trying to pull common stock amount (in cell C147 on each TB) into my lead sheet. Is there a quick and easy way to do this w/o a macro, vba, etc? Any help is much appreciated!!

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

Does anyone know of any sampling marcos available online or resources to assist in creating one?

like

Maybe I’m late to the party but I just discovered the ASAP Utilities excel add-in and my life is changed. These tools can save loads of time!

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

Trying to make an =if formula (but open to other ideas) where a "point" is given for every criteria met.
as an example
if the account spent +1000 in Q2 it'd gain one "point"
then if it spent +1000 in Q3 it'd be another "point"
If it met both of those criteria, the cell would = 2. If it only met one, then it'd = 1

Ideally I'd like to have 7-8 criteria points

Anyone have any ideas? Thanks !

likehelpful

Does anybody have a good resource that would let me link data from QuickBooks Desktop to Excel?

like

Excel Geniuses- I need a macro the will convert a model with all USD to show it in British Pounds, and then back easily. Anyone have experience with this?

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

I have a large binary file (20mb) . When trying to reference another workbook in formula, excel won’t recognize the other workbook. Any fixes? I’ve been trying to reduce size

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

How can I make these dates sortable with a filter?

Post Photo
like

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
like

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

like

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

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