Hi
I have a table of numbers as shown below, with the minimum function used in the last column.
65000 0.062620599 65000 65000 0.070104724 0.031389075
65000 0.058771957 65000 65000 0.068603266 0.031892872
65000 0.042605049 65000 65000 0.060968184 0.029752627
65000 0.028717088 65000 65000 0.056657986 0.028717088
65000 0.031079453 65000 65000 0.041230782 0.031079453
65000 0.04461476 65000 65000 0.029933294 0.029933294
65000 0.056189793 65000 65000 0.028301675 0.028301675
This is just a snapshot of the table, it has more columns.
Excel 2010 gives me an error on every cell on the minimum column. Saying "Formula Omits Adjacent Cells" - why is this, it is really bugging me!
can't say, post a sample workbook with a snippet like this showing the problem
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks