Search results

Hello This should work =IF(ISNUMBER(MATCH(A2,B:B,0)),VLOOKUP(A2,A:C,3,FALSE),"")

Hello One Quick question to understand the issue better is: Are there any duplicate EmployerID values in the LearningPlan table, or is each EmployerID unique to a single employer?

=IF(AND(A2>=TIME(18,0,0),B2<TIME(6,0,0)),B2-A2,IF(OR(A2>=TIME(18,0,0),A2<TIME(6,0,0)),TIME(6,0,0)-A2,0)) Assuming your start time is in cell A2 and end time is in cell B2, you would place this formula in the cell where you want the result to appear. Adjust the cell references as needed for...

Hi Check this versionand let me know any challenges Sub ExtractData() Dim ws As Worksheet, Sh As Worksheet Dim LR As Long, i As Long, j As Long Dim Arc As Variant, Arr As Variant Dim LS As Long, x As Double Dim SupNam As String Application.ScreenUpdating = False...

Try this code modified Sub Open_Email() ' Create email template Dim objOL As Object Dim Msg As Object Dim olInsp As Object 'Outlook.Inspector Dim wd As Object 'Word.Document Dim mail_Object As Object Set objOL = CreateObject("Outlook.Application") Set...

Hello Soul Try this! =IFERROR(INDEX('Incoming Register'!$B$2:$E$100,MATCH($A2,'Incoming Register'!$A$2:$A$100,0),COLUMN()),"")

Not sure, what i was doing did wrongly posted as reply...Apologies

=IFERROR(IF(AND(VLOOKUP(L2, Source!A:D, 4, FALSE) = H2, L2 <> ""), TEXT(IFERROR(IFERROR(VLOOKUP(L2, Source!A:J, 9, FALSE), VLOOKUP(L2, Source!A:J, 10, FALSE)), "MM-DD-YYYY"), ""), "")

Sorry i too realised, but unable to delete it...Apologies

Sub Addresses() Dim newHostReport As Worksheet Dim sourceReport As Worksheet Dim newHostRange As Range Dim sourceRange As Range Dim newHostCell As Range Dim sourceCell As Range Dim ipAddress As String Dim matchFound As Boolean Set newHostReport =...

Hello Alan Thank you so very much for the power query solution, Though i do not prefer to use as got use to VBA very much. But having seen these few lines written by you....Amazing it works blink of the eye. Please help me in case if we need to mention file path rather then current workbook...

It's great to hear that you were able to make the necessary adjustments to the VBA code, and that it's working as expected now. If you have any more questions or need further assistance with VBA or any other Excel-related tasks, feel free to ask!

Hello Sambit Certainly! Power Query is a powerful tool in Excel that allows you to transform and manipulate data. To replicate your formula-based solution using Power Query: 1. Select any cell within your data range B5:J24. 2. Go to the "Data" tab in the Excel ribbon. 3. Click on "Get Data"...

Hello I think there might be an issue with the formula or the way coordinates are being handled. The Haversine formula is sensitive to the units of measurement used for latitude and longitude. Ensure that your coordinates are in the correct format (usually decimal degrees) and that your...

H Hello Marc it works and faster am atill wonder after splitting 5thbcolumn in into rows rest of the columns should be auto filled.....so rhat entire data should look like perfectly as table with no nulls

Agree Mr Marc...Yiu the best Mentor..

I have tried building the following Code and still under Testing Sub SplitIPAddresses() Dim ws As Worksheet Set ws = ActiveSheet Dim LastRow As Long Dim i As Long Dim j As Long Dim ipArray() As String Dim r As Range Dim numRows As Integer ' Disable screen...

Hello experts, Attached Excel for reference Please help me to split the Merged cell into rows dynamically and autofill the rest of the columns. Currently holding 3000 line items. Attached file contains sample of 2 rows

Set ws = ActiveWorkbook.Sheets("Consolidated") lastrow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row Set rng = ws.Range("N6:N65") For i = 6 To lastrow If ws.Cells(i, 4).Value <> "" Then startDate = ws.Cells(i, 7).Value endDate = ws.Cells(i, 8).Value ws.Cells(i...

Praduma - If you've forgotten the password for macros in VBScript, it's generally not possible to recover or change the password directly. Password protection is intended to secure code, and bypassing it without the correct password would violate security measures.If you have access to the...

Thanks for the partial code...please find below modified version Dim ws As Worksheet Dim lastrow As Long Dim rng As Range Dim startdate As Date Dim endDate As Date Set ws = ActiveWorkbook.Sheets("Consolidated") lastrow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row Set rng = ws.Range("n6:n65")...

Hello Sheelaamk For now, Am guessing sample data is missing =COUNTIFS(A:A,">="&TODAY(), B:B,"<18:00")

Hello Sheelaamk Trying to explain from scratch, in case if you are not aware. To lock a specific cell containing a formula within a table and ensure the formula is automatically applied to new rows, you can follow these steps: 1. Lock the Cell: - Select the cell containing the formula...