Help with formula: Seperate Items into new tabs.

Surreyview

New Member
Joined
May 23, 2019
Messages
15
Hello,

I don't know whether what I am trying to do is possible?

I have a summary tab in my spreadsheet that has a number of New and Existing Accounts.

I need to have two further separate tabs: one that displays only the new accounts and relevant data associated to that account, and the same for only the existing accounts.

How do I get my two new tabs to look for the data and populate it?
Thank you
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
on the summary tab, how do you know which account is new or existing?
 
Upvote 0
Thank you for replying.
I have a column that states which account is a 'New Account' and which is a 'Existing Account.
 
Upvote 0
How about just using Filters or Advanced Filters?
 
Upvote 0
Yes, I was hoping to do something a bit more sophisticated, but actually I might propose we do that initially and see how we get on.
Do you think what It is not possible to do it any other way?
 
Upvote 0
like this?


Book1
AB
1Account1New
2Account2New
3Account3New
4Account4Existing
5Account5New
6Account6New
7Account7New
8Account8Existing
9Account9New
10Account10New
Summary



Book1
A
1New
2Account1
3Account2
4Account3
5Account5
6Account6
7Account7
8Account9
9Account10
New
Cell Formulas
RangeFormula
A2{=IFERROR(INDEX(Summary!$A:$A,SMALL(IF((Summary!$B$1:$B$1000=A$1),ROW(Summary!$B$1:$B$1000)),ROW($A1)),1),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.



Book1
A
1Existing
2Account4
3Account8
4
5
6
7
8
9
Existing
Cell Formulas
RangeFormula
A2{=IFERROR(INDEX(Summary!$A:$A,SMALL(IF((Summary!$B$1:$B$1000=A$1),ROW(Summary!$B$1:$B$1000)),ROW(New!$A1)),1),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

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