LinkBack URL
About LinkBacks
Hi,
how to sort text data without helper column? Results are in U7:U16 like these: S-11, S-9, S-14, S-7.... How to sort them?
Here is the formula:
Please Login or Register to view this content.
Hi,
how to sort text data without helper column? Results are in U7:U16 like these: S-11, S-9, S-14, S-7.... How to sort them?
Here is the formula:Please Login or Register to view this content.
Last edited by B.W.B.; 08-26-2024 at 04:05 AM.
Where's the sample workbook?
We shouldn't be having to ask for one ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks for the woorkbook.
Text strings like S-10 and S-6 are not numbers, do son't sort numerically. Instead, they sort alphabetically, and as such, S-6 is after S-10 and S-11. You can mitigate this by changing the serialisation thus:
S-06
S-10
S-11
Because 0 is before 1 in alphanumeric terms, 06 will sort above S-10.
Is there always S- ?
Here are few results for your question assuming there is S- at the start.
If that's not case I would suggest reorganize data or use helper column because it's very complicated for older version of excel.
Your solution is in X column
zbor zbor zbor zbor zbor zbor zbor zbor
Spremnik 23 i S-2, they don+t have value in "J" column. I could/must use a helper column with "random" S-14, S-9, S-10... values, then we could use AGGREGATE(Countif formula in U7:U16, right??
Wasn't focus on J column. I've just add few more S's for purpose of test
So here is the formula for "helper" column:w/o ctrl+sh+entPlease Login or Register to view this content.
So now i need to sort these helper column results into U7:U16, thank you all, GOD BLESS
There is already sorted in X column without helper column.
What I understand next is to create SUMIF formula, right?
Try this:
Please Login or Register to view this content.
This looks like "slow on calculation", my poor CPU.Originally Posted by Phuocam
Nothing to Sum, just some text results from E col
thanks, hvala puno!
This will sort results from U7:U16 :Thank you ALL, Thanks forum, Thank you zbor AliGWPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks