For example, column A is number of days, Column B is a values, and column C is a % within values. There are 29 rows and I want to choose only one near or equals to 10% and 90% in B and day from A.
According to attached sheet my answer should be: A=156 and 254, B=44 and 77.
Is there any easy way to get this types of result in excel because I have 60 treatment plots, 29 observations, 8 different phenological phases for 30 species? (i.e.:52200 rows)
Dear @Digambar
I have solved your problem with some simple excel formulas, attached, however, there are easier and faster solutions that can be done by macros, but I hope this will be satisfactory for now.
In any sheet with the same structure you can copy cells from D1:F30 and G1:I7 and paste to the new sheet. If the sheet's data exceeds row 30, just drag formulas down to the end. (No need to change the yellow-shaded cells as I made them valid up to row 100, however, if your data exceeds 100, you must change them accordingly)
Best regards
Dear @Digambar
According to your direct replies to me, and for the benefit of other RG members.
Please find the attached Excel sheet that satisfies your requests of mass processing of several cases at once.
Best regards.
Dear Dr Nesr
Thank you very much for your kind contribution to solve my problem.
with regards
Digambar
Dear Dr Elnesr
Greetings!
First of all thank you very much for your valuable contribution on my problem.
I have again found new problems that Why R2 and R3 are zero and none respectively in sheet Final? and why I2 is more than value available in D in sheet New case?
I hope to get your reply soon.
With regards
Dear @Digambar
Please find the attached excel file with all your issues solved.
Dear @Mohammad N. Elnesr
Thank you very much for your valuable contribution.
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column