Excel Help

[KSB2424 3,148]

I have a thousand rows of data but one collumn. Lets say its peoples names in the cells but the same name may be in 5 cells.

 

For instance:

 

drobeski

NewbieJr

KSB2424

MDC

ReclinerPilot

KSB2424

KSB2424

IGotWorms

drobeski

NorthernVike

NorthernVike

 

Is there a formula or some function that I can find and replace all of the duplicates in my spreadsheet? What I need is a full list of all the names but nobody twice.

 

Geeks?

[Brad GLuckman 519]

data tab

remove duplicates button

[IGotWorms 4,058]

With that list? Ctrl-A and delete

[KSB2424 3,148]

data tab

remove duplicates button

 

Wow, they even make it easy for you, it was right there under my nose.

 

Thanks Brad.

[KSB2424 3,148]

With that list? Ctrl-A and delete

 

[phillybear 366]

Slightly more round about, but you could do a pivot table on the column.

[frank 2,296]

Another list I didn't make.

[edjr 6,580]

With that list? Ctrl-A and delete

 

[cmh6476 1,023]

I've got a table for salary and performance review comparisons.  Can anyone tell me how to insert drop down options into cells to make it easily sortable by the various columns?

 

tia

[frank 2,296]

29 minutes ago, cmh6476 said:

I've got a table for salary and performance review comparisons.  Can anyone tell me how to insert drop down options into cells to make it easily sortable by the various columns?

 

tia

Click in the little triangle in the top left corner of the sheet (between the 1 and A). 
Click “sort and filter” on the top right. 
Click “filter”. 

[Cdub100 3,900]

Unban Dr. Obeski

[cmh6476 1,023]

29 minutes ago, frank said:

Click in the little triangle in the top left corner of the sheet (between the 1 and A). 
Click “sort and filter” on the top right. 
Click “filter”. 

I know how to sort and what not.  I'm talking about inserting drop downs so that if I share with others they are easily able to sort by the various columns.

[cmh6476 1,023]

29 minutes ago, Cdub100 said:

Unban Dr. Obeski

+1

[Nomad99 740]

Nobody excels at anything here.....

[jerryskids 6,781]

38 minutes ago, frank said:

Click in the little triangle in the top left corner of the sheet (between the 1 and A). 
Click “sort and filter” on the top right. 
Click “filter”. 

Does this paste in random music videos?

[GutterBoy 2,899]

21 minutes ago, cmh6476 said:

I know how to sort and what not.  I'm talking about inserting drop downs so that if I share with others they are easily able to sort by the various columns.

Data Validation.

Just google or ask ChatGPT for step by step

[seafoam1 3,002]

Wow. None of you know Excel. You all are old. 

[frank 2,296]

2 hours ago, jerryskids said:

Does this paste in random music videos?

Mitch Hedberg jokes. Everyone knows music videos go in SPSS.

[jerryskids 6,781]

5 minutes ago, frank said:

Mitch Hedberg jokes. Everyone knows music videos go in SPSS.

I wanna hang a map of the world in my house. Then I'm gonna put pins into all the locations that I've traveled to. But first, I'm gonna have to travel to the top two corners of the map so it won't fall down.

[frank 2,296]

13 minutes ago, jerryskids said:

I wanna hang a map of the world in my house. Then I'm gonna put pins into all the locations that I've traveled to. But first, I'm gonna have to travel to the top two corners of the map so it won't fall down.

I don’t have a girlfriend, I just know a girl who would get really mad if she heard me say that. 

[jerryskids 6,781]

3 minutes ago, frank said:

I don’t have a girlfriend, I just know a girl who would get really mad if she heard me say that. 

This guy came up to me and said, 'You're gonna have to move, you're blocking a fire exit.' As though if there was a fire, I wasn't gonna run. If you're flammable and have legs, you are never blocking a fire exit.