uid

I have the below Formula using LARGE and right now it returns the largest value in the column, but the Column is a UID field and I am just using it to determine unique value, I want to somehow wrap this formula with and INDEX / MATCH array and first use LARGE to find the largest UID, then using...

Hello all I have this code which copies over values from the active worksheet to a sheet called "Actions" under the next available line if the value in "G" is equal to "A" Can anyone help me please, I want to also only copy over only unique lines. (UID) "B & E" together would be the UID but I...

I have an excel document with 8000 + rows with 23 columns and desire to populate the UID column with a number with everything associatedwith that item (between row breaks). What formula can I use to populate the UID column automatically insequential order?(I’ve populated thedata shown below)...

Evening all. Im trying to sum up costs for maintenance work on a property between date ranges I have 2 sets of data: The first set of data, Table A, has a Unique ID and a start and finish date for the work set out in rows. The second set, Table B, has the same Unique ID, multiple invoices...

Hello, I have a list of user ID's in column C. I am trying to find when thier AD passwords expire. I would like to run a macro to run the command net user This is what I have so far UID = Range("C2").Value RetVal = Shell("""cmd.exe """" /domain " & UID & " | findstr ""Password expires""...

Perhaps I'm using cdate incorrectly. I wish to take the text date from a userform control ("processdate") and convert it to date serial. me.processdate.value="Tuesday, January 23, 2018" My code: Private Sub Label834_Click() Dim uid uid = CDate(processdate.Value) End Sub I am getting...

Hi, I have a vba macro that compares uid in two sheets, once the uid match then i compare the QTY, if the QTY do not match the vba returns incomplete and if they do then it is complete. In my file i have a sheet with the list of uid to be run and also in the next column i have specific dates...