Hello,
i need to evaluate a paleo diversity database in RStudio but to be able to do the i need to "clean up" the database first. I do not have much excel experience yet so please excuse my probably mundane questions/requests.
I have already recieved alot of help regarding the workup of the database. Thanks again to all contributors.
Im now facing a new excel related hurdle. Ill provide an exemplary part of the database im working with and will refer to it.
I need to count the number of different values in column "A" for a range of values in column "I". It would be even better if it would check 2 columns ("G" and "H"). So if one or both values from column "G" and "H" fit into an defineable interval the are considered for the count of dierent values from column "A".
Here is an example of what i want to do:
I want to count the number of different genera over a time period. For example the number of different "A" values (genera) for "I" values in the interval <358,9 and >298,9. (preferably it would be checking columns "G" and "H" and counts the number of different "A" values even if just one of the ages fall into the defined interval) So i can create a chart of the number of different genera for all timeperiods.
Or is there any way to employ Power Query for my purpose?
Edit: I've found this function =if(or(and(H1>=0,H1<=10),and(0>=H1,0<=G1))
which was derived from this: =if(or(and(x>=a,x<=b),and(a>=x,a<=y)),"Overlap","Do not overlap")
can someone add the necessary arguments so it puts out the value for "A" in the corresponding row (maybe like this : =if(or(and(H2>=0,H2<=10),and(0>=H1,0<=G2)),A2,"0") ive tried this formula and it returns an error which is #NAME? in german excel
Thanks in advance
afridelle
Bookmarks