LinkBack URL
About LinkBacks
Dear all,
Could someone help me with formula to get the expected result as below:
Days Value
0
1 2,065
2 869
3 558
4 393
5 329
6
7 217
8 18,800
9 128
10 157
11
12 121
13 108
14
15
Expected result :
Days = 8, -> the highest value (18,800)
Thank you
Dear all,
Could someone help me with formula to get the expected result as below:
Days Value
0
1 2,065
2 869
3 558
4 393
5 329
6
7 217
8 18,800
9 128
10 157
11
12 121
13 108
14
15
Expected result :
Days = 8, -> the highest value (18,800)
Thank you
Maybe,Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Maybe this?
Enter formula in A19
Formula:Please Login or Register to view this content.
Format cell B19 as Custom, "Days: "= 0
Formula:Please Login or Register to view this content.
v A B 1 Days Value 2 0 3 1 2,065 4 2 869 5 3 558 6 4 393 7 5 329 8 6 9 7 217 10 8 18,800 11 9 128 12 10 157 13 11 14 12 121 15 13 108 16 14 17 15 18 19 Days: = 8 (18,800)
Last edited by AlKey; 07-02-2019 at 03:20 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Dear all,
It works with the formula from TMS..
Thanks to TMS and AlKey
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks