Extracting text within a Cell range based on conditions.

Trying to wrap my head around if this can be done via excel. Wanting to extract text data within column B based on mathematical conditions. The conditions would be based on Column G and in descending order (Most expensive to less expensive). Based on that condition, try to find relevant words within Column B that stands out and create a report showing terms, etc.


Untitled-45.png

This would be the desired Output shown below of the findings based on what the spreadsheet was able to find or do. This was based on the sample csv data file image above. Wouldn't have to be that fancy, just enough for us to find these costly words hidden in thousands of lines of text.


Untitled-46.png


Can someone tell me if this is possible and if so, guide me in the right direction on how to accomplish this?

Thanks
Dan

Welcome to the board.

Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.

@shg,

I read the guidelines and since I am not fully understanding your point.

I went back and edited my first post, hopefully with more descriptive details.

I tried to post images to what we are wanting to accomplish, but maybe not explaining it properly.
If you could ask or tell me specific questions or things you'd like to see, please let me know.

Thanks

I was referring to this, Daniel:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

Much better, thank you.

Now you can post a workbook instead of a picture.

At the bottom right of the textbox in the Reply dialog is a button labeled Go Advanced. Push that, and scroll down to Manage Attachments.

If that doesn't work, put the workbook on box.net or dropbox, and post a link.

OK.

Now, what are you trying to do? Find the average something-or-other for each of the words in col B?

Here are the words that appear 20 or more times in that column:

	A	B	C
4	1	furniture	751
5	2	poly	696
6	3	chairs	561
7	4	outdoor	540
8	5	adirondack	466
9	6	olso	353
10	7	exampleco	348
11	8	amish	326
12	9	glider	230
13	10	chair	210
14	11	patio	185
15	12	wood	175
16	13	table	137
17	14	in	132
18	15	gliders	107
19	16	lumber	102
20	17	made	100
21	18	for	84
22	19	sale	79
23	20	rocker	78
24	21	rocking	78
25	22	porch	71
26	23	bench	70
27	24	resin	68
28	25	recycled	66
29	26	and	63
30	27	pa	60
31	28	with	60
32	29	lawn	57
33	30	dining	55
34	31	tables	55
35	32	cape	53
36	33	composite	53
37	34	set	52
38	35	bar	51
39	36	cod	51
40	37	deck	51
41	38	swing	46
42	39	pollywood	43
43	40	white	42
44	41	lancaster	39
45	42	benches	38
46	43	folding	35
47	44	of	35
48	45	swivel	35
49	46	collection	33
50	47	double	33
51	48	buy	32
52	49	sets	31
53	50	decking	29
54	51	high	29
55	52	swings	29
56	53	ohio	28
57	54	to	28
58	55	weather	28
59	56	best	27
60	57	on	27
61	58	out	26
62	59	picnic	26
63	60	adirondak	25
64	61	back	25
65	62	club	22
66	63	com	22
67	64	rockers	22
68	65	all	21
69	66	garden	21
70	67	beach	20
71	68	from	20

You could use a formula to returns the average of some column where a given term appears in col B:

	S	T	U
1	Term	Avg
2	furniture	1.82	T2: =AVERAGEIF($B$2:$B$2658, "*" & S2 & "*", $I$2:$I$2658)
3	poly	1.35
4	chairs	1.67