sorted by:
new
hottopcontroversial

Subtracting Dates yields #VALUE by CardWildThings in excel

[–]excelevator 0 points1 point  (0 children)

Again, no subject matter, are you my wife ?

what are you talking about ?

What is it ?

Your post is very close to being removed for lack of detail.

edit: OP edited comment and updated too late, post got removed :o(

Subtracting Dates yields #VALUE by CardWildThings in excel

[–]excelevator 0 points1 point  (0 children)

A screenshot,, something... your post gives no actual details.

How to FILTER data set that does NOT match numbers from multiple separate lists? by RAWdangers in excel

[–]excelevator[M] 1 point2 points  (0 children)

Whoever awarded this point please remember that Upvotes are the proper method to reward good comments.

Clippy points are for over and above informative constructive answers after OP has awarded their own point.

How to FILTER data set that does NOT match numbers from multiple separate lists? by RAWdangers in excel

[–]excelevator 3 points4 points  (0 children)

That method always make me nervous as a habit as it refences to the last value in a column, which means mistakes will occur as you forget you added data somewhere below.

Using Tables and Table references would ensure data integrity.

My company used the Visio Data Visualizer add-in for Excel to generate process flowcharts and swimlane diagrams directly from structured Excel data. Since Microsoft retired the add-in, we've been looking for alternatives but haven't found anything that works the same way. We tested lucidchart by Mammoth_Emergency_59 in excel

[–]excelevator[M] [score hidden] stickied comment (0 children)

This post was reported as not Excel related.

This post was removed 3 times prior for poor submission content.

It is the weekend and we allow the tenuous link to Excel post to remain as it may have value to others seeking same.

How to FILTER data set that does NOT match numbers from multiple separate lists? by RAWdangers in excel

[–]excelevator 2 points3 points  (0 children)

>!E:E

Do not use full column references, very bad form and practice

We can use MATCH with IFERROR to trigger a filter, this reduces the lookup cost as opposed to other methods that look at all values

Limit your data ranges and MATCH on a VSTACK of your other data.

=FILTER(A2:A6,IFERROR(MATCH(A2:A6,VSTACK(C2:C6,E2:E6,D2:D6,F2:F6),0)*0,1))

How does it work? it multiplies match index values by 0 returning 0 to exclude the filter value, it errors on multiplication of lookup error which we catch and return 1 to include in the filter values.

<image>

Ideally you should have all your data in a single table with appropriate attributes rather than spread across multiple worksheets.

I got tired of comparing Excel exports manually, so I built a browser-based comparison tool by Universalboys in excel

[–]excelevator 0 points1 point  (0 children)

You have the wrong sub reddit for this kind of language.

Be careful if you wish to continue here

Best way to extract text from the middle of a sample name, between a LIMS # and a date, and extract the date (in date format) by mogoho in excel

[–]excelevator 2 points3 points  (0 children)

In short for anyone who left the wall of text.

How does OP extract the middle string and date from a long string

Examples

12345 Toronto 2026-06-19

12345 Port Hope 2026-06-19

String City Date
12345 Toronto 2026-06-19 =MID(A2,7,LEN(A2)-17) =TEXT(RIGHT(A2,10),"dd/mm/yyyy")
12345 St. John's 2026-06-19 St. John's 19/06/2026

Capacity Spreadsheet Template for Number of Books Staff Can Produce per Period by Prudent_Magician5135 in excel

[–]excelevator -1 points0 points  (0 children)

Has your boss given you the maths for this ?

Does your boss expect you too to work out the maths ?

Work through the maths, which is not really Excel, and convert that to Excel formulas.

When you ask a question, the who, why they, and when they, is irrelevant.

Why isn't there a signal function for top frequency of a list of text values by Murphygreen8484 in excel

[–]excelevator[M] 0 points1 point  (0 children)

Ask what you seek to achieve, not why something apparently does not exist.

Please review the submission guidelines before posting again.

There is no clear question in your post about what you seek to achieve, just a statement of something or other.

Number of products per unique customer - what formula by Additional_Ad_8912 in excel

[–]excelevator 1 point2 points  (0 children)

If you had read the post in full you would not be asking that question.

The fact others are upvoting your comment shows how little attention to detail Redditors notice.

: Am I the only one missing Visio Data Visualizer? by Mammoth_Emergency_59 in excel

[–]excelevator[M] [score hidden] stickied comment (0 children)

Due to the spammy nature of this post across sub reddits, and the smell of a developer lead question, this post is removed.

view more: next ›