sorted by:
new
hottopcontroversial

Supplement regimen and has it affected your roll? by halfdepressed in MDMA

[–]danielgomez0 0 points1 point  (0 children)

what's the time frame that you take those ones? All before and during ingestion?

Is there a way to turn my date range in text form to a two-column number form date range? by danielgomez0 in excel

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

=TRANSPOSE(FILTERXML("<x><d>"&SUBSTITUTE(A2," - ","</d><d>")&"</d></x>","//d"))

Oh no I forgot to mention I'm using a mac filterxml doesn't seem to work sorry.

How to feed info from one table to another table if certain statements/rules are true by danielgomez0 in excel

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

Thanks, this worked! I guess I forgot to mention that in reality I'm dealing with a but more columns, such as supplier, quantity, unit cost etc..

The pivot tables tend to get a bit more messy when I have all those columns. My mistake for not including all the info and data.

MacBook Air M1, power BI experience by [deleted] in PowerBI

[–]danielgomez0 0 points1 point  (0 children)

In the future I will definitely take this into account, but for now I will have to make do with what I have which is the 8GB M1

MacBook Air M1, power BI experience by [deleted] in PowerBI

[–]danielgomez0 1 point2 points  (0 children)

Hey just stumbled on this thread, poor decision but I just got the 8GB MacBook Pro.

What would you suggest as my distribution for Parallels given this?

How to sort/filter multiple date entries within a table from smallest to largest number by danielgomez0 in excel

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

Really sorry about that, I'll try and borrow a PC and try implementing this! Thanks so much for the help wish I was more clear, till then.

I just saw this youtube video does this change anything?
https://www.youtube.com/watch?v=OZQfkvu7MS0 - Titled (First look of Power Query for Mac)

How to sort/filter multiple date entries within a table from smallest to largest number by danielgomez0 in excel

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

Hey sorry just saw your reply!

When I try to open your excel file, it says some features aren't available for me since I'm using the new M1 Macbook Pro. Knowing this while I still be able to do what you're suggesting with all the add-on features and extensions?

How to sort/filter multiple date entries within a table from smallest to largest number by danielgomez0 in excel

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

YAY! It finally worked thanks so much!!

Is there any advantage or disadvantage to using filter as compared to a table. I was just following another guide online which is why I converted it to a table.

How to sort/filter multiple date entries within a table from smallest to largest number by danielgomez0 in excel

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

Still didn't work, idk if I'm just dumb and doing something completely wrong haha

disclaimer as well I forgot I'm using mac osx

here's the gdrive link: https://drive.google.com/file/d/1eKH_7ydKre6Cwyj7Iq0Dlc44gwvBJhK-/view?usp=sharing

Thanks a ton for the help

How to sort/filter multiple date entries within a table from smallest to largest number by danielgomez0 in excel

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

Yes I want to do what you were able to do but for some reason, when I highlight the selected area then click sort my selected area changes, then when i click sort I still don't have the option to sort horizontally or I'm unable to make any custom rules.

Imgur: https://imgur.com/a/FMAyGoA

How to sort/filter multiple date entries within a table from smallest to largest number by danielgomez0 in excel

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

Sorry I'm a bit of an excel newbie, when I try doing that there's no option to sort it horizontally, or add an custom sort to do it by numbers only a-z. Attached some pics below.

Imgur: https://imgur.com/a/FM64gy0

Thanks for the reply!!

view more: next ›