Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hello, Does anyone have any suggestions for creating an excel formula for finding the difference between two strings of numbers that are separated by commas, but are not in ascending order? For example, the formula output of "5,7,1,3" and "3,7" would be "1,5" or "5,1". I know this could be done by VBA using the split function and some sorting, but I hope there might be a clever excel formula that can do this all in one step, perhaps involving the substitute or some other build in excel function Thanks Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Transposing a Long String | Excel Worksheet Functions | |||
Delemited string | Excel Worksheet Functions | |||
How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Add a string to a cell | Excel Worksheet Functions |