LinkBack URL
About LinkBacks
I don't understand the formula (especially INDIRECT part) which create 10 frequency range from the data on the G Column.
Formula:
=MIN(data)+(ROW(INDIRECT("1:10"))*(MAX(data)-MIN(data)+1)/10)-1
I don't understand the formula (especially INDIRECT part) which create 10 frequency range from the data on the G Column.
Formula:=MIN(data)+(ROW(INDIRECT("1:10"))*(MAX(data)-MIN(data)+1)/10)-1
Last edited by zanshin777; 12-13-2015 at 05:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks