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

irfananeeza

Active Member
Joined
Feb 15, 2008
Messages
320
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.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,108,982
Messages
5,526,055
Members
409,681
Latest member
marnu70

This Week's Hot Topics

Top