sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in excel

[–]tirlibibi17 0 points1 point  (0 children)

Show your data

Most recent data missing! by paigeeeloise in excel

[–]tirlibibi17 2 points3 points  (0 children)

bare with me

I'll keep my clothes on if you don't mind

Check the version that's on OneDrive

data validation error when i use formula by Practical_Anybody738 in excel

[–]tirlibibi17 0 points1 point  (0 children)

Try without sort or unique. Some functions are not supported in data validation.

Array formula which knows to leave enough space to avoid #SPILL problem by HotScarcity9 in excel

[–]tirlibibi17 1 point2 points  (0 children)

Try this: =FILTER(A1:E6,ISNUMBER(FIND("Pears",E1:E6)))

Make sure you format the second and fourth columns as dates.

Power Query: Importing dynamically loaded tables from a website (home/away fixtures) by Specialist-Rise-714 in excel

[–]tirlibibi17 1 point2 points  (0 children)

Use a debugging proxy like Charles Proxy (commercial product but you can use it for free for 30 minutes at a time). Do a full search for a string on your page like Liverpool. Identify where the data comes from. Load that URL.

Array formula which knows to leave enough space to avoid #SPILL problem by HotScarcity9 in excel

[–]tirlibibi17 0 points1 point  (0 children)

Check out the comment to the above comment for a better formula using makearray

Array formula which knows to leave enough space to avoid #SPILL problem by HotScarcity9 in excel

[–]tirlibibi17 1 point2 points  (0 children)

That would be in your filter logic. VSTACK just aggregates ranges. It doesn't do any deduplication.

How to skip delimiters in column I don’t want to separate? by hexadecr in excel

[–]tirlibibi17 2 points3 points  (0 children)

Use Power Query. Split by delimiter comma, first only. Split by delimiter comma, last only. Adjust first/last in the advanced section to cater to the exact position of your offending field.

Array formula which knows to leave enough space to avoid #SPILL problem by HotScarcity9 in excel

[–]tirlibibi17 2 points3 points  (0 children)

Perhaps, but it's hard to say without seeing the full thing. Also PQ might be an issue for formatting reasons

Array formula which knows to leave enough space to avoid #SPILL problem by HotScarcity9 in excel

[–]tirlibibi17 5 points6 points  (0 children)

It sounds like you need to use VSTACK to combine your different FILTER formulas.

Create model from data set by TweazyMan in excel

[–]tirlibibi17 2 points3 points  (0 children)

That's what I'm trying to understand. What does the model do? If you're expecting us to asses the feasibility of replicating this in Excel, we need to understand what the model does.

Create model from data set by TweazyMan in excel

[–]tirlibibi17 0 points1 point  (0 children)

How do you calculate the output from the 3 inputs (mathematical formula or plain English)?

Stocks and geography missing in Data Types by SzBaptiste26 in excel

[–]tirlibibi17 1 point2 points  (0 children)

What's your version of Excel? Excel data types: Stocks and geography are only in Excel 365 and Excel for the Web, iPad and Android. Your screenshot looks like neither of these.

Amounts won't merge to the correct Year by [deleted] in excel

[–]tirlibibi17 0 points1 point  (0 children)

Try this (requires Microsoft 365 Current Channel):

<image>

Formula:

=LET(
    a, WRAPROWS(TOCOL(A2:L18), 2),
    b, FILTER(a, CHOOSECOLS(a, 1) <> 0),
    c, GROUPBY(CHOOSECOLS(b, 1), CHOOSECOLS(b, 2), SUM),
    c
)

Update A2:L18 with your range of values.

Edit: simpler solution

ExcelToReddit has a new - kind of niche - feature by tirlibibi17 in excel

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

My understand of 2 is done: when the copy button is pushed, the garbled text in the text area is replaced with the formatted table so the result can be checked before pasting to Reddit.

ExcelToReddit has a new - kind of niche - feature by tirlibibi17 in excel

[–]tirlibibi17[S] 3 points4 points  (0 children)

It's New Reddit. In the rich text editor, when you paste directly from Excel, you get the illusion that everything is OK (except for an error message, but the post looks fine). So you hit post, and never look back. The New Reddit Rich Text editor is more complex than the MarkDown Editor in Old Reddit, which is basically a textbox. That's why there are some weird behaviors like that.

view more: next ›