Ask MetaFilter

Enabling Retina display scaling settings on, say, 5K monitors (5120 x 2880) reduces that display's resolution to 2560 x 1440 pixels. Is the resolution change applied to everything the operating system renders on screen, or can it be set to conditionally render, say, very high-resolution images (like dense heatmaps or medical images) within a web browser or image viewer, using non-Retina 1:1 scaling? (More inside...) [more inside]
posted by They sucked his brains out! on Mar 24, 2023 - 7 answers

I have a column of numbers and want them to shade through a series of five colors, like this: [more inside]
posted by Spathe Cadet on Jan 9, 2022 - 4 answers

I'd like something like conditional formatting, but that works the other way - a cell's value changes depending upon the colour the cell is filled with. [more inside]
posted by quinndexter on Jul 19, 2016 - 2 answers

In Excel, I have two columns. Column A has many rows of names (e.g., Mary, Maryjane, Maryanne, Anne, Jane) and in Column B I have their ages (e.g., 4, 20, 40, 10). I would like to find the MEDIAN age of all the "mary's"; i.e., both "mary" and "maryanne", etc. Is this possible? I have been getting errors on variations of {=MEDIAN(IF(A1:A4="*mary*",B1:B4))} constructions... I do not want to use VBA. thank you!
posted by noway on Oct 26, 2012 - 5 answers

I, a U.S. citizen, married a foreign national some time ago and helped her obtain conditional permanent resident status as a result of the marriage. I subsequently discovered that she had no intent of engaging in a legitimate marital relationship with me and, instead, had married me for the sole purpose of becoming a permanent resident of the United States. Upon this discovery, I filed for an annulment but was instead granted a divorce (details inside). My immigrant ex-wife will soon need to apply (via the I-751 process) to convert her "conditional" permanent resident status to "true" permanent resident status if she wishes to remain in the United States legally (which she does). I do not know whether she will be granted this status, but I would like to find out whether or not she does attain it. Does anyone have any ideas as to how I might find this out? [more inside]
posted by anonymous on May 1, 2012 - 11 answers

I need an iPad2 spreadsheet app with some specific requirements concerning conditional formatting: [more inside]
posted by amf on Aug 7, 2011 - 3 answers

Stats-filter: Given a binary matrix, if I know the total number of ones in a given row and a given column, can I calculate the probability that a given position contains a one? [more inside]
posted by chrisamiller on Dec 16, 2009 - 25 answers

How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas? [more inside]
posted by Bugbread on Oct 22, 2009 - 7 answers

TechFilter: I need a way to do information gathering questions that adjust based on previously asked questions. Must be easy to put on a website or transmit to customers and then receive their responses. [more inside]
posted by DetonatedManiac on Oct 12, 2009 - 3 answers

How to automatically breakout Excel worksheets based off one "master' worksheet? [more inside]
posted by entropicamericana on Jul 9, 2009 - 8 answers

How to bypass Excel macro warning or alternative to macro. [more inside]
posted by emjay on Nov 4, 2008 - 13 answers

Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name? [more inside]
posted by korres on Feb 5, 2008 - 4 answers

How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
posted by ChasFile on Feb 1, 2008 - 8 answers

GrammarFilter: Is the sentence “If I were ______, I would have done _____” grammatically incorrect? If so, why? [more inside]
posted by jason's_planet on Dec 5, 2007 - 13 answers

In (some) languages, why is the conditional so frequently related to politeness? [more inside]
posted by ORthey on Sep 27, 2005 - 25 answers