I INCOMETAX111 Member Oct 25, 2024 #1 hii i have some data as a list in and i want to extract similar nearest data by formula. any can help me please ? i want to extact just like 12=14,56=58 1214195658202508 Attachments similar data extract.png 9.1 KB · Views: 7
hii i have some data as a list in and i want to extract similar nearest data by formula. any can help me please ? i want to extact just like 12=14,56=58 1214195658202508
P Peter Bartholomew Well-Known Member Oct 25, 2024 #2 Code: = LET( sorted, SORT(numbers), first, DROP(sorted,-1), next, DROP(sorted, 1), paired, HSTACK(first, next), diff, next - first, min, MIN(diff), FILTER(paired, diff=min) )
Code: = LET( sorted, SORT(numbers), first, DROP(sorted,-1), next, DROP(sorted, 1), paired, HSTACK(first, next), diff, next - first, min, MIN(diff), FILTER(paired, diff=min) )
I INCOMETAX111 Member Oct 26, 2024 #3 Peter Bartholomew said: Code: = LET( sorted, SORT(numbers), first, DROP(sorted,-1), next, DROP(sorted, 1), paired, HSTACK(first, next), diff, next - first, min, MIN(diff), FILTER(paired, diff=min) ) Click to expand... sir that formula is used for excel or google sheet or any others ?
Peter Bartholomew said: Code: = LET( sorted, SORT(numbers), first, DROP(sorted,-1), next, DROP(sorted, 1), paired, HSTACK(first, next), diff, next - first, min, MIN(diff), FILTER(paired, diff=min) ) Click to expand... sir that formula is used for excel or google sheet or any others ?
AliGW Well-Known Member Oct 26, 2024 #4 It's for Excel. If you wanted a GoogleSheets solution, you should have mentioned this in the opening post. Please provide a sample workbook (attached here if it's for Excel, or a link to an editable copy on GoogleDrive if it's for GoogleSheets).
It's for Excel. If you wanted a GoogleSheets solution, you should have mentioned this in the opening post. Please provide a sample workbook (attached here if it's for Excel, or a link to an editable copy on GoogleDrive if it's for GoogleSheets).