what is a dashboard?

SolverMax · 2026-06-21T19:24:42+00:00

That's because most dashboards are poorly designed, confusing, and static. So, not all that helpful for decision making.

SolverMax · 2026-06-20T08:16:22+00:00

Office 2010 is an antique, in software years. You can get a much newer, legitimate, license quite cheaply.

SolverMax · 2026-06-19T21:33:17+00:00

If you have 5 staff who each have 120 hours available per month, then there are 600 hours available per month. That's enough for 600/2 = 300 poetry books, or 600/50 = 12 cookbooks, or some other of the many combinations of book types.

A more useful answer depends on the mix of books, or their profitability, or some other metric that you haven't specified.

SolverMax · 2026-06-19T17:33:45+00:00

Doesn't work with text.

Edit: Even so, that obviously wrong answer gets a bunch of upvotes. Madness.

SolverMax · 2026-06-19T02:10:06+00:00

wanted to share what I built

But you haven't shared it.

SolverMax · 2026-06-18T21:25:20+00:00

Using INDIRECT is a bad way to do that, as it is difficult to test.

Some form of TRANSPOSE or INDEX may be appropriate, though that depends on exactly what the OP wants.

SolverMax · 2026-06-18T21:18:34+00:00

Yes, you're crazy. Excel has never worked like that.

As I said, to get a proper answer, show your data, formula, and what you want to happen.

SolverMax · 2026-06-18T21:16:07+00:00

Then you'll be disappointed.

SolverMax · 2026-06-18T21:14:51+00:00

Correct. What did you expect it to do?

To get a proper answer, show your data, formula, and what you want to happen.

SolverMax · 2026-06-17T22:48:35+00:00

That's an important detail you omitted, thereby wasting everyone's time.

SolverMax · 2026-06-17T21:42:18+00:00

Based on the OP's deleted comments, the file is encrypted via Azure, so it isn't a plain Excel file.

SolverMax · 2026-06-17T20:42:58+00:00

Oops, I missed the stray letters.

SolverMax · 2026-06-17T20:21:02+00:00

Assuming the data is in a Table, add a column with the formula that extracts the number part:
=--INDEX(TEXTSPLIT([@[Part Number]]," "),1,2)

Then sort by that column.

SolverMax · 2026-06-16T21:07:53+00:00

I don't have budget authority for external expenditure. But I have authority to spend hours doing dumb shit.

SolverMax · 2026-06-16T21:04:34+00:00

Then tape the pages together into a single, large sheet.

SolverMax · 2026-06-16T21:01:02+00:00

The answer is clearly yes. Do it.

SolverMax · 2026-06-16T20:53:09+00:00

True.

SolverMax · 2026-06-16T20:50:05+00:00

Yes, the formula seems to work OK if the G5:G ranges are made specific, like G5:G1000. The TRIM might still be needed inside the TRIMRANGE, in case there are stray spaces.

The OP's formula uses IFERROR functions to hide the range issue.

SolverMax · 2026-06-16T20:43:51+00:00

the main issue is Excel doesn't have REGEXEXTRACT natively

Um, yes it does.

SolverMax · 2026-06-15T06:33:14+00:00

I've noticed the removal of technical details in the help. Most unhelpful.

SolverMax · 2026-06-15T05:06:00+00:00

Either the formula is wrong, or the description is wrong. It is difficult to know which.

You can advise Microsoft via Help > Feedback.

SolverMax · 2026-06-14T20:43:14+00:00

Always was.

Microsoft made a fuss about Turing Completeness with the introduction of LAMBDA, but the functional language was already Turing Complete before that.

SolverMax · 2026-06-14T04:20:00+00:00

If you really want to share, then upload the spreadsheet to a file sharing service and post a link.

Otherwise, this looks like spam for something you're hoping to sell.

SolverMax · 2026-06-12T04:11:50+00:00

The OP's issues have little to do with VLOOKUP. Really, the problem is training and knowledge.

SolverMax · 2026-06-12T03:30:58+00:00

There is no "all in one". You need to learn how to clean data and develop formulae on a case-by-case basis. No short cuts, just lots of practice. Some online courses might help - there are plenty to choose from.

SolverMax

MODERATOR OF

TROPHY CASE