Sorting issue

[Ram Mher]

Please find the attached sheet and solve the query.

 

[Luke M]

In col H, create a helper column. Give a header of any choice. Formula in H2:
=MATCH(G2,$A$2:$A$90,0)

Sort G:H using col H.

 

[Ram Mher]

In col H, create a helper column. Give a header of any choice. Formula in H2:
=MATCH(G2,$A$2:$A$90,0)

Sort G:H using col H.

It is good when we have to sort the data in excel sheet. Please find the attach and sort the data in pivot table. Also guide how it shall work.

 

[Ram Mher]

i do not know the reason why file is not being attached. please suggest

 

[Deepak]

i do not know the reason why file is not being attached. please suggest

First check the file size/formats & still having issue then send it to me i will upload to the post.

 

[Ram Mher]

First check the file size/formats & still having issue then send it to me i will upload to the post. imdkbj at gmail dot com

i have forwarded the file on your gmail id to upload at chandoo.

 

[Deepak]

i have forwarded the file on your gmail id to upload at chandoo.

Uploaded in ur first post.

 

[Jake Collins]

Dear Ram Mher

You could create a custom list in excel to achieve this purpose. This website should explain how to do this.

https://support.office.com/en-gb/ar...ing-data-d1cf624f-2d2b-44fa-814b-ba213ec2fd61

 

[Ram Mher]

Dear Ram Mher

You could create a custom list in excel to achieve this purpose. This website should explain how to do this.

https://support.office.com/en-gb/ar...ing-data-d1cf624f-2d2b-44fa-814b-ba213ec2fd61

the same tried but message reflecting that your custom lists is having more than 255 characters so custom list can not be created.