Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello and thanks in advance.....
I have a user who has crated a spreadsheet & the formula has been entered correctly but is not showing the true results. The formula is; =max(A1:A162) There are enteries in column A and I am expecting the figure to show as 350. This is actually showing as 100 - a figure which is also in column A I have re inserted the formula - this does not work. I have also put the formula in a completely different cell but again this does not work. If I over type the data in all the cells the formula works however I cannot tell the user to retype thousands of enteries. I have checked the formatting of the spreadsheet, this all looks ok. Also have checked the tools & options, this is all ok (calculation is set to automatic). Any ideas why this happened but more importantly is there a easy fix to correct this? Thanks in advance James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Polynimial trandline formula | Charts and Charting in Excel | |||
Excel: Formula worked last week but now stoppped working. | Excel Worksheet Functions | |||
Excel formula not working | Excel Discussion (Misc queries) |