Need help with a formula. Cell L5 currently has a DIV/0 error, and if I use the formula IFERROR(L5,I5), the formula returns the value in cell I5. But, when I change the formula to IF(OR(ISERROR(L5),L5=0)),I5,L5), the formula returns DIV/0. I can’t figure out why this formula doesn’t recognize the error in cell L5 and return the value in cell I5. I need the value from column I whenever the value in column L is an error or zero.

This is second time I got offer from CGI but now I have again a better opportunity. So if this time I reject will there be any problem for me in future?

Hello Fishes,

Can i survive comfortably with 7.5 LPA at place like Gurgaon??

I’m a bachelor with little obligations to send money to home, belongs to a middle class family.
Not many wishes, not a party person either, likes to spend time mostly at home.

Can anyone please help me making my decision of whether i should take the job or not. I’m really confused and read 100s of articles regarding it but not convinced.

Diwali gift scene at GDS??

I am thinking of making the jump from SLP to healthcare administration. Looking for insight on pay, job opportunities and job satisfaction. Thank you!!!

OMEGA INCREASED THEIR PRICES OH NOOOOOOOOOO

Anyone going in on VNET?

What kind of copyright work can you practice for clients outside your jurisdiction without violating ethical rules besides copyright registrations.

Feel like this has probably been asked in here 1,000x but...

I have an idea for a web+mobile based platform

I’ve done market sizing, know exactly what it is and how it’ll work, and even have verbal seed funding offers.

But I can’t code.

What do I do next and how do I protect my idea from being stolen?

I am what I like to call an early career marketing profession. My experience is limited (some internships, temp jobs). I’m applying for full time marketing jobs. Any advice?

How is the Managing Consultant role at Mastercard? Is it anywhere similar to Big3 consulting or something different? Anyone who could refer me?

#LTI - Larsen & Toubro Infotech is hiring for multiple #Data job profiles.

Interested for below jobs opportunity can DM me with Jobcode
4+ Yrs exp

Python developer -JR Code 957669
Azure Consultant -JR Code 446367
Data Science Consultant -JR Code 446347
GCP Consultant -JR Code 446327
Abinitio Developer -JR Code 446287
QlikView/Qliksense Consultant -JR Code 446267
Bigdata - Pyspark/Java+Saprk/Spark+Scala -JR Code 446247
Snowflake Consultant -JR Code 446227
Informatica Consultant (MDM/IDQ/PC) -

What's the current hourly & weekly rate for freelance for a mid-senior level Business Affairs Manager?

I've lost all motivation in my job and have done maybe 40 hours of real work since the beginning of August. I've built up a good track record the past couple years, and am good at bullshitting so people have been giving me the benefit of the doubt, but know the party can't keep going forever.

Welcome!!!
For more specific updates on the Deloitte USI - Chennai

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!

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Best websites to get more of a handle on Excel as a beginner-intermediate?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

Would anyone be willing to teach me vlookup?

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Still don't have xlookup. #fomo

Any book recommendations on excel modeling for real world business applications?

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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)

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

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?