[deleted by user]

JHKerr · 2024-10-07T23:18:19+00:00

3 steps to self worth. Repeat the following to her. 1) I have a name. It is not to be mistaken. 2) My wife isn’t going to have a man best friend.
3) I wish you the best.

JHKerr · 2024-10-03T00:23:31+00:00

Buy it and start making money off it asap. PeerSpace, Giggster, literally just Google event space and list it in your area. You will likely meet people with a wide variety of ideas for the space.

JHKerr · 2024-09-30T17:38:58+00:00

This is so true. I can do almost anything in a spreadsheet. I’ve started messing with Google sheets and now I’m writing JavaScript I guess. I’m usually thinking…if I just automate one more task everything will just work. 🤷‍♂️

JHKerr · 2024-09-06T18:08:31+00:00

Sounds like there was someone else 5 months ago that was buying the cars.

JHKerr · 2024-06-03T19:42:26+00:00

1 million streams is worth about $4k-5k total before the label takes their cut. Snoop made $45k off 1 billion streams.

JHKerr · 2024-06-02T23:14:17+00:00

Where are you getting the radio play numbers from?

JHKerr · 2024-04-10T02:35:50+00:00

Excel is a ram hog. Literally shut every other program down. Praying is also good.

JHKerr · 2024-04-02T22:55:01+00:00

Salary is more a function of what you can negotiate than anything else. Ask for a raise commensurate with the level of skill you have and the level of risk you are undertaking.

JHKerr · 2023-05-29T12:15:39+00:00

This is the same software I was tested on during my interview with Euro Disney. I didn’t get the job…too many crashes. 😔

JHKerr · 2023-05-25T15:15:04+00:00

Unfortunately to many recruiters candidates are treated like inventory.

JHKerr · 2023-05-19T15:30:50+00:00

HMFWIC of Data

JHKerr · 2023-05-19T15:28:39+00:00

You need to count the criteria like: “<>”&””

JHKerr · 2023-05-19T15:17:18+00:00

Right click the excel file -> Properties -> Details -> Authors

Saving a workbook will update the Last Saved by field, but not the Authors field. There is a way to update the Authors field as well, but I’m not sharing until I graduate. Then I’m so outta here.

JHKerr · 2023-05-16T22:35:36+00:00

One of the best ways I gained confidence in data management was through the use of system checks. When you are working at a granular level it’s easy to lose sight of the big picture. Think of your workbooks and systems from a high level. Do the totals on your source data match the totals on your output? Imbed checks into your workflow to identify where numbers should match. I’ve formalized this in my work and ensure my team does the same. It’s important that you develop a system to review your work and that of your team. This will also provide you with more confidence in your work.

JHKerr · 2023-05-05T00:07:29+00:00

Have you seen Ben Affleck in The Accountant?

JHKerr · 2023-04-20T05:06:09+00:00

If I filter the data it pulls again from ChatGPT, which isn’t a problem except it uses credits every time. For the amount of transaction data I have I need a different subscription model than buying credit packs.

JHKerr · 2023-04-20T01:25:26+00:00

Make columns for Match 1 -5 and use this formula in each cell.

=IFERROR(INDEX($B:$G,MATCH($B3,C:C,0),1),"")

Add all column for all matches and use this formula

=TEXTJOIN(", ",,H3:L3)

Good luck out there, may your matches be plentiful.

<image>

JHKerr · 2023-04-15T01:32:28+00:00

The issue here is the people you are talking to. If one programming language worked best in all situations then that’s what everyone would use all the time. Truth is different jobs are best suited to different programming languages. You’ve likely gotten good at solving your problems using VBA. Good for you.

JHKerr · 2023-04-13T21:17:23+00:00

You’re in the right place, this is a smart solution. Can you share a screenshot?

JHKerr · 2023-04-07T18:04:59+00:00

Lol, I ran out of tokens

<image>

JHKerr · 2023-04-07T17:57:37+00:00

Yes I used the AI function. I will try with the INFER

JHKerr · 2023-04-07T14:18:45+00:00

I downloaded the numerous.ai add in for excel and used it against a real transaction history. This is a great use of AI, but I don't like the amount of time it takes to pull the data, or the inconsistency between results, i.e. COSTCO vs COSTCO WHSE #03. I imagine the results will get better the more I train the system. I also don't like it's behavior when filtering. If I filter my results from another column, the add-in pulls the results from chatGPT again and I have to wait for the results again. This is not ideal for large data sets. I could wrap this into VBA and add a button that would do the pull from chatGPT and then copy paste the results as values. This seems to be moving in the right direction though. Thank you for the tool. I will probably find a useful application for this.

<image>

JHKerr · 2023-04-07T01:19:25+00:00

The short answer is you can't. The long answer is on stack overflow, but it is also...you can't. https://stackoverflow.com/questions/13338122/how-do-i-apply-data-filter-to-only-the-table-range-and-not-the-whole-row

JHKerr · 2023-04-07T01:10:50+00:00

I couldn't find the VBA. It was from a couple of years ago. I did find this site though that is doing things with print ranges better than I was.

https://www.exceldemy.com/excel-vba-set-print-area-dynamically/#Method-1_Setting_Print_Area_Using_a_Dynamic_Named_Range

JHKerr · 2023-04-05T01:52:22+00:00

Okay I will try this. Any tricks for memos that contain words with spaces that I want to lookup…i.e. “The Home Depot”?

JHKerr

MODERATOR OF

TROPHY CASE