Posts tagged as:

INDEX function

Many Excel reports include tables that show sorted results. Usually, these tables were sorted manually in Excel, using the Data, Sort command. However, reports would be a lot easier to maintain and update if formulas (not macros) could sort the data automatically.

There’s a simple way to do this. But to make the method work reliably, [click to continue...]

{ Comments on this entry are closed }