Spreadsheet: 94308d1294159576-is-there-a-find-function-in-excel-example
Sheet: Original

 |  | Hindcast 1: 2009_02_09_0300 |  |  | Hindcast 2: 2009_02_09_0900 |  |  | Hindcast 3: 2009_02_09_1500 |  |  | Hindcast 4: 2009_02_09_2100 |  |  | Hindcast 5: 2009_02_10_0300 |  |  | Hindcast 6: 2009_02_10_0900 |  |  | Hindcast 7: 2009_02_10_1500 |  |  | Hindcast 8: 2009_02_10_2100
[NAME] (m3/s) | Lead Time | Hindcast 1 (m3/s) | [NAME] (m3/s) | Difference (m3/s) | Hindcast 2 (m3/s) | [NAME] (m3/s) | Difference (m3/s) | Hindcast 3 (m3/s) | [NAME] (m3/s) | Difference (m3/s) | Hindcast 4 (m3/s) | [NAME] (m3/s) | Difference (m3/s) | Hindcast 5 (m3/s) | [NAME] (m3/s) | Difference (m3/s) | Hindcast 6 (m3/s) | [NAME] (m3/s) | Difference (m3/s) | Hindcast 7 (m3/s) | [NAME] (m3/s) | Difference (m3/s) | Hindcast 8 (m3/s) | [NAME] (m3/s) | Difference (m3/s)
0.1290376424789399 | 0 | 1.03598821163177 | 0.953 | 0.08298821163177006 | 0.980744302272797 | 0.885 | 0.09574430227279696 | 1.0643789768219 | 1.01 | 0.05437897682190007 | 1.2396913766861 | 1.26 | 0.02030862331390004 | 1.50411331653595 | 1.61 | 0.1058866834640502 | 1.52096235752106 | 1.65 | 0.1290376424789399 | 1.44490802288055 | 1.53 | 0.08509197711945005 | 1.42093288898468 | 1.51 | 0.08906711101532006
0.2932821657708702 | 3 | 1.04496014118195 | 0.907 | 0.13796014118195 | 1.04041790962219 | 0.902 | 0.1384179096221899 | 1.40328216577087 | 1.11 | 0.2932821657708702 | 1.62728190436391 | 1.41 | 0.2172819043639098 | 1.66960608959198 | 1.72 | 0.05039391040801999 | 1.523393034935 | 1.61 | 0.0866069650650001 | 1.39926064014435 | 1.54 | 0.1407393598556501 | 1.36742746829987 | 1.47 | 0.10257253170013
1.144138803743803 | 6 | 1.04409444332123 | 0.885 | 0.15909444332123 | 1.21754324436188 | 1.01 | 0.2075432443618801 | 2.404138803743803 | 1.26 | 1.144138803743803 | 2.175318956564396 | 1.61 | 0.5653189565643959 | 1.82769346237183 | 1.65 | 0.17769346237183 | 1.49070775508881 | 1.53 | 0.0392922449111901 | 1.34584677219391 | 1.51 | 0.16415322780609 | 1.31486248970032 | 1.48 | 0.1651375102996799
2.359216750271877 | 9 | 1.1040313243866 | 0.902 | 0.2020313243866 | 1.566233873553514 | 1.11 | 0.4562338735535134 | 3.769216750271877 | 1.41 | 2.359216750271877 | 2.823945760917656 | 1.72 | 1.103945760917656 | 2.02006149291992 | 1.61 | 0.41006149291992 | 1.44165730476379 | 1.54 | 0.09834269523621009 | 1.29161024093628 | 1.47 | 0.17838975906372 | 1.26489388942719 | 1.47 | 0.20510611057281
3.639387949705121 | 12 | 1.33832359313965 | 1.01 | 0.32832359313965 | 2.28782343882641 | 1.26 | 1.02782343882641 | 5.249387949705121 | 1.61 | 3.639387949705121 | 3.378123521936633 | 1.65 | 1.728123521936633 | 2.07930397987366 | 1.53 | 0.5493039798736599 | 1.38782179355621 | 1.51 | 0.12217820644379 | 1.23976004123688 | 1.48 | 0.2402399587631199 | 1.21775078773499 | 1.5 | 0.28224921226501
4.351901082992554 | 15 | 1.839565992628841 | 1.11 | 0.7295659926288405 | 3.064080000241297 | 1.41 | 1.654080000241297 | 6.071901082992554 | 1.72 | 4.351901082992554 | 3.764596909471947 | 1.61 | 2.154596909471947 | 2.05977749824524 | 1.54 | 0.5197774982452401 | 1.33387196063995 | 1.47 | 0.1361280393600499 | 1.18981492519379 | 1.47 | 0.28018507480621 | 1.17419278621674 | 1.51 | 0.33580721378326
4.8758823633194 | 18 | 2.85755848918489 | 1.26 | 1.59755848918489 | 4.219994085069634 | 1.61 | 2.609994085069633 | 6.525882363319401 | 1.65 | 4.8758823633194 | 3.865611032385455 | 1.53 | 2.335611032385455 | 2.00585746765137 | 1.51 | 0.4958574676513698 | 1.2818078994751 | 1.48 | 0.1981921005248999 | 1.14371347427368 | 1.5 | 0.3562865257263199 | 1.26064574718475 | 1.51 | 0.2493542528152499
4.98254276752472 | 21 | 4.366462404112097 | 1.41 | 2.956462404112097 | 4.937440484762194 | 1.72 | 3.217440484762194 | 6.59254276752472 | 1.61 | 4.98254276752472 | 3.795057550333698 | 1.54 | 2.255057550333698 | 1.93902575969696 | 1.47 | 0.46902575969696 | 1.23176503181458 | 1.47 | 0.2382349681854199 | 1.09976351261139 | 1.51 | 0.41023648738861 | 1.36357510089874 | 1.51 | 0.14642489910126
4.90542027473449 | 24 | 6.046868443489074 | 1.61 | 4.436868443489073 | 5.29844880104065 | 1.65 | 3.64844880104065 | 6.43542027473449 | 1.53 | 4.90542027473449 | 3.669090642821739 | 1.51 | 2.159090642821739 | 1.86963510513306 | 1.48 | 0.38963510513306 | 1.18488657474518 | 1.5 | 0.31511342525482 | 1.11108136177063 | 1.51 | 0.3989186382293699 | 1.39727938175201 | 1.51 | 0.1127206182479901
3.590469961762427 | 30 | 4.88838648796081 | 1.65 | 3.23838648796081 | 4.277258723974223 | 1.53 | 2.747258723974223 | 5.100469961762427 | 1.51 | 3.590469961762427 | 2.99931406974793 | 1.48 | 1.51931406974793 | 1.63554239273071 | 1.5 | 0.13554239273071 | 1.12008059024811 | 1.51 | 0.3899194097518901 | 1.06544303894043 | 1.51 | 0.4445569610595701 | 1.28351938724518 | 1.48 | 0.19648061275482
2.22495092515011 | 36 | 3.630108296871187 | 1.53 | 2.100108296871187 | 3.181795791588232 | 1.51 | 1.671795791588232 | 3.70495092515011 | 1.48 | 2.22495092515011 | 2.3149950504303 | 1.5 | 0.8149950504303001 | 1.39992213249207 | 1.51 | 0.1100778675079299 | 1.05657625198364 | 1.51 | 0.4534237480163601 | 1.0193874835968 | 1.48 | 0.4606125164032 | 1.16492331027985 | 1.47 | 0.30507668972015
0.8248615262719872 | 42 | 2.32694077015913 | 1.51 | 0.8169407701591298 | 2.05372858047485 | 1.48 | 0.57372858047485 | 2.324861526271987 | 1.5 | 0.8248615262719872 | 1.632911562806183 | 1.51 | 0.1229115628061828 | 1.16344511508942 | 1.51 | 0.34655488491058 | 0.993112027645111 | 1.48 | 0.486887972354889 | 0.973440170288086 | 1.47 | 0.4965598297119139 | 1.04655778408051 | 1.42 | 0.3734422159194899
0.5588066078724913 | 48 | 0.9988072514534 | 1.48 | 0.4811927485466 | 0.9628606434894403 | 1.5 | 0.5371393565105597 | 0.971374392220923 | 1.51 | 0.538625607779077 | 0.9511933921275088 | 1.51 | 0.5588066078724913 | 0.934577703475952 | 1.48 | 0.545422296524048 | 0.933759570121765 | 1.47 | 0.536240429878235 | 0.933452546596527 | 1.42 | 0.4865474534034729 | 0.930575788021088 | 1.37 | 0.4394242119789121
 | I have highlighted the "MAX" figures which column a3: a:15 identifies
 | from this figure i then need to do the following calculation e.g,. For row 3 - 0.13 i need it to do the following calculation
 | =(S113-R113)/R113 |  | = | 0.84839