I can make a pareto in Excel. My problem is that As data is collected
throughout the month, The order changes in my table and I have to run a macro
to re-align the data every day. Is there a way (using a formula or a
template) to automatically sort the data into descending order?

If you want to do it inplace, you would need a macro.

if you want to do it with formulas, you can use the small or large worksheet
functions.

=small($A$1:$A$10,row(A1))

entered in M30 for example, then copied down for a total of 10 rows will
display the values in A1:A10 in ascending order.

You can fill in other data to the right (if necessary) by using Vlookup.
This would assume the values in A1:A10 are unique.


for a macro, you could use the change event to sort the data whenever a
change is made in a specific column for example. Rigth click on the sheet
tab and select view code. In the resulting module, at the top are two
dropdowns. Select worksheet from the left dropdown and Change from the right
dropdown (not selection change).

this will put in a declaration for the change event and you can add code to
it to screen for the trigger event and then sort the range of interest.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub


--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy



"Lear 6 sigma Guy" wrote:

I can make a pareto in Excel. My problem is that As data is collected
throughout the month, The order changes in my table and I have to run a macro
to re-align the data every day. Is there a way (using a formula or a
template) to automatically sort the data into descending order?