Search:

Type: Posts; User: Excel Fox

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. saw the outputs in sheet2 already - but it's not...

    saw the outputs in sheet2 already - but it's not clear how you got those outputs from keyword1 and keyword2. that's why i am asking to explain it.
  2. Can you elaborate exactly in the 3 outputs in the...

    Can you elaborate exactly in the 3 outputs in the next sheet, how was that determined
  3. Hi - not sure how the output was decided. Could...

    Hi - not sure how the output was decided. Could you explain each of the three cases.
  4. Hi, If you could attach a very small sample...

    Hi,

    If you could attach a very small sample with the keywords, or post a picture, that would help understand your requirement clearly

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA ...
  5. Replies
    13
    Views
    2,165

    A few things that helped (Character Encoding...

    A few things that helped (Character Encoding ISO-8859-1 to UTF-8)

    https://digwp.com/2011/07/clean-up-weird-characters-in-database/
    https://www.i18nqa.com/debug/utf8-debug.html...
  6. Replies
    13
    Views
    2,165

    Collateral damage I guess - but with success!

    Collateral damage I guess - but with success!
  7. Replies
    13
    Views
    2,165

    Can you test it now

    Can you test it now
  8. Replies
    13
    Views
    2,165

    Testing the sentence whether it's coming after...

    Testing the sentence whether it's coming after this ‘ OK it is displaying
  9. Replies
    13
    Views
    2,165

    Looks like it's a Windows-1252 vs UTF-8 issue. I...

    Looks like it's a Windows-1252 vs UTF-8 issue. I am sure I'll fix it - just need some time - hopefully won't break anything if I show some patience.
  10. Hi showtime, Welcome to ExcelFox. Code below....

    Hi showtime,

    Welcome to ExcelFox. Code below. If you want the working file, check out the attachment.



    Option Explicit

    Sub GetExchangeUserDetailsFromAlias()
  11. You just need to fix the formulae I gave, to...

    You just need to fix the formulae I gave, to cover for below thresholds also.

    Try using ABS()
  12. Hi Garfoid, Welcome to ExcelFox You could...

    Hi Garfoid,

    Welcome to ExcelFox

    You could use the following three criteria for you condition in B7 and just copy the format to the other rows

    RED =B7/D7-1>10%
    AMBER...
  13. Assuming this is closed here...

    Assuming this is closed here
  14. Not sure I understand that. So you're saying the...

    Not sure I understand that. So you're saying the code I sent works, right?
  15. Try this Sub CloseAllOtherWorkbooks() '...

    Try this



    Sub CloseAllOtherWorkbooks()
    '
    ' CloseAllOtherWorkbooks Macro
    ' Keep this workbook open and close all other workbooks in this instance
    '
    ' Keyboard Shortcut: Ctrl+q
  16. Try this Sub GetNSEData() Dim...

    Try this



    Sub GetNSEData()

    Dim varFilteredSource() As Variant
    Dim rngSourceRange As Range
    Dim lngRow As Long, lngCol As Long
  17. Replies
    1
    Views
    1,113

    I'll give it a try. Haven't worked with Google...

    I'll give it a try. Haven't worked with Google APIs (don't give that look ��)
  18. Yes, any file type can be attached as long as the...

    Yes, any file type can be attached as long as the full path with filename is given and it is not a file that cannot be attached even manually (ex, too big file)



    ...
  19. Replies
    2
    Views
    3,086

    Can you be a little more specific? There are many...

    Can you be a little more specific? There are many ways to create slides, and yes one of them is from Excel (I assume you meant Tables, rather than database) using VBA. But to suggest a method, you'll...
  20. Shared a new thread at...

    Shared a new thread at http://www.excelfox.com/forum/showthread.php/2388-Send-Outlook-Mail-With-Multiple-Attachments-To-Multiple-Email-IDs
  21. Send Outlook Mail With Multiple Attachments To Multiple Email IDs

    This is in continuation to a few questions from users in this thread

    Send Outlook Mail With Signature, Range From Excel and Multiple Email IDs


    Added options to include multiple attachments in...
  22. As said earlier, please use Array Formulas. Check...

    As said earlier, please use Array Formulas. Check the attached file
  23. This will do it (use as an array formula) ...

    This will do it (use as an array formula)

    =MAX(B15:K15)&"/"&MIN(IF(B15:K15=MAX(B15:K15),B14:K14))
  24. Replies
    1
    Views
    2,141

    Hi Michel You can find lots of MS Access...

    Hi Michel

    You can find lots of MS Access tutorials if you do a simple search. But to make an MRP system, you'll first need to define exactly what all you need to include in your system ex. What...
  25. Replies
    1
    Views
    1,557

    Welcome to ExcelFox. Not a VBA solution, but a...

    Welcome to ExcelFox.

    Not a VBA solution, but a simple directional example which you can expand. If you need more handholding, please revert.

    Have used a simple pivot and an array formula, but...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4