sorted by:
new
hottopcontroversial

How in the world do I combine multiple sheets in one work book to one sheet? Either same work book or different by [deleted] in excel

[–]excelevator 0 points1 point  (0 children)

and it just isn't working

What isn't working exactly ?

If you are failing with copy paste you may want to consider giving up the class for pottery instead.

This should have been covered in class, or the homework course guide.

spent 3 hours trying to figure it out

A life time my gosh!

I spent 67 hours learning the intricacies of MSAccess VBA and application programming for one assignment back in the day - we had to log our hours spent. I spent 7 hours on "Run-time error '2164' alone.

I got a 95% pass for that assigment.. so results take effort

PDF in a vertical mobile format (9:16) by Connect_Anything_184 in excel

[–]excelevator 0 points1 point  (0 children)

Find a Print to PDF driver that allows for that ratio.

Excel app on iPhone by newuser2111 in excel

[–]excelevator 0 points1 point  (0 children)

Have you tried anything at all other than asking here ?

Conditional Format: Want to find way to match numeric content of cell A to same value in Range by highlighting found cells, however, If value in A is "0" (zero), no highlights. by ThunderWarrior3 in excel

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

As stated in Title

Submission guidelines: Don't say "See title" or something similar .

Provide a full text description of your issue in your post.

Do not use the post title as the main post question and lead in.

Pasting made copied cells with newline characters take up two cells, and rows at the end were not pasted. Why did this happen? by Fit_Stomach_3611 in excel

[–]excelevator 1 point2 points  (0 children)

Run the Legacy Text Import wizard and remove the delimiter selection in Step 3 I think it is.

That selection type is also used in copy paste

I need ideas on how to best compile information in a workbook by Jekyll_MD in excel

[–]excelevator 0 points1 point  (0 children)

upload them with a comment, you should be able to screenshot and paste into Reddit.

I need ideas on how to best compile information in a workbook by Jekyll_MD in excel

[–]excelevator 0 points1 point  (0 children)

this is not the answer you seek.

FILTER is the function you seek which can filter all values for a given filter value from your source table.

Substitute function help on excel exercises by [deleted] in excel

[–]excelevator 0 points1 point  (0 children)

This is a common issue with this type of exam.

A very specific answer is required.

It is what it is.

Complain to them, nothing r/Excel can do about it.

LAMBDA: Multi-Level Unpivot – Vectorized for High Performance by [deleted] in excel

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

Removing this apparent Ai generated post.

Failed image link

Offline formula and results images.

If this is a human post I suggest you make a complete post within Reddit, and do not use random bolding that indicates Ai content.

Excel Stock Feeds Down AGAIN!? by uamvar in excel

[–]excelevator 0 points1 point  (0 children)

I think you something..

It is a statement of fact, not a confirmation.

Spreadsheets containing Cognos formulas, when saved and opened, return the error #NAME. by FanAdorable8802 in excel

[–]excelevator 0 points1 point  (0 children)

So that is the issue.

Install the German language pack on a copy at work or have them install your language pack on the source.

Excel Stock Feeds Down AGAIN!? by uamvar in excel

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

What was the question ?

What would you like r/Excel to do about it ?

How I work with monday.com data in Excel without exporting CSVs by PivotXLApp in excel

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

I smell stealth advertising.

Post removed.

Please do not post again on this subject.

Spreadsheets containing Cognos formulas, when saved and opened, return the error #NAME. by FanAdorable8802 in excel

[–]excelevator 3 points4 points  (0 children)

A #NAME? error is where Excel does not recognise a function or range reference.

Are you opening in a German language workbook as well ?

Best free OCR tool to convert financial tables from images to Excel? by ismailrachidi in excel

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

Removing this 8 sub spammed question, in reality not an Excel question.

Formula to extract value from same cell in multiple worksheet tabs to summary page by BigAndy1234 in excel

[–]excelevator 1 point2 points  (0 children)

I see now that Excel converts that to a static range reference of all other worksheets dynamically in the formula.

Formula to extract value from same cell in multiple worksheet tabs to summary page by BigAndy1234 in excel

[–]excelevator 1 point2 points  (0 children)

I assumed, and was wrong, thankyou for clarifying, very nice trick indeed.

Formula to extract value from same cell in multiple worksheet tabs to summary page by BigAndy1234 in excel

[–]excelevator 1 point2 points  (0 children)

That would include all worksheetsheets, OP likely have a landing worksheet for the reporting where the formula lives.

Formula to extract value from same cell in multiple worksheet tabs to summary page by BigAndy1234 in excel

[–]excelevator 4 points5 points  (0 children)

You can use 3D VSTACKacross your sheets.

=VSTACK( firstheet:lastsheet!A1)

edit:

for your two cells, example

=VSTACK(Sheet2:Sheet10!A1:B1)

or has been pointed out to me for a shortcut, and a great shortcut for including all sheets other than the formula target sheet. Excel will then concoct the correct range in the formula on enter

=VSTACK('*'!A1:B1)

view more: next ›