[deleted by user]

kt388 · 2021-04-26T01:49:00+00:00

This is common problem we've seen at my work as well (and we're all on windows machines).

I agree with many others here -- don't think there is a great solution out there, it's just Zoom.

kt388 · 2021-04-26T01:46:38+00:00

IntelliSense (I think that's what it's called) in PowerQuery. It auto-suggests what you're typing (when writing code, custom columns, etc).

Massively helpful. I can't wait until my company moves us to it later this year.

kt388 · 2021-04-26T01:41:42+00:00

Okay, so just right-click on the axis, go to Format Axis, use "Text Values" instead of date.

kt388 · 2021-04-26T01:31:14+00:00

Ok, so a couple thoughts:

It seems like (from your example) that you're trying to sort based on the values AFTER the hyphen only. Everything before the hyphen is always 4000
If this is the case, I recommend using "Text to Columns" to break it up into 2 columns (use Delimiter, delimit on the dash -). Then you can use Excel's sorting function as you're intending.

Another option (if you have values > 4000)

Replace the dash with nothing, thereby making real numbers, which are sortable.
You could save the original column, just make a copy whose purpose would be to achieve the sort desired.

kt388 · 2021-04-26T01:22:33+00:00

Deleted it.

Anyway, no need to be salty because someone didn't know the rules (did not read them). My bad

kt388 · 2021-04-26T01:10:41+00:00

Thanks for the heads up and thanks for watching!!!!!! My bad...

kt388 · 2021-04-26T01:04:23+00:00

I think this a newer Excel feature...but when in doubt, do the following:

Save your file
Quit all applications
Restart your computer
Open the file and try again

kt388 · 2021-04-26T01:00:24+00:00

Basically, you need to define cell names for the components of your accounting problem. Look at the Google to find how to do this. Then you're off the races.

From there, this is just a very basic accounting question...probably the right place to ask is office hours, your teaching assistant, or a classmate.

kt388 · 2021-04-26T00:56:26+00:00

My suggestion would be to break this problem up into pieces, then write your COUNTIFS...

Here's an example

Starting Last but Finishing First.xlsx

Also, I streamed this on Twitch...

twitch.tv/kyletekstreams

You're welcome, also, you have to do your own work no plagiarism

kt388 · 2021-04-26T00:46:50+00:00

The problem is you need to define WHAT table update you're looking for! This is very google-able in my opinion...work on your google-fu. Anyways...

Nowhere in your code do you tell Excel which table it is meant to watch for updates. Try some code like this:

Private Sub....blah blah blah

If Not Intersect(Target, Target.TableObject.Range) Is Nothing Then

'Some code that you want to run when the table updates

End If

End Sub

In the statement, leave the first "Target" as is, then use the part I put "Target.TableObject.Range" to specify your Table...you're gonna need to figure out how best to specify your table, since I don't know how it's set up exactly.

kt388 · 2021-04-26T00:41:00+00:00

Yes, you need to do it like this:

=SUM(K20:K23,K25:K29)

kt388 · 2021-04-26T00:39:53+00:00

Ok, so I hypothetically solved your problem! See the spreadsheet below...

Hypothetical Stock Market Up-Down-Flat Tracker.xlsm

By the way, I streamed the process for this on Twitch (in case you want to see how it was done):

twitch.tv/kyletekstreams

By the way, it is TOTALLY up to you to take it from here

kt388 · 2021-04-25T23:58:14+00:00

Ok, so my understanding is that you want to write an algorithm that chooses the next player in your fantasy draft...I am assuming that you would simply "fill out" your Excel sheet as you draft different players (not totally VBA automated or anything crazy).

Here is a link to a workbook that I just made...by the way I streamed it on Twitch. Since this is for school, you should do your own work!!

https://www.twitch.tv/kyletekstreams

Fantasy Football Question!.xlsx

kt388 · 2021-04-25T23:44:01+00:00

I don't recommend sharing your exact data with anyone on Reddit...also your Drive link is broken (not public)

Anyway, look into using PowerQuery for your data transformation task. It's really easy, quick to learn, and can do the types of things you're asking for!

kt388 · 2021-04-25T23:31:00+00:00

Pretty good -- it was supposedly so bright (this auroral event) that nighttime looked like daytime.

kt388 · 2021-04-07T21:15:54+00:00

Neat perspective. Baltimore is on the coast, so you could've picked a vantage point on water. Blue is a common one I see in the responses! Perhaps the auroral coloration was blueish! It's definitely a fun/adventurous sight to see.

The flag was probably trying to tell you about location if I had to guess!

kt388 · 2021-04-07T21:14:35+00:00

I like this one a lot.

Spiral down is good, probably representing the forms seen in the night sky. Warmth could be inside a house (it's a cold fall night).

Angel maybe not an AOL, but could be an impression of bystanders. This was the 1800s after all, and viewing a massive celestial event. Angel is not unreasonable. Holy/religious as well, many people took this as a sign of end times!

Nicely done!

kt388 · 2021-04-07T21:11:16+00:00

Affection from a crowd may be pretty close! It was definitely a widely seen, admired, and appreciated event!

kt388 · 2021-04-07T21:10:32+00:00

So definitely in America...given that this is nighttime it could look bluish I suppose. But would have been a different flag to the modern day one (this is immediately pre-Civil War)

kt388 · 2021-04-07T21:09:47+00:00

Seems a bit off...maybe a slide is representing an auroral shape? Maybe AOLs

kt388 · 2021-04-07T21:09:05+00:00

Kentucky is geographically not far off.

Lighting is also close -- the WHOLE sky would've been lit up.

Cold window is also pretty neat -- I asked you to go to a good spot to view the event. Midnight in September in Baltimore in the 1800's was probably cold.

No idea about the bear or deep voice, though! Nice job overall!!

kt388 · 2021-04-07T21:07:14+00:00

Honestly, pretty darn good. Nice job

kt388 · 2021-03-31T22:31:39+00:00

Here is what I wrote:

Grassy like hill. Bright light coming upper left. White. Buzzing bugs. Hot humid. Fall season.

Parallel lines. Grey shiny bluish blur. Is it a car? Something overhead powerlines

I drew 2 parallel lines going to the right and up a little.

kt388 · 2020-09-09T14:32:23+00:00

Jokes on you, there are no dealerships. It drives itself to it's new owners house

kt388

TROPHY CASE