Scenario: You want to retrieve all of the tags that match a keyword, then all of the items that match any of those tags, but you don't care about linking the two together. Let's go back to the Cypher query: START tag=node:tagsfulltext('keyword') MATCH tagRETURN tag, item That would produce a Cypher result table like this.
I have been trying to plot two data sets in excel 2013 on an XY straight line graph. Both sets are plots of absorption (Y) against time (X), but absorption was measured at different times for each data set.
I'd like to plot both data sets of absorption (Y) on one time axis (X) but I can't find a way to include the two different sets of X variables, as if I plot the different Y series it will plot both against the X values of the first series.
Can anyone advise as to if it is possible to plot my data in this way? (I also have access to excel 2010 if it was something that was possible there.)
Edit: These are excerpts from my data sets:
Set 1
Set 2:
I'm aware the x axis values are very different here but I'm hoping to plot another graph with three data sets on (two of which I am yet to collect) and these should have more similar ranges on the x axis. I was just trying the graphing out for now.
1 Answer
If you want your plot to have data from both sets you can achieve it by
![Cypher Return 2 Different Sets Of Data Cypher Return 2 Different Sets Of Data](https://s3.amazonaws.com/dev.assets.neo4j.com/wp-content/uploads/cypher_results_with_filter.jpg)
- Select the plot
- Goto 'Design' tab and 'Select Data'
- 'Add' the new series and select data points in new series
And it will look like
But if you are worried about the spread of data in set 1 and set 2, and difficulty in pattern understanding, you can switch x & y and you can use secondary axis. This plot will look like
Hope you wanted either of this.
Not the answer you're looking for? Browse other questions tagged microsoft-excelmicrosoft-excel-2010microsoft-excel-2013 or ask your own question.
Having marked all changed rows with FALSE, you can either SORT Them, or FILTER them to get the list of FALSE entries together. Or you can use conditional formatting to highlight the changed rows in different Colour.
Let me explain the formula in detail to clarify the concept.
=IFERROR(VLOOKUP($A2,Sheet1!$A$2:$C$5,2,FALSE)=B2,FALSE)
Let us first look at the inner part of the formula which is:
VLOOKUP($A2,Sheet1!$A$2:$C$5,2,FALSE)
What VLOOKUP does in effect is that, it searches for the Key in $A2 of Sheet 2 in the first column of the Table in Sheet 1 ($A$2:$C$5) and if it finds a matching key there it returns the data in 2nd column of the Table (i.e. the sales column), The FALSE stands for an 'EXACT MATCH' (instead of a TRUE which stands for nearest match).
So the expected returned values of this VLOOKUP function will be as follows:
Key Sales Compare
A 10 10
B 20 20
C 30 #N/A
D 40 40
E 80 50
Note that since the system is unable to find 'C' in the First Sheet, it returns a #N/A error. Effectively all new rows will be marked with #N/A errors.
Now the task boils down to compare the figures in column B of Sheet 2 which is the Current Sales vs. the Previous Sales which have come using the VLOOKUP formula.
So, if we just use the equation:
=VLOOKUP($A2,Sheet1!$A$2:$C$5,2,FALSE)=B2
it returns TRUE for all cases, where the sales remain the same.
it returns FALSE for all cases where the sales column varies.
it returns #N/A for all cases where the comparison is done for an #N/A field
Key Sales Compare
A 10 TRUE
B 20 TRUE
C 30 #N/A
D 40 TRUE
E 80 FALSE
Finally to remove the error, we forcibly change all errors to FALSE by using the IFERROR function.
Hence the final Formula.
=IFERROR(VLOOKUP($A2,Sheet1!$A$2:$C$5,2,FALSE)=B2,FALSE)
results in :
Key Sales Compare
A 10 TRUE
B 20 TRUE
C 30 FALSE
D 40 TRUE
E 80 FALSE
Please note that VLOOKUP does not match ROW-BY-ROW, it searches the KEY in the next sheet from TOP to BOTTOM (hence the V for VERTICAL in VLOOKUP) till it finds a Match.
Hope it is clear.