Lookups with duplicates in Excel:
A standard VLOOKUP has its limitations. XLOOKUP offers additional search options but fails to provide the desired result. This lesson presents a familiar scenario involving a table with employee names, departments, and countries of residence, showcasing the complexity of traditional lookup functions...
Gespeichert in:
| Körperschaft: | |
|---|---|
| Format: | Elektronisch Video |
| Sprache: | Englisch |
| Veröffentlicht: |
[Place of publication not identified]
Assemble You
2024
|
| Ausgabe: | [First edition]. |
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/2000048AYMSTIKTOK/?ar |
| Zusammenfassung: | A standard VLOOKUP has its limitations. XLOOKUP offers additional search options but fails to provide the desired result. This lesson presents a familiar scenario involving a table with employee names, departments, and countries of residence, showcasing the complexity of traditional lookup functions when faced with duplicates. By combining multiple pieces of information, such as employee names and departments, we create a unique identifier for each record. Using this approach with XLOOKUP, we successfully achieve accurate lookups - highlighting the importance of finding unique identifiers when dealing with duplicate values in your data sets. Join us in mastering this essential skill for effective data management! Learning Objectives Perform accurate lookups in tables with duplicate values by creating unique identifiers - ensuring precision in data retrieval and management. |
| Beschreibung: | Online resource; title from title details screen (O'Reilly, viewed March 19, 2024) |
| Umfang: | 1 Online-Ressource (1 video file (7 min.)) sound, color. |
Internformat
MARC
| LEADER | 00000ngm a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-102207615 | ||
| 003 | DE-627-1 | ||
| 005 | 20240404083424.0 | ||
| 006 | m o | | | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 240404s2024 xx ||| |o o ||eng c | ||
| 035 | |a (DE-627-1)102207615 | ||
| 035 | |a (DE-599)KEP102207615 | ||
| 035 | |a (ORHE)2000048AYMSTIKTOK | ||
| 035 | |a (DE-627-1)102207615 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.54 |2 23/eng/20240319 | |
| 245 | 1 | 0 | |a Lookups with duplicates in Excel |
| 250 | |a [First edition]. | ||
| 264 | 1 | |a [Place of publication not identified] |b Assemble You |c 2024 | |
| 300 | |a 1 Online-Ressource (1 video file (7 min.)) |b sound, color. | ||
| 336 | |a zweidimensionales bewegtes Bild |b tdi |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a Online resource; title from title details screen (O'Reilly, viewed March 19, 2024) | ||
| 520 | |a A standard VLOOKUP has its limitations. XLOOKUP offers additional search options but fails to provide the desired result. This lesson presents a familiar scenario involving a table with employee names, departments, and countries of residence, showcasing the complexity of traditional lookup functions when faced with duplicates. By combining multiple pieces of information, such as employee names and departments, we create a unique identifier for each record. Using this approach with XLOOKUP, we successfully achieve accurate lookups - highlighting the importance of finding unique identifiers when dealing with duplicate values in your data sets. Join us in mastering this essential skill for effective data management! Learning Objectives Perform accurate lookups in tables with duplicate values by creating unique identifiers - ensuring precision in data retrieval and management. | ||
| 630 | 2 | 0 | |a Microsoft Excel (Computer file) |
| 650 | 0 | |a Business |x Computer programs | |
| 650 | 0 | |a Electronic spreadsheets | |
| 650 | 4 | |a Tableurs | |
| 650 | 4 | |a Instructional films | |
| 650 | 4 | |a Nonfiction films | |
| 650 | 4 | |a Internet videos | |
| 650 | 4 | |a Films de formation | |
| 650 | 4 | |a Films autres que de fiction | |
| 650 | 4 | |a Vidéos sur Internet | |
| 710 | 2 | |a Assemble You Limited, |e MitwirkendeR |4 ctb | |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/2000048AYMSTIKTOK/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 935 | |c vide | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-102207615 |
|---|---|
| _version_ | 1821494933745303552 |
| adam_text | |
| any_adam_object | |
| author_corporate | Assemble You Limited |
| author_corporate_role | ctb |
| author_facet | Assemble You Limited |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)102207615 (DE-599)KEP102207615 (ORHE)2000048AYMSTIKTOK |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | [First edition]. |
| format | Electronic Video |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02466ngm a22004692 4500</leader><controlfield tag="001">ZDB-30-ORH-102207615</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240404083424.0</controlfield><controlfield tag="006">m o | | </controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">240404s2024 xx ||| |o o ||eng c</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)102207615</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP102207615</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)2000048AYMSTIKTOK</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)102207615</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield><subfield code="2">23/eng/20240319</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Lookups with duplicates in Excel</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">[First edition].</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[Place of publication not identified]</subfield><subfield code="b">Assemble You</subfield><subfield code="c">2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (1 video file (7 min.))</subfield><subfield code="b">sound, color.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">zweidimensionales bewegtes Bild</subfield><subfield code="b">tdi</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Online resource; title from title details screen (O'Reilly, viewed March 19, 2024)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">A standard VLOOKUP has its limitations. XLOOKUP offers additional search options but fails to provide the desired result. This lesson presents a familiar scenario involving a table with employee names, departments, and countries of residence, showcasing the complexity of traditional lookup functions when faced with duplicates. By combining multiple pieces of information, such as employee names and departments, we create a unique identifier for each record. Using this approach with XLOOKUP, we successfully achieve accurate lookups - highlighting the importance of finding unique identifiers when dealing with duplicate values in your data sets. Join us in mastering this essential skill for effective data management! Learning Objectives Perform accurate lookups in tables with duplicate values by creating unique identifiers - ensuring precision in data retrieval and management.</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Electronic spreadsheets</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Tableurs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Instructional films</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Nonfiction films</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Internet videos</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Films de formation</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Films autres que de fiction</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Vidéos sur Internet</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Assemble You Limited,</subfield><subfield code="e">MitwirkendeR</subfield><subfield code="4">ctb</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/2000048AYMSTIKTOK/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="935" ind1=" " ind2=" "><subfield code="c">vide</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-102207615 |
| illustrated | Not Illustrated |
| indexdate | 2025-01-17T11:22:15Z |
| institution | BVB |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (1 video file (7 min.)) sound, color. |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Assemble You |
| record_format | marc |
| spelling | Lookups with duplicates in Excel [First edition]. [Place of publication not identified] Assemble You 2024 1 Online-Ressource (1 video file (7 min.)) sound, color. zweidimensionales bewegtes Bild tdi rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Online resource; title from title details screen (O'Reilly, viewed March 19, 2024) A standard VLOOKUP has its limitations. XLOOKUP offers additional search options but fails to provide the desired result. This lesson presents a familiar scenario involving a table with employee names, departments, and countries of residence, showcasing the complexity of traditional lookup functions when faced with duplicates. By combining multiple pieces of information, such as employee names and departments, we create a unique identifier for each record. Using this approach with XLOOKUP, we successfully achieve accurate lookups - highlighting the importance of finding unique identifiers when dealing with duplicate values in your data sets. Join us in mastering this essential skill for effective data management! Learning Objectives Perform accurate lookups in tables with duplicate values by creating unique identifiers - ensuring precision in data retrieval and management. Microsoft Excel (Computer file) Business Computer programs Electronic spreadsheets Tableurs Instructional films Nonfiction films Internet videos Films de formation Films autres que de fiction Vidéos sur Internet Assemble You Limited, MitwirkendeR ctb |
| spellingShingle | Lookups with duplicates in Excel Microsoft Excel (Computer file) Business Computer programs Electronic spreadsheets Tableurs Instructional films Nonfiction films Internet videos Films de formation Films autres que de fiction Vidéos sur Internet |
| title | Lookups with duplicates in Excel |
| title_auth | Lookups with duplicates in Excel |
| title_exact_search | Lookups with duplicates in Excel |
| title_full | Lookups with duplicates in Excel |
| title_fullStr | Lookups with duplicates in Excel |
| title_full_unstemmed | Lookups with duplicates in Excel |
| title_short | Lookups with duplicates in Excel |
| title_sort | lookups with duplicates in excel |
| topic | Microsoft Excel (Computer file) Business Computer programs Electronic spreadsheets Tableurs Instructional films Nonfiction films Internet videos Films de formation Films autres que de fiction Vidéos sur Internet |
| topic_facet | Microsoft Excel (Computer file) Business Computer programs Electronic spreadsheets Tableurs Instructional films Nonfiction films Internet videos Films de formation Films autres que de fiction Vidéos sur Internet |
| work_keys_str_mv | AT assembleyoulimited lookupswithduplicatesinexcel |