Data Validation List and Custom formula in 1 cell

**murugavelmsc** · 01-11-2013, 02:27 AM

Hi Experts,

How to set a list and custom formula in single cell.

Thanks,
Murugavel S

**:) Sixthsense :)** · 01-11-2013, 02:30 AM

What would be that custom formula of your Validation List?

**murugavelmsc** · 01-11-2013, 02:33 AM

Users enter the active cell A after that only it allows to select item form the list cell B

**:) Sixthsense :)** · 01-11-2013, 02:36 AM

How you are arriving the LIST in cell B?

**murugavelmsc** · 01-11-2013, 02:39 AM

From another sheet A1:A10 and refer the list value in sheet1 cell B (Data Validation - List - source)

**:) Sixthsense :)** · 01-11-2013, 02:50 AM

In B1 cell - Data Validation - List - source

Formula:

Please Login or Register  to view this content.

Re: Data Validation List and Custom formula in 1 cell