-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
uid
-
M
LARGE Formula & Return value from MATCH
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...- mtyrrell13
- Thread
- field formula large match uid
- Replies: 8
- Forum: Excel Questions
-
V
Only copy cells value based on UID
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...- VbaHell
- Thread
- dim i.value j.value long uid
- Replies: 1
- Forum: Excel Questions
-
R
How to insert numbers in a column (between blank rows)
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)...- rudolphrc
- Thread
- battery column radio truck uid
- Replies: 4
- Forum: Excel Questions
-
P
...not even sure how to describe it...
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...- pierre robinson
- Thread
- date pfts0011 set table uid
- Replies: 1
- Forum: Excel Questions
-
help with shell cmd net user
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""...- DippNCope
- Thread
- cmd macro run uid user
- Replies: 0
- Forum: Excel Questions
-
A
Type mismatch error with use of cdate
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...- Ark68
- Thread
- cdate date mismatch type uid
- Replies: 3
- Forum: Excel Questions
-
F
VBA Copy and paste date and add a comment
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...- Fiveshorter
- Thread
- cell.offset0 complete qty uid vba
- Replies: 0
- Forum: Excel Questions
