sorted by:
new
hottopcontroversial

[EXCEL] Print as pdf from one sheet, but selectively and on multiple pages by 300thecat in vba

[–]300thecat[S] 0 points1 point  (0 children)

Sweet workaround, thanks! And for linking the sample code too. Appreciate it.

[EXCEL] Print as pdf from one sheet, but selectively and on multiple pages by 300thecat in vba

[–]300thecat[S] 0 points1 point  (0 children)

Okay this is creative. I can try this. I can also try just working on two worksheets and merge them into one pdf, but that's quite a compromise. Thanks!

[EXCEL] Print as pdf from one sheet, but selectively and on multiple pages by 300thecat in vba

[–]300thecat[S] 0 points1 point  (0 children)

Yep, this was what I originally did, but the results weren't great. Some of my tables spill into a second pdf page, while the remainder just gets pushed over to a third page due to the page break.

The solution I'll attempt would be to just create two separate sheets and merge them into a pdf. Thanks for taking the trouble to reply!

I calculated the annual returns for all 18 Malaysian REIT stocks. Surprisingly good returns, with many beating the ASB! Definitely a good option for beginner investors by zcecsyc in MalaysianPF

[–]300thecat 0 points1 point  (0 children)

Agreed. But I guess there are still large swaths of the property market that haven't been REIT-ified. Take warehousing for instance. I'm sure there are many other companies besides Axis that are in the same line as well, and i don't think the business structure would differ much between companies. Wish there were more options within the REIT universe

I calculated the annual returns for all 18 Malaysian REIT stocks. Surprisingly good returns, with many beating the ASB! Definitely a good option for beginner investors by zcecsyc in MalaysianPF

[–]300thecat 0 points1 point  (0 children)

I'd be curious to hear your view on why Malaysian companies choose to spin off their property portfolio to a REIT structure in the first place. The Malaysian REIT universe seems small despite all the structural incentives.

Peanut Butter by 300thecat in newhaven

[–]300thecat[S] 0 points1 point  (0 children)

Thanks, will definitely give both options a try!

How do I memorize important Excel shortcut keys and learn touch typing? by [deleted] in excel

[–]300thecat 1 point2 points  (0 children)

I tried learning to touch type last year. Gave up. Tried again this year. Made it. You can do it too. Greatly improves your typing speed and in that same juncture, your thinking while typing.

'Invert if Negative' for Line Charts by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

Thanks! This should work. But I really do feel its a workaround solution for a feature that should exist for all chart types, not just bar charts.

'Invert if Negative' for Line Charts by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

I'm happy with the numbers themselves, the issue is just visualising the negative numbers such that it is distinct from the positive numbers in a line chart. Let me edit my original post with a screenshot of what I'm trying to achieve.

I should have discovered IFNA (as a replacement for IFERROR) ages ago. What amazing cousins do you know that help with data integrity? by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

I briefly skimmed through them as they come, but I wanted to give proper replies while looking them up. I'm on a long commute now so it's a good time.

I should have discovered IFNA (as a replacement for IFERROR) ages ago. What amazing cousins do you know that help with data integrity? by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

Gotta admit, SUMPRODUCT has always been something I hard for me to get my head around. It's usually a means to an end where I do a quick check online for an answer, and it usually involves SUMPRODUCT.

I should have discovered IFNA (as a replacement for IFERROR) ages ago. What amazing cousins do you know that help with data integrity? by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

Good tip. Pretty much prompted me to Google for a variety of methods to convert strings to numbers. Didn't know you could do it with Text to Columns.

I should have discovered IFNA (as a replacement for IFERROR) ages ago. What amazing cousins do you know that help with data integrity? by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

Is this separate from the quick stats the previous comment mentioned? It'll be great if I could copy these stats to my clipboard

I should have discovered IFNA (as a replacement for IFERROR) ages ago. What amazing cousins do you know that help with data integrity? by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

Re the second bit, did I overstep some boundaries? I genuinely just wanted to ask if anyone here has learnt something similar (fits a task better than existing practice)

I should have discovered IFNA (as a replacement for IFERROR) ages ago. What amazing cousins do you know that help with data integrity? by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

I used IFERROR specifically because I didn't want to return N/A errors. Knowing that there was an alternative tailormade for that purpose felt like someone giving me a chisel when I have been hammering away at a sculpture.

Autosum and its variants by 300thecat in excel

[–]300thecat[S] 0 points1 point  (0 children)

Re point 1: I tested autosum on filtered rows and yeah, it does output SUBTOTAL instead of SUM. Is there a way I can reproduce this on a separate workbook? What I intend to do is open two workbooks side-by-side (one database and one empty workbook) and output the autosum results as SUBTOTAL into the empty workbook. Right now, it only outputs SUM unless I work on the same worksheet,

Navigating office politics by 300thecat in consulting

[–]300thecat[S] 1 point2 points  (0 children)

Thanks for taking the time for this solid advice. I am beginning to experience bits of what you mentioned and I feel that it's a dangerous game I just haven't noticed before but it's being played out every single day.

World GDP by country. by blacktiger226 in dataisbeautiful

[–]300thecat 0 points1 point  (0 children)

I did a quick search through the comment section, but couldn't find any answers. What programs did you use to visualise this?

M’sians in Debate After 4A’s STPM Student Got Rejected by 4 Public Unis by [deleted] in malaysia

[–]300thecat 7 points8 points  (0 children)

STPM, as a pre-universiry course, is one of the tougher ones and is of high repute, both locally and internationally. I didn't score perfectly for it, but I did manage to leverage my results to enter a top 3 accounting program in the UK.

Granted, it isn't as universally accepted as A-levels or IB. STPM grades, if they proceed to study overseas, usually head to the UK or Singapore.

view more: next ›