Software

Ask something
Question Locked

Excel help

0 helpful
3 replies

by symon.l

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have a excel spread sheet with about 600 entries in, There are some duplicates which take some time to find, Is there a way to get excel to group and entries with the same name together?

does that make sense? ill explain it another way i have a spreadsheet with for example

Username - date - time - logged out

This spreadsheet starts this month and has duplicate names because the users has logged in more than one, is there a way to get that username grouped into one block.

Any help would be greatly appreciated :)

3 replies

by bizzo

If you highlight the entire spreadsheet, and then from the menu, select "Data" -> "Sort".

You should then be able to sort on Username, that will group the usernames together.

by symon.l

yeah tried that already but after playing with it again it seems to have done the trick thanks for the help ::)

This discussion is closed to new replies.