Hello. i have following table https://docs.google.com/spreadsheets...it?usp=sharing
And i want to somehow automate the process that if i have any duplicate values on those Sensor no. cells it would remove duplicates and stack numbers towards H colum and row 3.
Im using MS Excel 2016
You want this in Google spredsheets or in Excel workbook?
Excel, Google spreadsheets was only for quick reference.
Excel file would be quicker reference.
Here, try this:
Hi, thank you very much, only downside is that it gives type mismatch error if there is number missing any columns top row
Edit: Actually its seems to do that randomly or i do something wrong, ok anyway, here is the excel file where i would like to have sorting on Sheet "Kalibroinpäiväliite"
Last edited by whooper; 10-03-2016 at 07:42 AM.
Hey,
I actually got this working. Now im wondering is there a way to get this work if i have letters also in those sensor numbers?
Yes. There was a problem with Bubble sort. Fixed now...
But I don't see that in your workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks