Random Thoughts In Random Places

Monday, January 16, 2012

Excel Data Validation -- Dependent Lists

Excel Data Validation -- Dependent Lists: =OFFSET(INDIRECT($E2),0,0,COUNTA(INDIRECT(E2&"Col")),1)
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Places To Go

  • Pete Jones' Skylight Inn - Ayden, NC
  • Memphis Minnie's BBQ - San Fran
  • McClard's Hotsprings Arkansas BBQ
  • Everett & Jones BBQ - Oakland

All Time Favorite Music

  • Late Night Alumni - Empty Streets

Labels

Essential (1) HTPC (2) iTunes (1) NIKKOR (1) Nikon (1) Photography (1) Samba (1) travel (1) VMware VirtualBox Virtual Machines Parallels (1)

My Firefox Addons

  • AdBlock Plus
  • FoxClocks
  • FoxTab
  • NoScript
  • Tree Style Tab
  • Xmarks

Music Events

  • Ben Watt - Dec 9 2007 9:00P - Deep @ Vanguard

Newly Found Music

  • Andy Duguid / Leah - Don't Belong
  • Jennifer Steur/Rene - Fall To Pieces
  • Plumb - In My Arms (Bimbo Jones Mix)
  • Amerie - Take Control [RnB/HH]
  • Leonid Rudenko Featuring Vicky Fee - " The Real Life" (Mischa Daniels Refunkt Mix)
  • Darren Hayes - "Step Into The Light" (Moto Blanco Remix)
  • Roc Project - "Deja Vu"
  • Imogen Heap - "Glittering Cloud"
  • Maor Levi - "Reflect"
  • Matias Lehtola - "Burning Bright"
  • Christina Aguilara - "Hurt"
  • Andy Duguid / Leah - Don't Belong

Random Links

  • DJ Playlists
  • Monoprice - AV Cables!
  • FlyTunes
  • Car Cover
  • 2008 USA Sevens Rugby Tournament
  • Rugby Post New Zealand
  • 3ware 3DM2 manual install
  • HowTo: Install EFI patch and Use Unmodified OS X Kernel in Hackintosh
  • Bluetooth Media controls
  • Historical Dance Track List

About Me

Ackman
View my complete profile

