Different Types of Functions

D

Des_cool

New Member
Joined
Jun 28, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
What function can I use to find the highest percent change in an array of numbers?
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
Something like this do you mean?

=MAX(ABS((A2:A10-A1:A9)/A1:A9))

with numbers in A1:A10.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Percentrank complexity
Replies
0
Views
103
jcartwri
J
I
  • Question
Find the second highest attribute based on criteria. I know its a combo of index(match(large, but I just can't get it to work correctly.
Replies
1
Views
148
StephenCrump
S
J
  • Solved
Formula to add range and multiply by two different percents
Replies
6
Views
219
awoohaw
awoohaw
M
  • Solved
Formula to 2-way look up a unique identifier and a date, then take the highest number from another column
Replies
3
Views
108
MrsFraser07
M
A
  • Solved
A formula to select the highest cell in a column that then shows the entire row
Replies
4
Views
83
Joe4
Joe4

Forum statistics

Threads
1,215,444
Messages
6,124,892
Members
449,194
Latest member
JayEggleton

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top