donald

Hi all, We are using the following VBA code Sub Search_and_Match() Dim sh1 As Worksheet, sh2 As Worksheet Dim lr As Long, lc As Long, col As Long, lr2 As Long Dim c As Range, f As Range, r As Range ' Set sh1 = Sheets("Sheet1") Set sh2 = Sheets("Sheet2") lr = sh1.Range("A" &...

Hi assuming I have "Driver Name: Donald Williams Jr" in Cell A1 in B1 I am looking formula that will show "Williams Jr, Donald" ...not sure if that is possible so the other option is in B1 have just "Donald Williams Jr" then in C1 "Williams Jr, Donald" thanks for the help.

I have a sting and the code below works find to return the name. I just don't understand what the numbers in the parenthesis are doing? DEMOGRAPHICS NAME: Donald J. Duck BANK: 451CS Sub trythis() Dim MyText As String MyText = Trim(Split(Split(Range("A1"), "NAME: ")(1), "BANK:")(0))...

Hi Experts! I have a project like this: <tbody> A B C D E F G H I J K L M N O P Q R S T 1 2 3 START DATE 1 JAN 18 4 END DATE 2 JAN 18...

Hello Everyone, I think my question / problem is simple but since i am still learning I need your help. I have 2 columns (ColA,ColB) ColA = Random volume of rows with some data which repeats frequently. ColB= should pick up a sequential number 1,2,3,4 for every new data in ColA. If a data...

I need a unique count of users within each week. Sample Data: <tbody> Date Name Week Number Sum of Unique Count of users each week (Need Formula for this one) Expected RESULT 2/1/2017 Donald 5 3 2/1/2017 Goofy 5 3 2/1/2017 Minnie 5 3 2/2/2017 Donald 5 3 2/2/2017 Minnie 5 3...

Hi, Im having a problem where I want to compile data from several rows into 1 single row. The data in this case is time and attendance data to upload into a payroll software. There are 9 different columns as follows: Code Code nr Code name Employee ID Employee name Number (hours/days) Type...