Assigning a number to like row values

[Colombo]

I'm not sure if this can even be done, but you guys know your stuff, so I figured I'd ask

I've got a column of values. The values are subject headings like: "I need help with" "What's wrong" etc.

What I would like to do is sort through that list and assign a numbered value for a particular subject heading.

So for any "What's wrong" headings, it would put a "1" in the column next to it.

I'm basically converting some old info from a forum into a new format.

Thanks in advance for any help.

Josh

 

[Aladin Akyurek]

Do you have a pre-set numbering system, that is, a table that associates each heading with a unique number?

 

[2rrs]

deleted

 

[Colombo]

No, no preset table.

Like I said, this was an old forum type setup. So for the most part, everything is going to be sorted by date.

I could just dump everything into the new format as a new thread for each row, but it'd be nice to combine the appropriate threads into a single topic rather then having x number of same posts.

I was figuring that once I get all the rows in, I would sort ascending by date, and if I could pull off what I want to do, have it generate the numbers starting from 1.

Once the numbers are assigned I should be able to tweak them if need be.

Josh

 

[Mark W.]

Book1
	A	B	C	D	E	F
1	What'swrong	1
2	Ineedhelp	2
3	Thehellwithyou	3
4	What'swrong	1
5	Hey,goodlook'n	5
6	Ineedhelp	2
7
8
Sheet2

 

[Colombo]

That's pretty cool!

Thanks Mark

Josh

 

[Colombo]

Got another quick question here.

I've used the match function and it works good. I'm however now looking to group the like topic id's. So let's say I have 5 2's, 4 3's, and 6 4's. I only want to display one row of 2's, one row 3's, etc.

I messed around with a pivot table and round aboutly got the layout I needed, but I wasn't sure if this is the easiest way to do this.

If a pivot table is the way to do it, let me know and I'll play around with it some more.

Thanks

Josh

 

[Aladin Akyurek]

Got another quick question here.

I've used the match function and it works good. I'm however now looking to group the like topic id's. So let's say I have 5 2's, 4 3's, and 6 4's. I only want to display one row of 2's, one row 3's, etc.

I messed around with a pivot table and round aboutly got the layout I needed, but I wasn't sure if this is the easiest way to do this.

If a pivot table is the way to do it, let me know and I'll play around with it some more.

Thanks

Josh

Some possible methods are described here

http://www.mrexcel.com/board2/viewtopic.php?t=8659

 

[Mark W.]

Sort the list based on the Field2 value (below). Then AutoFilter where Field3 equals 1...

Book1
	A	B	C	D	E
1	Field1	Field2	Field3
2	What'swrong	2	1
3	What'swrong	2	0
4	Ineedhelp	4	1
5	Ineedhelp	4	0
6	Thehellwithyou	6	1
7	Hey,goodlook'n	7	1
8
Sheet3

 

[Colombo]

Thanks Aladin & Mark.

I'll probably use a combo of those suggestions.