Hi,
I have sorting problem.. When I am sorting excel file by Field1 then The value of field2 and field3 is duplicated by the value of first row. Can any one help. I have attached the excel file.Book1.xlsx
The result I am getting after sorting the file..After Sorting.xlsx
Last edited by kevalkothari; 06-19-2012 at 02:41 AM.
You need to specify that your table has headers.
You can do this using "Custom Sort".
I have already tried doing that. But still I am getting same problem.Originally Posted by dip11
You aren't doing it correctly then.
See screenshot:
Thank you very much for your response gain.
I have doing the way you have shown in your response jpg image. But I am getting duplicated values in Field2 and Field3. See the screenshot.Result.jpg
Please kindly help me!
Hello
I think you just want to sort the field#1 and NOT Field#2 and Field#3 along with it.
sort.GIF
now if your sorting that includes fields#2
your sort is correct (it's not duplicating the field it's that its the correct values that goes along with the sorted field#1..
as a proof i extracted (thru copy/paste this 4 consecutive sorted values #1#2#3 fields)
they have really same fields #2 and Field#3 values
A,S,M, Werbeagentur GmbH (ASM) info@asm-muenchen.de www.asm-muenchen.de AGENTA Werbeagentur GmbH info@asm-muenchen.de www.asm-muenchen.de Aimaq von Lobenstein Creative Brand Consulting GmbH info@asm-muenchen.de www.asm-muenchen.de argonauten G2 GmbH info@asm-muenchen.de www.asm-muenchen.de
hth.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi All,
I have Tried all the way but still not getting the correct data and correct solution. Is there any viruses that are doing this?
Can you provide an example of how you would like the data to look like so we can better understand what you are asking?
If you sort the data as is, the result you and we are getting is correct. However it seems that you want to get rid of certain entries?
Note that for a number of the Field 1 entries, the Field 2 and 3 entries are meant to be the same. I.e. certain companies are run by the same organization.
Thanks to All.
Finally dip11 has focused my head on the actual value of the field. He is right there is no any duplication in sorting but the values are like which seems to be duplicated.
Again very much thanks to dip11,vlady.
Glad this worked out for you!
Remember to mark the thread as solved and award rep points to those you deem worthy.
Last edited by dip11; 06-19-2012 at 12:21 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
kevalkothari 
Register To Reply
Bookmarks