Skip to main content
2 of 2
Moving target.

First of all, please don’t post images of spreadsheets (or other text).

If you need to be able to upload the spreadsheet to explain the question, that’s a sign that you haven’t thought about your question enough to be ready to ask it on Super User.  First of all, some people simply will refuse to download files out of concern about malware.  Secondly, if you present more than about 50 cells (e.g., 5 columns × 10 rows) of sample data, some people won’t bother looking at it, thinking that you are substituting quantity of data for quality of information (i.e., narrative/explanation) and/or that you have a problem that’s so big and complex that it really should be further analyzed (by you) and decomposed into smaller, more manageable pieces (which you should perhaps then ask as multiple separate questions).

When you have narrowed the scope of your question, create a small data set that illustrates your problem (see this).  It doesn’t have to be your real data; it’s OK (and preferable) to use dummy/test data.  Don’t use 10-digit numbers and 20-letter Welsh words if you can make do with 2-digit numbers and short words like “red” and “orange”.  And then post a textual representation of your data set, as was done here, here, here, here, here and here; use the Format Text as Table or the Plain Text Tables generator site if you want.

In your question, be sure to include the output data you expect from your input data (clearly identifying which is which) and give a clear description of the computation you want Excel to do.

Scott
  • 22.1k
  • 1
  • 16
  • 28