Recent content by BillS

I see now what you were doing in column B... thank you...

thank you for the response by the way...

the returned response is what I need... can you explain what the calues in column B are...?

but only return 1 value ...

I would like to have option to choose small, small,2, small,3 etc...

I need a formula that will return a lookup value if more than 1 possibility is available... i.e. lookup value 1 and return value in column 2... the lookup array will have several 1's to chk from with different values in column 2... I need it to return a small value from array...

that worked... thx... It let me change the array to my named array... =IF(SUMPRODUCT(--(E12=Exceptions)),G12,H12) will start new string next time...

i receive an error if written =if(E12=Exceptions,H12,G12) to not receive an error, i have to use =IF(OR(E12=E5,E12=E6,E12=E7,E12=E8),G12,H12) Exceptions is my name for the array E5:E8

sorry... changed subjects without changing subject line... is it possible to write an if statement using name manager...? Exceptions being the name of an array... i.e. =if(E12=Exceptions,H12,G12)

is it possible to write an if statement using name manager...? Exceptions being the name of an array... i.e. =if(E12=Exceptions,H12,G12)

seems to keep defaulting back to 13.2 font which is tolerable but font 11 should be do-able...

is there a way to save a specific font in my chart templates...? everytime I pull up my template I have to change the font from 18 --> 11... i saved my template w the correct font but it still defaults to 18... pls advise... thank you

how do you change the profile pictures...? did not allow me to choose...