Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Progress bar in pure functions CHAR
  • CTRL+Y a mini macro Excel User tips
  • State Abbr with Index+Match+Validation Data Validation
  • Rotate table using 1 formula ADDRESS
  • Tally chart in functions Formulas - combined functions
  • VALUE() of LEFT() Formulas - combined functions
  • Skills Grid Conditional Formatting
  • Convert cell into textbox Excel User tips

Multiple-Validations (connected to each other)

Posted on February 7, 2012 By ANmar No Comments on Multiple-Validations (connected to each other)

Here is the free file for a special request by a client
He wanted to have multiple cells having Data – Validation to same list but minus the selected one

In English, once you select one from cell1, cell2 will bring the same list but without the selected one, then when you select another item is selected in cell2, cell3 will bring what left from the list.

Does that make sense, check out the screenshots

The important that you need to have he formula in each list connected to the previous one, so I have in 2nd list this formula:

=IF($D$6=B6,IF(B7="","",B7),IF(F4=B4,B6,IF(B7="","",B7)))

And in 3rd list, I have:

=IF($H$6=F6,IF(F7="","",F7),IF(J4=F4,F6,IF(F7="","",F7)))

These formulas will enable you to update the list to have all original list except the selected one. Also, you need the Validation to have it connected to the latest list.

 

 

Download spreadsheet
 

 

Data Validation, Formulas - combined functions, IF, Logical, Standard functions

Post navigation

Previous Post: WorksheetName and WorksheetsNo UDFs
Next Post: Multiple Dual-Validations

Related Posts

  • Searching table in 2 dimensions. Formulas - combined functions
  • MATCH fumction, just a simple search Lookup and References
  • 0% interest promotion Basic Math
  • GoLast to jump to last cell in a column CELL
  • Looplist – Repeating months using formulas Basic Math
  • Schedule column Basic Math

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Expenses calendar, FaCal Basic Math
  • Unix DateTime Number Basic Math
  • Cuts string of list of items Formulas - combined functions
  • Get 3rd Wednesday of month Basic Math
  • Sheet() and Sheets() Lookup and References
  • Week number to Month number DATE
  • Text-to-Columns, dynamically using formulas IFERROR

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme