Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use if formula in list (data validation list)
A HAVE NUMBERS LIKE A1,A2,A3, B HAVE NUMBERS LIKE B1,B2,B3, C HAVE NUMBERS
LIKE C1,C2,C3. I MADE 2 LIST (A,B,C) & (A1,A2,A3,B1,B2,B3,C1,C2,C3) IF IN 1 CELL I USE 1ST LIST "DATA VALIDATION"- "LIST"( A,B,C) & SELECT A OUT OF A,B,C THEN I WANT IN NEXT CELL WHERE I M USING 2ND LIST(A1,A2,A3,B1,..) , IT SHOW ONLY NUMBER A1,A2,A3 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use if formula in list (data validation list)
Hi,
You may want to view the following link - http://contextures.com/xlDataVal02.html -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "AMIT" wrote in message ... A HAVE NUMBERS LIKE A1,A2,A3, B HAVE NUMBERS LIKE B1,B2,B3, C HAVE NUMBERS LIKE C1,C2,C3. I MADE 2 LIST (A,B,C) & (A1,A2,A3,B1,B2,B3,C1,C2,C3) IF IN 1 CELL I USE 1ST LIST "DATA VALIDATION"- "LIST"( A,B,C) & SELECT A OUT OF A,B,C THEN I WANT IN NEXT CELL WHERE I M USING 2ND LIST(A1,A2,A3,B1,..) , IT SHOW ONLY NUMBER A1,A2,A3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation list decreases as the user chooses from the list/s | Excel Discussion (Misc queries) | |||
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions |