Hi there,
I am using the Min function below:-
Rather than using C9:Q9 i need it to use C9:G9,I9:L9,N9:Q9 however when i use it, it says I have used to many arguments for this function, is there anyway round this?![]()
=MIN(IF(NOT(ISNA(C9:Q9)),IF(C9:Q9>0,C9:Q9)))
I have been stumped on this for ages, if anyone could help it would be much apprecaited.
Thanks
Justin.
Bookmarks