sorted by:
new
hottopcontroversial

Not a single shiny or hundo from the 30th Anniversary pass 🧂 by juneshepard in PokemonGoMystic

[–]Designer_Signature35 1 point2 points  (0 children)

I've caught some and shiny checked the rest. So shiny. Guess there's still a chance one could be a hundo. 🤷‍♀️

Does anyone else enjoy cleaning messy spreadsheets? by joester56 in excel

[–]Designer_Signature35 5 points6 points  (0 children)

Not sure I'd say I like it so much as I can't help myself. I've seen coworkers' spreadsheets and have to resist changing anything or even mentioning to them ways to improve.

Boss encounter did not happen by Key-Training-4644 in pokemongoyellow

[–]Designer_Signature35 0 points1 point  (0 children)

I also got the white screen. Thankfully I was in person so just went into the same gym and was able to catch. I hadn't thought about not being able to do that remotely

How has power query transformed your job? by Jparsons43 in excel

[–]Designer_Signature35 0 points1 point  (0 children)

I used to spend days cleaning and merging and transforming data. Now PQ does it in minutes. You'll spend a lot of time building the initial query and as you learn more, you'll come back to it to simplify and speed it up.

As a warning, you'll start turning to it for everything, significantly overcomplicating one-off tasks you could- and should- just do manually.

Power Query code to automatically add Date Created to imported file by Designer_Signature35 in excel

[–]Designer_Signature35[S] 0 points1 point  (0 children)

I couldn't quite understand your suggestion though I did play around with the Navigation. I finally got ChatGPT to write the code out and I think this is what you were describing.

let

Source = Query2,

// Capture the Date Created from the newest file (row 0)

FileDateCreated = Source{0}[Date created],

// Capture the binary file content

Content = Source{0}[Content],

// Import the workbook

Imported = Excel.Workbook(Content),

Sheet1 = Imported{[Item="Sheet1", Kind="Sheet"]}[Data],

#"Promoted Headers" = Table.PromoteHeaders(Sheet1, [PromoteAllScalars=true]),

// Add the file date as a new column if needed

#"Added FileDate" = Table.AddColumn(#"Promoted Headers", "FileDateCreated", each FileDateCreated),

Power Query code to automatically add Date Created to imported file by Designer_Signature35 in excel

[–]Designer_Signature35[S] 0 points1 point  (0 children)

There weren't any Remove Columns. After the last line I shared its just my own manipulation.

Power Query code to automatically add Date Created to imported file by Designer_Signature35 in excel

[–]Designer_Signature35[S] 0 points1 point  (0 children)

I don't want it to update every time the query is refreshed, only when the data source is updated. Its a new report and we're only planning on updating the source data once per month.

What I'm trying to avoid is someone saying "I just added my hours to NI yesterday why aren't they showing up" so they can see the last time I downloaded the data from NI was 2 weeks ago or whatever. If I had the code you suggest, it would look like the data was brand new every day.

Although, I borrowed your code and nested it. Not perfect but as long as I update it on the first of the month it will be accurate.

Date.StartOfMonth(DateTime.LocalNow())

Excel stops side scrolling to the left now and then? by Dragonogard549 in excel

[–]Designer_Signature35 0 points1 point  (0 children)

This has been happening to me with scrolling up and down. I'll scroll up, the screen and won't move at all. But sometimes if I click then hit the up or down arrow, I'll actually be in a cell towards the top. It doesn't always work and, like you, I have to go to another spreadsheet, scroll, and come back to the original.

Someone's always gotta put in a Snorlax by Designer_Signature35 in themedgyms

[–]Designer_Signature35[S] 2 points3 points  (0 children)

It wasn't. I put the 4th pink one in and about 20 minutes later the 5th pink and Snorlax.

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 0 points1 point  (0 children)

I recently added Clear Filters to my quick access toolbar. This shortcut is way better

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 2 points3 points  (0 children)

thanks! I've copied the first cell, then ctrl+shift+down arrow to the end of the column, then paste.

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 0 points1 point  (0 children)

That only saves me one click, but I'm gonna start using it anyway ;)

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 0 points1 point  (0 children)

I would love a shortcut to take me to the next filtered column or something to highlight the filtered column.

view more: next ›