Match Function for detection of 10-90 rise time

[bubbletea2]

Hello,
I want to calculate 10 and 90th percentile of a signal. I want the function to find the closest corresponding time value (A:A) to the two threshold voltage values (B:B). I used the following to find the voltage threshold value (=.1*Max(B:B)) and (=.9*Max(B:B)) and need to find the corresponding time value. Using Lookup function , I was able to find the time value for the 10% percentile =Lookup(Voltage Threshold Value,B:B,A:A) but am not able to match the time value for the 90th percentile--the 90th percentile threshold value is 1.0009 and the closest matching number in the array is 1.012.

Any suggestions?

[shg]

Yes: Post a workbook and explain in context.

[egglampbasket]

PercentileTimeFind.xlsx

Here is what I think you want. If you posted a sample worksheet it would be a lot easier to find out what you need. For example, is your voltage always increasing or does it fluctuate? This could affect the match function I used here.

[bubbletea2]

Percentile.xlsx

Thank you for the example worksheet however, I have used the above and could not find the correct 90th percentile. Enclosed please find my data set. The voltage fluctuates does fluctuate.

[shg]

You could do it this way:

	A	B	C	D	E
1			10%	90%
2			0.111219	1.00097
3	seconds	voltage
4	0.225972	-0.002664
5	0.225976	-0.002828			C5 and across and down: =IF(AND($B4<C$2, $B6>C$2), "x", "")
6	0.225980	-0.003486
7	0.225984	-0.004144
8	0.225988	-0.004472

Look for the x's in columns C and D.

[bubbletea2]

Thank you!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.