D
Dan G.
changing
=IF(MAX(Sheet2!ET180:ET207)=MAX(Sheet3!ET310:ET409),IF(MAX
(Sheet3!EU310:EU409)>1,MAX(Sheet3!EU310:EU409)+1,""),MAX
(Sheet2!ET180:ET207))
to
=IF(MIN(Sheet2!ET180:ET207)=MIN(Sheet3!ET310:ET409),IF(MAX
(Sheet3!EU310:EU409)>1,MAX(Sheet3!EU310:EU409)+1,""),MAX
(Sheet2!ET180:ET207))
works as of now, have also tried the same on examples of
which no permits have been sold, so this change of formula
appears to be correctably adjustable to all formulas, i've
been looking at this for quite some time, brain is losing
power, gonna use this temporary solution as it will get me
through the day...however, i have a feeling this temp
solution may not work as permanent because the minimum
start # of permits added to registers will always be the
same, & the minimum start # of permits added to the
registers will only be 1 of 2 possibles...."" (no start #,
ie no permits sold), or (x, ie any start #(something has
been sold, thus x will always be the minimum), i cannot
put my finger on the exact forseeable problem & would
prefer to fix it before this potential problem arises,
anyone who understands forsee the room for error?
Dan
Orlando
=IF(MAX(Sheet2!ET180:ET207)=MAX(Sheet3!ET310:ET409),IF(MAX
(Sheet3!EU310:EU409)>1,MAX(Sheet3!EU310:EU409)+1,""),MAX
(Sheet2!ET180:ET207))
to
=IF(MIN(Sheet2!ET180:ET207)=MIN(Sheet3!ET310:ET409),IF(MAX
(Sheet3!EU310:EU409)>1,MAX(Sheet3!EU310:EU409)+1,""),MAX
(Sheet2!ET180:ET207))
works as of now, have also tried the same on examples of
which no permits have been sold, so this change of formula
appears to be correctably adjustable to all formulas, i've
been looking at this for quite some time, brain is losing
power, gonna use this temporary solution as it will get me
through the day...however, i have a feeling this temp
solution may not work as permanent because the minimum
start # of permits added to registers will always be the
same, & the minimum start # of permits added to the
registers will only be 1 of 2 possibles...."" (no start #,
ie no permits sold), or (x, ie any start #(something has
been sold, thus x will always be the minimum), i cannot
put my finger on the exact forseeable problem & would
prefer to fix it before this potential problem arises,
anyone who understands forsee the room for error?
Dan
Orlando