Search results

Can you do a quick test using different browser(s)? If still no go, it'll be helpful to whoever has to make the fix to note Browser (kind and version) Operating System

I believe you can use the magnifying glass symbol in top right of banner now. Clicking on that opened a search field for me.

It's misinterpreting your exdate. Try feeding as a serial with day, month, year explicitly called out. exdate = DateSerial(2018, 12, 10) Overall, you might change to this Private Sub Workbook_Open() Dim exDate As Date Dim mBox As String Application.Visible = False...

You have two unique pieces of info in single cell. Don't do that. ;) We could use Text-to-columns to split the data apart, using the "~" and space as delimiters. This will put one piece of info in each cell, and also convert the text to numbers. Then you could easily add the numbers. Or, if...

Please remember to include links to cross-posts in the future: https://www.mrexcel.com/forum/excel-questions/1074553-data-visualization.html#post5161910

What particular text are you looking for? Which columns/sheets should be searched? Where should the col 2 and 4 data be copied to?

In short, no. The results of formulas can not have special font formats applied to just part of the result.

Understanding the small example, it looks like you don't want to touch any of the items that have a period following the table name. In that case, for each word, I'd first do a find an replace for Find: myWord & "." Replace: "ZZZ." Then, go through and do a find and replace for Find: myWord...

Position would be: =(C1-A1)/(B1-A1)

Some sample dashboard pictures

Where would the hyperlink be taking you then, if the sheet is hidden? Wouldn't you just stay on the main sheet? EDIT: Looks like Chihiro understood better.

You're welcome, and thanks for the 'drink'! :)

Formula in B2: =TRIM(MID(SUBSTITUTE(A2,CHAR(10),REPT(" ",999),LEN(A2)-LEN(SUBSTITUTE(A2,CHAR(10),""))-2),999,999)) Formula does assume there's at least 3 lines. If you need more robustness: =IF(LEN(A2)-LEN(SUBSTITUTE(A2,CHAR(10),""))>=3, TRIM(MID(SUBSTITUTE(A2,CHAR(10),REPT("...

Don't manually type the curly brackets {} before and after the formula. When you confirm as an array, XL will add those in itself.

To clarify to future readers, this link leads to a commercial tool for use on Microsoft Excel. It is NOT designed/built by Microsoft. As the link relates to the topic question, I'll remove the flag for potential spam.

Try this Sub NewCode() Dim wsDest As Worksheet Dim tb As ListObject Dim c As Range Dim rngList As Range Dim lastRow As Long Dim lastCol As Long Set wsDest = Worksheets("Result") Set tb = Worksheets("List").ListObjects(1) Application.ScreenUpdating =...

Hi Brena. If I recall, the tool is setup to use workdays when calculating duration. My guess then is that on the DWG rec'd task, the task is starting sometime before Nov 3, then going the whole week of Nov 3, and then finishing up sometime during the week of Nov 10. Since the resolution at this...

Confirm as an array using Ctrl+Shift+Enter =MAX(FREQUENCY(IF(A1:A15=5,ROW(A1:A15)),IF(A1:A15=5,0,ROW(A1:A15))))

First paste into a new, blank sheet (can hit Ctrl+N), so that XL will deal with spreadsheet, and then copy/paste from there into Word.

This part of your formula is odd: =IF($E$5=Details!L:L, ... The IF function doesn't normally compare an entire column to a single cell. XL is interpreting this as compare E5 to the cell in col L at same row formula is in. So, in E11 of Summary sheet, it's looking at L11 on Details sheet (which...

That's a pretty odd request, as with over 250 different functions, the combinations you could do of making 64 nested levels is well into the billions. Also, with no real goal, I'm not sure why we would want to go that deep into a nested formula. I suppose a simple one would be to nest 64 SUM...

@Leonardo1234 Please do not make multiple posts about the same question. Stick to your original thread. https://chandoo.org/forum/threads/if-column-c-equal-to-d-then-delete-that-row.39527/

@Leonardo1234 Please do not make multiple posts about the same question. Stick to your original thread. https://chandoo.org/forum/threads/if-column-c-equal-to-d-then-delete-that-row.39527/

Sorry for confusion Eloise. If you have the Project expolorer open in the VBE, it should look like this. If not, go to View - Project Explorer. This is a list of all the "things" you have in your project. You can faintly see that the ThisWorkbook module is highlighted, indicating that this...

The last line of your code says this Application.OnTime xTime, "StartFlashing", , True Which is saying that after finishing, it will run again at a future time. It's this second time that's failing. Reason is that XL expects regular macros to be stored in code modules, not sheet or...