I need to compare a number to a string in which i only compare the number to the number in the string. For example I have a "control" number in some column that needs to be compared against the numbers in all of the other subsequent rows in that column
Rest of col
I am trying to write a macro that will take two strings, check to see if they both contain the relevant information I am looking for, and then cut/paste the string with the largest "value" to a cell within that same column. I.E. I have a URL (column A) and a Printer name (Column B) in row...
I have some data in alfanumeric form which i need to compare.
is there any way to compare alphanumeric in excel or any method to extract number from given value and compare