irfananeeza
Active Member
- Joined
- Feb 15, 2008
- Messages
- 334
- Office Version
- 2010
Hello Experts,
I would really appreciate if someone can give me a formula for three of my questions.
1) I have data with Col A has customer names and Col B with Products (starting A2 & B2). Each Customer has a list of 25 products. I am looking for a formula that whatever customer I clik in Column A, that customer gets displayed in Cell A1.
2) My second question is: Is there a formula that can lock the width of columns. Let's say I want Col A width = 25 and Col B width equals 12. So whatever I input in Col A, the width of the Col A stay as 25.
3) My third questionis: Is there a formula or custome formatting technique where whenever date in entered in whatever format, it always show up in this custome format i.e. Sep-1-2014.
Thanks for help in advance.
I would really appreciate if someone can give me a formula for three of my questions.
1) I have data with Col A has customer names and Col B with Products (starting A2 & B2). Each Customer has a list of 25 products. I am looking for a formula that whatever customer I clik in Column A, that customer gets displayed in Cell A1.
2) My second question is: Is there a formula that can lock the width of columns. Let's say I want Col A width = 25 and Col B width equals 12. So whatever I input in Col A, the width of the Col A stay as 25.
3) My third questionis: Is there a formula or custome formatting technique where whenever date in entered in whatever format, it always show up in this custome format i.e. Sep-1-2014.
Thanks for help in advance.