How to return a whole column based on conditions

[marc01]

Hi all.

Hoping someone can help.

Looking to return multiple results based on an if condition. I have a column of xy coordinates and I am looking to return certain coordinates depending on the content of other cells in other columns within the table.

Any help would be much appreciated.

Thanks

Marc

 

[Peter_SSs]

Since we have no idea of what your data looks like, what your conditions are etc, what about some sample data and expected results (XL2BB) with explanation?

I also suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[marc01]

Hi Peter,

Thanks for the info....new to the forum and hadn't downloaded the add-in etc. Have done so and here is an example of the data range I am using....

Book1.xlsx
	A	B	C	D	E	F	G	H
1	1st serve outcome	1stServeX	1stServeY	2nd serve outcome	2ndServeX	2ndServeY	S/R	Point won by
2	In	33	30				Returning	Rafael Nadal
3	In	61	30				Returning	Rafael Nadal
4	Error	42	27	In	36	30	Returning	Novak Djokovic
5	In	62	31				Returning	Rafael Nadal
6	In	44	30				Returning	Rafael Nadal
7	In	50	34				Returning	Rafael Nadal
8	In	65	35				Returning	Novak Djokovic
9	Error	39	27	In	47	32	Returning	Rafael Nadal
10	Error	55	53	In	58	38	Returning	Novak Djokovic
11	In	50	32				Returning	Rafael Nadal
12	Error	73	32	In	63	40	Returning	Novak Djokovic
13	In	45	33				Returning	Rafael Nadal
14	Ace	31	31				Returning	Novak Djokovic
15	In	58	30				Returning	Rafael Nadal
16	In	45	35				Returning	Novak Djokovic
17	In	64	30				Returning	Novak Djokovic
18	Error	47	25	In	44	34	Returning	Rafael Nadal
19	Error	65	52	Double fault	61	26	Returning	Rafael Nadal
20	Error	63	27	In	60	30	Returning	Novak Djokovic
21	In	48	33				Returning	Rafael Nadal
22	In	67	32				Returning	Novak Djokovic
23	In	37	36				Returning	Novak Djokovic
24	Error	55	52	Double fault	80	27	Returning	Rafael Nadal
25	Error	43	53	In	47	31	Returning	Rafael Nadal
26	In	67	31				Returning	Novak Djokovic
27	In	46	33				Returning	Novak Djokovic
28	Error	33	28	In	41	30	Returning	Rafael Nadal
29	In	65	33				Returning	Novak Djokovic
30	In	44	29				Returning	Novak Djokovic
31	In	65	35				Returning	Novak Djokovic
32	In	49	35				Returning	Novak Djokovic
33	In	60	33				Returning	Novak Djokovic
34	Error	45	27	Double fault	48	52	Returning	Rafael Nadal
35	Error	72	32	In	67	30	Returning	Rafael Nadal
36	In	45	34				Returning	Rafael Nadal
37	In	62	35				Returning	Rafael Nadal
38	In	43	36				Returning	Rafael Nadal
39	In	69	31				Returning	Novak Djokovic
40	In	33	34				Returning	Rafael Nadal
Sheet1

I would like to use the XY coordinate in a scatter chart, and will have a drop down menu to make this data interactive.

I would ultimately like to plot the XY coordinates based on whether the player was "serving" or "returning", and also whether the point was won by "Rafael Nadal" or "Novak Djokovic".

Kind regards,

Marc

 

[Peter_SSs]

Thanks for providing some sample data. Did you provide the expected results with explanation why they are the expected results as requested? If so, I can't determine what that is.

You also didn't address the last paragraph of my previous post.