Blog Archive

  • ►  2020 (1)
    • ►  December (1)
  • ►  2018 (2)
    • ►  December (1)
    • ►  June (1)
  • ►  2015 (5)
    • ►  May (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2014 (8)
    • ►  December (1)
    • ►  May (2)
    • ►  April (3)
    • ►  March (1)
    • ►  February (1)
  • ►  2013 (13)
    • ►  November (3)
    • ►  October (5)
    • ►  August (1)
    • ►  April (1)
    • ►  February (3)
  • ▼  2012 (123)
    • ►  November (1)
    • ►  October (2)
    • ►  August (2)
    • ►  July (4)
    • ►  June (2)
    • ►  May (3)
    • ►  April (9)
    • ►  March (24)
    • ►  February (19)
    • ▼  January (57)
      • HighPoint RocketRAID 2760 Switch Architecture PCI-...
      • Tomasz Korwel � Home brew NAS: RocketRaid 622 on U...
      • From 32 to 2 ports: Ideal SATA/SAS Controllers for...
      • Tuning Ubuntu mdadm RAID5/6 | h3x.no
      • RAID5/6 (using ZFS) in FreeBSD 8.x | Dan’s Blog
      • Dedup Performance Considerations (Bizarre ! Vous a...
      • Ten's Complement LLC | ZEVO | Storage
      • rainemu.swishparty.co.uk Git - zfs/summary
      • HOWTO install Ubuntu to a Native ZFS Root Filesyst...
      • ZFS Stable Releases for Ubuntu : “Native ZFS for L...
      • ZFS on Linux
      • About Likewise | Likewise Blog
      • Palringo Rich Messaging: Download
      • How to extract a unique distinct list from a colum...
      • Resetting SATA devices under Linux - For the good ...
      • Sony Forum • View topic - Changing Music App order
      • Installation/FromUSBStick - Community Ubuntu Docum...
      • Seagate 3TB Barracuda XT Review (ST33000651AS) | S...
      • NVIDIA - ArchWiki
      • VMware Fusion 4 vs Parallels Desktop 7: The Virtua...
      • Gentoo Wiki Archives - HOWTO_Xorg_HDTV
      • Modeline Database - MythTV Official Wiki
      • TidBITS Macs & Mac OS X: Discovering Sparse Bundle...
      • How To: Enable TRIM with Non-Apple SSD | StorageRe...
      • Converting an MKV (h264) File to PS3 MP4 Without R...
      • Working with Lists and Tables in Excel 2007: VBA S...
      • VBA for data validation range - MrExcel Message Board
      • Excel Data Validation -- Dependent Lists
      • MediaTomb - Gentoo Linux Wiki
      • Chapter�3.�Setting up Netatalk
      • Build a Netatalk Time Capsule for OSX Lion 10.7 us...
      • Foods
      • Mark-to-market accounting - Wikipedia, the free en...
      • Tracking Restricted Stock in Quicken
      • Dock uses 320% CPU after 10.7.2 update: Apple Supp...
      • NVidia OpenGL "sync to vblank" not sticking with U...
      • LibOFX: The OpenSource OFX parser library
      • VMware Communities: Lion update 10.7.2 - Dock eati...
      • PS3 H.264 Conversion Guide | Articles - Digital Di...
      • Switching apps: MythTv, Boxee and Hulu � It’s dang...
      • MythBoxee | Erik Kristensen
      • Bug ID: 6805578 RFE: disable java quick start jqs....
      • rrfx.net: Western Digital "green" drives Load_Cycl...
      • Gentoo Forums :: View topic - [Solved] gdb and FEA...
      • MySQL Performance Blog
      • XBMC for iOS specific FAQ - XBMC
      • How to install MythTV - QNAPedia
      • Playing on the frontier
      • ConceptDev (Craig Dunn's blog): Monitoring iPhone ...
      • Graham King � Ad-blocking your iPad
      • Mythnuv2mkv - MythTV
      • Commit c5d1073a6c07d4fa49dfbed20a3e556351208e83 to...
      • NAS Charts - File Copy Write Performance - SmallNe...
      • streamedmp - StreamedMP Skin for MediaPortal - Goo...
      • User Manual:JudderFree - MythTV Official Wiki
      • PC-BSD
      • USB Flash Drive Speed Tests - Any Drive Size
  • ►  2011 (152)
    • ►  December (25)
    • ►  November (19)
    • ►  October (10)
    • ►  September (12)
    • ►  August (44)
    • ►  July (14)
    • ►  June (3)
    • ►  May (1)
    • ►  April (7)
    • ►  March (2)
    • ►  February (14)
    • ►  January (1)
  • ►  2010 (141)
    • ►  December (10)
    • ►  November (14)
    • ►  October (11)
    • ►  September (14)
    • ►  August (6)
    • ►  July (5)
    • ►  June (15)
    • ►  May (1)
    • ►  April (5)
    • ►  March (11)
    • ►  February (8)
    • ►  January (41)
  • ►  2009 (119)
    • ►  December (24)
    • ►  November (5)
    • ►  October (6)
    • ►  September (4)
    • ►  August (27)
    • ►  July (3)
    • ►  June (22)
    • ►  May (9)
    • ►  April (3)
    • ►  March (1)
    • ►  February (11)
    • ►  January (4)
  • ►  2008 (88)
    • ►  December (15)
    • ►  November (5)
    • ►  October (47)
    • ►  July (2)
    • ►  March (1)
    • ►  February (6)
    • ►  January (12)
  • ►  2007 (35)
    • ►  December (3)
    • ►  November (16)
    • ►  August (1)
    • ►  July (7)
    • ►  June (8)
Travel theme. Powered by Blogger.