Formula to show unique customer name when sheet is scrolled up or down

[irfananeeza]

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.