User Profile
davheili
Brass Contributor
Joined Jan 19, 2021
User Widgets
Recent Discussions
Re: Re-Notify recipient of unread message
Thank you Christian. "Urgent" may be as close as possible to what I'm looking for. Unfortunately, in most cases, I don't usually want to re-notify of a message unless it goes unread for a significant amount of time. I was just hoping that there was a re-notify option available that I was simply missing. I think I'll send a suggestion.5.3KViews0likes1CommentRe: Display number based on number of days past cell date
Try this to address the Blank Cells and Not happened yet situations: =LET(WeekDiff,ROUNDUP((TODAY()-N4)/7,0), IF(ISBLANK(N4),"", IF(WeekDiff<=0,0, IF(WeekDiff<=4,WeekDiff,"Graduated"))) ) To refence cell M4 instead of tod, just change "Today()" to M4 Like this: =LET(WeekDiff,ROUNDUP((M4-N4)/7,0),2KViews0likes1CommentRe: Display number based on number of days past cell date
Here are two other variations: =IF(INT((N4-M4)/7)<4,INT((N4-M4)/7)+1,"Graduated") Or if you have an "Up-To-Date" Microsoft (Office) 365 subscription, a slightly faster version would be: =LET(WeekDiff,INT((N4-M4)/7), IF(WeekDiff<4,WeekDiff+1,"Graduated") ) I'm making the assumption that your 22-29 was really intended to be 22-28.2.1KViews0likes4CommentsRe-Notify recipient of unread message
I have noticed that sometimes recipients of chat messages do not show as having "Read" the message. I'm guessing that in most cases it's because they missed the pop-up notification. Is there a way to get Teams to re-notify the recipient of a missed message? Something that I (as the sender) can trigger. And maybe the opposite too, like a setting that re-notifies me if I don't miss a message after X minutes or hours. ThanksRe: Leading zeros
I'd like to offer one other alternative to DKoontz formula. I've always been one for simplicity, so I sometime use something like this: =RIGHT("00000" & A2,5) This will work for any length number up to 5 digits long. And has the added benefit of formatting the result as text so the leading zeros don't disappear again.1.7KViews1like2CommentsRe: csv data separated by comma and space
jbell61 You are correct, Excel import wizard does not split a single line into multiple rows. So I see 2 possible options: 1) Use a text editor like Notepad++ to edit the CSV file and do the line breaks at the spaces. Save. Then reopen the CSV file in Excel. 2) if the file is a short file, you could import all the data into 1 cell. Then use Data / Text to Columns to split the data at the space character. That will create multiple columns where the data was split at the space. Then Copy all the data, Paste Special / Transpose will change the column data to Row data (but all data will still be in only 1 column. Finally select the column data - Data / Text to Columns again but this time delimited by comma.21KViews0likes2CommentsRe: Switch Workbooks functions
BoBoSlacke If your old PC had O365, then I don't really have an explanation. I believe the last version of Excel that had supported MDI was 2007, which pre-dates O365. Here's a link to an Excel UserVoice forum discussing the elimination of MDI. You can see that Ctrl-Tab is mentioned in the suggestion. https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/11706627-restore-mdi-file-handling-open-all-files-in-one-w738Views0likes1CommentRe: Switch Workbooks functions
BoBoSlacke I suspect that you may have been using a very old version Excel. With your new PC, you also upgraded to a new version of Excel. Here's a description of Ctrl-Tab Ctrl+Tab : Switch to the next child window of a Multiple Document Interface (MDI) program Your description lines up perfectly with the MDI interface. MDI was removed from Excel quite a while ago in favor of SDI interface. As a result, Ctrl-Tab won't keep flipping thru any more. As a workaround, you may need to use Alt-Tab, which will tab thru all open apps.722Views0likes3Comments
Recent Blog Articles
No content to show