Search results

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...

thank you,

is it possible to have an auto_open macro in a shared workbook...?

looks like it works... Thank you for all the assistance... love the website...

works some of the time... not for every combo of days... re-sent...

works some of the time... not for every combo of days... re-sent...

just sent... thx...

Narayan -- I could not seem to get your formula to work... I am sure I am misunderstanding something somewhere down the line...

Deb- I made my name list staring with Sunday thru Saturday... it seems to work ok as long as the day in the name list is still ahead of it but once it I enter like Wednesday 09:00 to Sunday 09:00 it shoots ahead to 9 days...??? is there a way to send you my worksheet...?

Deb- I made my name list staring with Sunday thru Saturday... it seems to work ok as long as the day in the name list is still ahead of it but once it I enter like Wednesday 09:00 to Sunday 09:00 it shoots ahead to 9 days...??? is there a way to send you my worksheet...?

I need to calculate time for a weekly train schedule with no specific dates... i.e. Departs Monday 19:30 Arrives Wednesday 09:00 some of the dates may even go into the next week.. i.e. Depart Friday 17:30 Arrive Thursday 09:00 any help appreciated... thx...