# Call in the Cavalry - 2018

1. ## Re: Call in the Cavalry - 2018

OP is missing Excel formula features in a recent purchase that includes Office 365. Since I have almost never used the Function Arguments dialogue I couldn't help.

Anyone?

https://www.excelforum.com/excel-for...ml#post4953640

2. ## Re: Call in the Cavalry - 2018

It works on my test sheet, but not on the his supplied sheet (complete with merged cells and a colour scheme to drive you mental):

https://www.excelforum.com/excel-for...l-columns.html

Counting DISTINCT values in multiple non-contiguous ranges. I get integers as the result on my sheet, but on his (which has a horrendous link to external data) I get a non-integer result. Going boggle-eyed. Any ideas?

3. ## Re: Call in the Cavalry - 2018

Anyone know anything about data tables (TABLE as an array)?

This one has me stumped: https://www.excelforum.com/excel-gen...t-working.html

5. ## Re: Call in the Cavalry - 2018

Any Ideas on this Mac VBA problem?

https://www.excelforum.com/excel-pro...h-problem.html

6. ## Re: Call in the Cavalry - 2018

I hate to post this one because I feel like I should be able to solve it (and I suspect I'll do a face-palm when I see what solves it).
but here https://www.excelforum.com/excel-gen...ket-share.html
So the OP wants the "adjusted share" values in col D to be adjusted in col E in order for col E to add to 100% BUT ONLY if you do not adjust the values that are in col D that are at 0.50%.
So essentially he wants E5:E8 to adjust so that all of E5:E14 sums to 100%.
What I proposed hit the 100% but it also adjusted the values in E9:E14 to less than 0.50% which he wants locked in.
So you might think it should proportionally distribute the first four values among the remaining 97% but that gets me close but I'm still off .05%.
And I expect that the formula has to account for a varying # of companies.
I'll be looking forward to what is proposed as my brain is fried dealing with work and different attempts at this solution.

7. ## Re: Call in the Cavalry - 2018

I think Get and Transform is the way to handle this one: https://www.excelforum.com/excel-pro...-cvs-cell.html but the OP is skeptical. Anyone with more familiarity with Get and Transform either back me up (or shoot me down)?

8. ## Re: Call in the Cavalry - 2018

Conditional formatting in Excel 2011 for Mac -- I guess it is not the same as the Windows versions. https://www.excelforum.com/excel-for...ml#post4973743 Can anyone more familiar with the Mac environment help?

9. ## Re: Call in the Cavalry - 2018

Strange invisible "character" in a text import file. Fields in the same row following the offending field advance to the next row upon import into Excel. CODE/MID doesn't show anything, but arrowing through the field in Notepad indicates something is there.

https://www.excelforum.com/excel-gen...ml#post4975113

10. ## Re: Call in the Cavalry - 2018

The OP wants to sort based on two columns (date and time). We cannot seem to communicate clearly.

Maybe I am missing something.

Too frustrated to continue here:
https://www.excelforum.com/excel-gen...en-time-2.html

11. ## Re: Call in the Cavalry - 2018

63, I think we all know that feeling really well! Cudo's to you for "walking away" and asking for help, rather than just leaving the OP hanging - thank you for that

12. ## Re: Call in the Cavalry - 2018

Of course. Although I'm afraid that you just caught yourself in the whirlpool. Good luck!

13. ## Re: Call in the Cavalry - 2018

haha hopefully not. It is amazing how 2 people can explain the exact same thing to the same person - OP cant understand the 1st person, but can understand the 2nd. Seen that so many times before, and have been both the 1st and 2nd person

14. ## Re: Call in the Cavalry - 2018

OK, I have a strange 1 here. OP is trying to mark a thread SOLVED, and shared a screen shot of the top of their window.
https://www.excelforum.com/excel-cha...n-a-range.html
post #6.

It looks nothing like what I see, I thought maybe they were not logged in, but they are. Im now waiting for an answer to see what device they are using.

15. ## Re: Call in the Cavalry - 2018

That does appear to be the headings when "What's new" is selected, not sure how the OP was able to have it selected inside the thread.

EDIT:Now that I look at it closer, the OP was not in the thread.

Page 7 of 11 First ... 5 6 7 8 9 ... Last

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1