{"id":8,"date":"2009-06-20T01:44:26","date_gmt":"2009-06-20T05:44:26","guid":{"rendered":"http:\/\/exceltheatre.com\/blog\/?p=8"},"modified":"2009-06-20T01:44:40","modified_gmt":"2009-06-20T05:44:40","slug":"an-absolute-nightmare","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2009\/06\/20\/an-absolute-nightmare\/","title":{"rendered":"An Absolute Nightmare"},"content":{"rendered":"

Well, I should have been working all day, but decided to take a bit of time to relax and catch up on some reading (of RSS feeds). At the Lost in Technology<\/a> blog, was a link to XtraNormal<\/a>, where you can write, cast and direct an animated movie. That sounded like more fun than working, so off I went.<\/p>\n

And here\u2019s the first (and probably last) installment in Excel Theatre. Please note the giant spreadsheet in the background. I think it adds to the tension in this dramatic presentation. Just so you know \u2013 the dialog is corny, the actors are wooden, the plot is weak and the costumes are pitiful. Other than that, it\u2019s pretty good. \ud83d\ude09<\/p>\n

Note: The animated actors had a tough time pronouncing INDIRECT, so I had to spell it IN DIE WRECKED in the script, to make it understandable. Fortunately, that seemed to help, and the key word is clearer in the video now.<\/p>\n

<\/embed><\/object><\/p>\n

The INDIRECT Function<\/h3>\n

If you haven\u2019t used INDIRECT before, it\u2019s a formula that returns a reference to a range, based on a text string. As the video pointed out, you can use an absolute reference to a cell, to \u201clock\u201d the reference, and keep if from changing if you copy the formula to a different cell. However, if the referenced cell moves, the absolute reference changes to match the new location.<\/p>\n

For example, in the screenshot below, cell C2 contains an absolute reference to cell A1, and cell C3 contains an INDIRECT formula that refers to cell A1.<\/p>\n

\"Indirect01\"<\/p>\n

If you insert a blank row at the top of the worksheet, the formula in cell C2 changes, and it now refers to cell A2. Because it\u2019s a text string, the reference in the INDIRECT formula doesn\u2019t change. It returns a zero because cell A1 is now empty.<\/p>\n

\"Indirect02\"<\/p>\n

Using the INDIRECT Function<\/h3>\n

You can use INDIRECT in dependent data validation<\/a> lists, or to prevent a cell reference from being affected by a move, or create cell references from a combination of cell values and text.<\/p>\n

For more information on the INDIRECT function, and examples of how to use it, please visit the INDIRECT Function<\/a> page on my website.<\/p>\n

________________<\/p>\n","protected":false},"excerpt":{"rendered":"

Well, I should have been working all day, but decided to take a bit of time to relax and catch up on some reading (of RSS feeds). At the Lost in Technology blog, was a link to XtraNormal, where you can write, cast and direct an animated movie. That sounded like more fun than working, … Continue reading “An Absolute Nightmare”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-8","post","type-post","status-publish","format-standard","hentry","category-excel-humor"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/8","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=8"}],"version-history":[{"count":4,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/8\/revisions"}],"predecessor-version":[{"id":12,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/8\/revisions\/12"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=8"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=8"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=8"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}