Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel sessions – 2013 VS 2010 Excel User tips
  • Excel Functions = XL f(x)s XLfxs
  • Excel ad from early 90s Non-functions
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Stale values (Scratched functions) Excel User tips
  • Blank (isempty) VS “” (null string) Excel User tips
  • Fixed length ID Formulas - combined functions
  • Middle name + 1st name Basic Math

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

  • Sum of divide – Array formula Array formula
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Extract Address into table Formulas - combined functions
  • Sorting with functions only CHOOSE
  • IF with AND and IF with OR AND
  • Progress bar in pure functions CHAR

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
  • When Excel functions are not enough Excel User tips
  • Excel Functions = XL f(x)s XLfxs
  • Recover the unrecoverable Excel User tips
  • CHOOSE – tree of decisions CHOOSE
  • MATCH fumction, just a simple search Lookup and References
  • GoLast to jump to last cell in a column CELL
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Zipcode-State search Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme