User Profile
Rich99
Iron Contributor
Joined Jan 02, 2019
User Widgets
Recent Discussions
Re: Unable to sort a column of dates in Excel for Mac 2016
Jim_Cross Hi Insert a column and try using this formula,=DATEVALUE(MID(A3,5,2)&"/"&LEFT(A3,3)&"/"&RIGHT(A3,4)) Then copy and paste special so your just left with the date values, then sort using Oldest to Newest or visa versa. Example attached2.6KViews0likes1CommentRe: EXCEL DATE
SUDHAKAR-FRONTIER Rather than converting the text to a date value why not enter a date, such as 01/01/2021 then custom format the cell as "mmmm" result equaling "January". As dates are stored as numbers, in this case 44197, it is then easy enough to do "<=" or ">=" calculations. Rich1.4KViews0likes0CommentsRe: VBA to Autosize an Excel note is not working for me on MAC/365 works on Windows/Excel v10
Mark_Smith_007 Mark, Spent a long time looking at this, gave up a couple of times as being undoable. It appears that on a Mac autosize does not work. I looked at various macros other people had done and ended up butchering one to work with comments. Even then there is still some guess work involved. In a nut shell the Mac copies the comments text, places it into a cell on a temporary sheet, sizes the cell with to the same width as the comment, the calculates how many lines of text there are then multiplies that by the text size in pixels to get the height of the comment. Not 100% accurate but nearly gets it right. Rich2.5KViews1like2CommentsRe: IFS function with sheet link
Just checked the Microsoft web site where they have the following note under the IFS description, Note: This feature is available on Windows or Mac if you have Office 2019, or if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office. Richard2.4KViews0likes6CommentsRe: Unable to format Time
Hi Eklavya I have attached a solution to get the correct time for you, you should have perhaps explained better the format of the time column as it would have been easier to work out. you will see that it all depends on the length of the time values. I have used IF statements to decide the number of digits and apply the appropriate format. =IF(LEN(C1)=1,TIME(0,0,0),IF(LEN(C1)=3,TIME(0,MID(C1,1,1),0), IF(LEN(C1)=4,TIME(0,LEFT(C1,2),0),IF(LEN(C1)=5,TIME(LEFT(C1,1),MID(C1,2,2),0),TIME(LEFT(C1,2),MID(C1,3,2),0))))) Richard1.2KViews0likes0CommentsRe: Excel Question on a Mac
Hi Richard_James I have attached your files with two solutions for the box for adding comments. The filter for the bold is slightly more difficult. Excel has a sort option for cell colour but not for Bold font. It would need a macro writing to do that and I am not sure if you want to go down the route. See https://trumpexcel.com/filter-bold-font-formatting-in-excel/ for possible solutions Richard1.4KViews1like1Comment
Recent Blog Articles
No content to show