Wanting sort to be done by data of end of cell in column D for example. Is
there an easy way of doing this? Not an expert with spreadsheets by any means.
Thanks.
Wanting sort to be done by data of end of cell in column D for example. Is
there an easy way of doing this? Not an expert with spreadsheets by any means.
Thanks.
The easiest way would probably be to insert a new column next to D and
extract the portion of data that you want to sort on. For example, if you
wanted to sort based on the last 4 characters in Column D, you'd enter this
formula in the new column:
=RIGHT(D1,4)
Then perform your sort on this new column.
HTH,
Elkar
"Copper" wrote:
> Wanting sort to be done by data of end of cell in column D for example. Is
> there an easy way of doing this? Not an expert with spreadsheets by any means.
> Thanks.
>
Do you mean you have characters or numbers at the end of your data, and
you want to sort on these rather than the full data? You can use RIGHT(
) in an extra column to extract a certain number of characters from the
data in another column, and then include this column in your sort range
and sort on this column. After the sort you can delete the extra
column.
Hope this helps.
Pete
Thanks guys, worked like a charm. Can't believe it was that easy. Like I
said, not an expert by any means. Great forum, great responses. Again
thanks.
Copper wrote:
> Wanting sort to be done by data of end of cell in column D for example. Is
>there an easy way of doing this? Not an expert with spreadsheets by any means.
>Thanks.
Thanks for the feedback.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks