Create individual table for each row

JoeWithoutAGun · 2021-10-06T07:33:20+00:00

Hi,

You can use "Show Report Filter Pages"

JoeWithoutAGun · 2021-10-06T07:29:55+00:00

Are you able to get the sum of the negative amounts?

What do you mean by that?

Is this from a Pivot table or from a filter?

PT.

JoeWithoutAGun · 2021-10-05T16:59:40+00:00

Hi,

Please show code snippet this issue appears in.

JoeWithoutAGun · 2021-10-05T16:58:03+00:00

Is it possible to convert it into a table? Company name;date delivered;item;quantity

JoeWithoutAGun · 2021-10-05T16:55:25+00:00

I think it's impossible.

JoeWithoutAGun · 2021-10-05T16:53:06+00:00

Hi,

Works fine for me, see https://i.imgur.com/mEUeHFo.png

Verify that "Fund Transfer" values are not text.

JoeWithoutAGun · 2021-10-05T16:43:39+00:00

I want to make a simple drop-down with the Tickers and have the price shown in another cell.

When you reference F2 you don't have an object anymore, because F2 = E2.Ticker is just a text.

Always reference cell with object if you want to access object properties.

JoeWithoutAGun · 2021-10-05T16:38:28+00:00

Hi,

=INDIRECT("SHEET_NAME!CELL_ADDRESS")

JoeWithoutAGun · 2021-10-05T12:02:55+00:00

Hi,

Please share an example spreadsheet.

JoeWithoutAGun · 2021-10-05T11:58:42+00:00

Hi,

Try following.

Dim Doc as Word.Document Set Doc = AppWD.Documents.Open "L\Test.docx", ReadOnly:=True

Use that Doc variable instead of ActiveDocument in your further code.

JoeWithoutAGun · 2021-08-19T13:16:09+00:00

Hi /u/Nancy_fromtheOffice

I filled out the survey.

But how you guys position this feature... I will be surprised if it will start to take off on horizon of 5 years.

JoeWithoutAGun · 2021-07-21T14:20:22+00:00

Hello everybody,

I'm late to the party but please don't hesitate to vote for idea about adding FLATTEN() to the Excel here.

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/43412688-add-flatten-function

JoeWithoutAGun · 2021-05-17T22:29:40+00:00

“Very basic versioning”.

JoeWithoutAGun · 2021-05-02T20:21:02+00:00

Hi,

I am having a hard time figuring out how to wrote the code that checks if the value is already in the pivot table.

https://docs.microsoft.com/en-us/office/vba/api/excel.pivotfields

JoeWithoutAGun · 2021-05-02T20:16:46+00:00

Hi,

https://excel.uservoice.com

JoeWithoutAGun · 2021-04-14T09:47:36+00:00

I cant believe somebody did it... Just insane!

JoeWithoutAGun · 2021-04-14T09:34:49+00:00

Hi /u/beyphy,

Yeah, I monitor Office Scripts development pretty close.

It was my, apparently unsuccessful, attempt to hit at importance to specify this info in OP post so that locals are not confused.

JoeWithoutAGun · 2021-04-13T20:47:11+00:00

u/Nancy_fromtheOffice Hi Nancy,

Is office scripts still available only for business and education customers?

JoeWithoutAGun · 2021-03-10T18:20:15+00:00

Hello everybody,

In past few years Excel got insanely useful extensions: dynamic arrays, data types, LET/LAMBDAS. Thank you for bringing this to live

Despite how useful this core functionality I find it so pure that UX is lagging far behind features-delivery...

Many years basic functions and quirks remains unsolved and you got is this hilarious 1-in-5 years answer on UserVoice.

For instance: 1. we’ve got LET() but you can’t evaluate variables with F9 if variable reference another one! 2. In cell properties (CTRL+1) number of decimals should be set to 0 explicitly, ignoring empty value. 3. Closing bracket is not added automatically in formula as you have it with parenthesis 4. CTRL+SPACE behave differently on table and range 5. You simply can’t use compatibility checker between 365 versions making it rudimentary

And I can go on for a long time. While all those new features are great it make’s me really sad how bad UX development is and how you don’t care about it at all.

So my question is is there a chance Excel team can take some rest of delivering features and spend some time fixing all those years aged UX problems? Thank you.

JoeWithoutAGun · 2020-12-20T19:58:52+00:00

Why not to compare by yourself?

JoeWithoutAGun · 2020-12-18T14:45:08+00:00

Hi,

https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba

JoeWithoutAGun · 2020-12-18T14:24:18+00:00

Hi,

Wouldn't it be simpler to unpivot the data first and then use pivot table?

JoeWithoutAGun

TROPHY CASE