Has anyone used chatGPT or another genAI tool for formulas? Any success there? I've found mixed results mostly

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

ChatGPT has been very useful for formulas. Also had it write some VBA code in a few excel files I have.

like

Sometimes helpful in providing guidance to the right answer. Recently it has been giving me nonsense responses though.

like

Same mix results, i think the technology isn’t there now. Doesn’t help me save time because it is more troubleshooting than I like.

I had been, and what it was providing was spot on for awhile, but then as of recently, even if I ask the same question where they have given the right formula, it's more so wrong now.

I’ve found great success with ChatGPT as my excel helper. I find as long as I’m framing my question/need properly it’s usually bang on. At times I include the table or a piece of the (non-proprietary) data I’m using for it to reference and it’s been great.

Definitely mixed results, particularly with VBA. Like others said, it’s a good jumping off point

Formulas, great to get started. Vba, middle of the road at best. Unless it’s fairly simple the vba scripts still seem a little weak

Had to come back to this post to share the reason for my frustration with ChatGPT lately…

Post Photo

Related Posts

What is the salary range for L7 in consulting?
Location: India

like
like

What cities in Europe have English speaking roles? Outside of UK and Ireland, obviously.

like

Just got an offer for a Cyber manager role in Deloitte based out of Toronto. Transferring from US as M2. HR setup time to talk salary expectations. Any feedback on salary range for cyber Ms in Toronto?

like

How is the interview level of Software Engineer at Capgemini? What are the questions that can be expected from java domain for same position?

like

Does anyone work in EC/VC (whether at a firm, a fund, or at a start-up)? I’m a general corporate associate and thinking of lateraling to a firm that focuses on this type of work, with the goal being to eventually go in-house. Would love to hear about any experiences.

like

Anyone work with Acorn company? Seems like one of the bigger players in the space (maybe not?). Curious to learn about personal experiences working there.

My background is in tech transactional. I joined a cybersecurity SaaS startup at the end of last year and now also handle more generalist matters in addition to all things commercial-related. I have a number of books on contracts that I’ve found super helpful over the years (The Tech Contracts Handbook, A Manual of Style for Contract Drafting, Sign Here, etc.). Can anyone recommend books they’ve found helpful for L&E matters, privacy matters, product matters, or marketing/advertising matters?

like

Anyone wish to pass Informatica DEI certification ? 100% guarantee of passing.
If so, DM

What is the salary range for Senior Consultant level in KPMG ? Yoe-7 ;Tech : SAP IBP. Is Scon level is good or shall i ask for Manager? Is SCON or Assistant Manager is one and the samw thing?

like

TCS or Infosys if we need permanent WFH?

Tata Consultancy Infosys

likefunny

How much are y’all paying for a studio in River North?

like

For those in the SCM industry, what is your job title and your daily responsibilities?

like

Is anyone working or worked with Wissen Infotech before? I wanna know the work culture and work life balance over there. How is work life balance over there?
Is it a good option to join if I get an offer from it?

like

Does deloittw in Divyasree has shuttle to yemlur junction ??

What’s the point of having multiple awards for “craft writing” if your agency only sees you as the translator?  🙄

like

I have just immigrated to worth, Illinois from the Middle East. I have 6+ years of experience (proofed by a certificate) from Four Seasons Hotel Amman. Can anyone recommend a 5 stars hotel with front desk supervisor vacancy?

Does anyone run a business in addition to their firm? I’m a solo and I’m doing pretty well with about 60-70 billable hours a month. Though that leaves a lot of downtime. Curious if anyone has any second businesses that require about 20 hours a week. Not looking for passive income or franchise ideas though.

like

How many employees does KGS have in total?

like

Can someone tell me about the profile for Deal Analytics – Restructuring in KGS Deal Advisory

like

Additional Posts in Excel Genius

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!

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

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..

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

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.

like

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?

likehelpful

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

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.

likesmart

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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.

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Anyone know what these badges are?

Post Photo
likefunny

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

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

like

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

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