Hello! I need a formula that will categorized this accounts with this conditions:
Categorized accounts into:
0 - 50,000
>50,000 - 100,000
>100,000 - 200,000
>200,000 - 500,000
>500,000 - 1,000,000
>1,000,000
Book1.xlsx
Hello! I need a formula that will categorized this accounts with this conditions:
Categorized accounts into:
0 - 50,000
>50,000 - 100,000
>100,000 - 200,000
>200,000 - 500,000
>500,000 - 1,000,000
>1,000,000
Book1.xlsx
Can you add to your sample workbook a manual mockup of the results you expect?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Try..
=LOOKUP(B3,{0,50001,100001,200001,500001,1000001,999999999999},{"0 - 50,000",">50,000 - 100,000",">100,000 - 200,000",">200,000 - 500,000",">500,000 - 1,000,000",">1,000,000"})
Life's a spreadsheet, Excel!
Say thanks, Click *
what I want to happen is create a table that will have a title for example 0-50,000 and all the balances that are <=50000 will appear in the table together with its related information
1) use Ace's formula to create an additional column to your data. Put that formula in G3, then copy down.
2) Highlight the new data, then use it as the "source" for a PivotTable that has this new column as the "Row Labels" and the column B Balance as the table "Values", then change those values from the default of "Count" to "Sum".
Example attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks