Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: woodduck09
- Order by date
-
Excel 2007 - Formula problems
Gavona, Thanks very much, I entered the info but it returned a value of "False" rather than the numerical value. I have added a set of brackets to the "Match" statement and that has fixed the error. =INDEX(I2:M3601,(MATCH($B$7,L2:L3601)),1) Champion stuff Greatly appreciated- woodduck09
- Post #8
- Forum: Microsoft: Office
-
Excel 2007 - Formula problems
Sorry I haven't been clearer, just trying to work out how to attach the file - I appreciate your patience Each page shows the same spreadsheet with the different time steps - I have highlighted the line that shows the different problems. http://www.mediafire.com/file/drhih2mmzzm/Ass 5.xls - is...- woodduck09
- Post #6
- Forum: Microsoft: Office
-
Excel 2007 - Formula problems
Hello Skip, The 'match' is the time in seconds. In the 1 second intervals it returns the correct value. When I change the table to a 5 second interval (and .5 second) it picks up a value that is nowhere near what is calculated. eg. 1 second interval - match = 198 seconds (correct answer) 5...- woodduck09
- Post #3
- Forum: Microsoft: Office
-
Excel 2007 - Formula problems
I am writing a formula for fire engineering, the formula spreadsheet requires an iterated solution. I have time stepped my spreadsheet every 1 second. To find my answer i have written the code as follows:- =MATCH($B$7,L2:L3601) where:- $B$7 is my variable and the L column is where the worked...- woodduck09
- Thread
- Replies: 7
- Forum: Microsoft: Office
