If a number in a cell is false -> skip to next cell

[revanreal]

Hi!
I need help with only displaying the values in a cell if it meets a certain criteria. If it does not: skip the cell and check in next cell if the criteria is met there. I want to skip the cells completely and not leave them as "" aka blank as a text.
In the attached excel file I have an example where I want to only display the values that are larger then the previous value by an increment of +2 until I reach the max value. After I reach the max value I would like to do the same down to 0 with increments of -2. This is for reducing "noise" when I have really large dataseries and want to display a graph.

Thanks!

Excel help.xlsx

[newdoverman]

This seems to work though I don't get some values that your sample shows:

Enter the formula in D3 and fill down.

Please Login or Register  to view this content.

	A	B	C	D
1	Time	Raw data values	Prefered data	My Data
2	0	0	0	0
3	1	1
4	2	0
5	3	2	2	2
6	4	1
7	5	2
8	6	3
9	7	2
10	8	4	4	4
11	9	5
12	10	4
13	11	7	7	7
14	12	6
15	13	8		8
16	14	7
17	15	8
18	16	9	9
19	17	10
20	18	11	11
21	19	10
22	20	12		12
23	21	13	13
24	22	15	15	15
25	23	16
26	24	18	18	18
27	25	19
28	26	20	20
29	27	19
30	28	19
31	29	18	18
32	30	17
33	31	16	16
34	32	15
35	33	13	13	13
36	34	12
37	35	10	10	10
38	36	8	8	8
39	37	7
40	38	6	6
41	39	4	4	4
42	40	3
43	41	2	2
44	42	1
45	43	0	0

[revanreal]

Thanks for the reply! And then the last thing, how to avoid cells with "" in them. I would like them to be completely empty so i can paste the whole column in a graph? thanks

[newdoverman]

The cells that appear blank have "" in them. That is why they appear to be blank. To get rid of them completely, you would have to copy and then Paste Values.
Question: What are you doing that you have to "Paste into a graph"? The graph should be generated from your data and not be a manual operation.

[revanreal]

Sorry, my mistake spelling it wrong. Yes the graph is generated from my data.
I have tried to copy the column with the data and paste it as values, but now the new blank cells seems to contain an invisible text of some kind. Because when I mark this data to be displayed in the graph, the blank cells are shown as 0. And yes I have choosen the option to connect points between blank cells.
To help explain my problem I have attached an example: example.xlsx
In the beginning I have deleted the "empty" content in the blank cells manually and you can see the graph has a "good" shape and later the blank cells are displayed as 0.

English is not my first language, but I hope you understand. Thanks!

[newdoverman]

Is this what you are looking for?

[revanreal]

Close, but the third graph in this attachment is what Iam looking for:

Excel help-ndm (2).xlsx

Thanks

[newdoverman]

I think that I might finally have what you are looking for. I added a couple of columns to summarize your data then graphed from there.

[revanreal]

Wow that is amazingly done! thank you so much!

I tried to use the filter-function to remove blanks, but this is so much nicer.
Thanks

[newdoverman]

You will have to be careful when using this solution as you don't want to fill cells beyond the limit of your data and note the manual finish. I mistakenly highlighted the first entry as a manual entry which it isn't but the final entry of 0 is a manual entry because 0 is also the first entry and if you don't have the correct entry from column A to go with the zero, the graph will be messed up.

Thank you for the feedback.

[newdoverman]

You can get what you want by using the ADVANCED filter and filter to another location. This is the result:

Advanced Filter - ndm.png

	A	B
60	Time	Prefered data
61		>=0
62
63
64
65	Time	Prefered data
66	0	0
67	2	0
68	3	2
69	8	4
70	11	7
71	13	8
72	20	12
73	22	15
74	24	18
75	33	13
76	35	10
77	36	8
78	39	4
79	43	0