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.
Type: Posts; User: Excel Fox
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.
Can you elaborate exactly in the 3 outputs in the next sheet, how was that determined
Hi - not sure how the output was decided. Could you explain each of the three cases.
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 ...
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...
Collateral damage I guess - but with success!
Can you test it now
Testing the sentence whether it's coming after this ‘ OK it is displaying
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.
Hi showtime,
Welcome to ExcelFox. Code below. If you want the working file, check out the attachment.
Option Explicit
Sub GetExchangeUserDetailsFromAlias()
You just need to fix the formulae I gave, to cover for below thresholds also.
Try using ABS()
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...
Assuming this is closed here
Not sure I understand that. So you're saying the code I sent works, right?
Try this
Sub CloseAllOtherWorkbooks()
'
' CloseAllOtherWorkbooks Macro
' Keep this workbook open and close all other workbooks in this instance
'
' Keyboard Shortcut: Ctrl+q
Try this
Sub GetNSEData()
Dim varFilteredSource() As Variant
Dim rngSourceRange As Range
Dim lngRow As Long, lngCol As Long
I'll give it a try. Haven't worked with Google APIs (don't give that look )
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)
...
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...
Shared a new thread at http://www.excelfox.com/forum/showthread.php/2388-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...
As said earlier, please use Array Formulas. Check the attached file
This will do it (use as an array formula)
=MAX(B15:K15)&"/"&MIN(IF(B15:K15=MAX(B15:K15),B14:K14))
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...
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...