Segregation based on a ref. no. in a particular column. .. for a unique row but not so unique column (Multiple unique entries for a single ref. no. )

Anvo88

New Member
Joined
Jul 14, 2014
Messages
5
This is what I am trying to do.
I have a main list in SharePoint.
I have created an infopath form which is connected to this list. Based on the way the form is filled, a new list is populated based on information extracted from the main list.
The real problem,
The main list has unique rows but the column value on which I want to segregate them is not unique.

Example
Ref No: 12345
A B C D E(Ref No.) F
ax rt it re 12345 23CH
ef uy jy yi 12567 36TC
fg ie ee qp 12345 78LT
ds et vc gh 56732 11AB
sb wt fc wt 12345 66GH
uh wi dg at 12345 88WW

I want to segregate my rows based on the Ref. No. (Column E).
I i enter the Ref No. 12345, I want it to display all the rows that have the value 12345 as a ref no.
and the function should be dynamic so..... as the main list populates with new entries, the new list populates automatically.

Can this be automated for different for different ref. Numbers? .. based on a drop down list?

Thank you.
I appreciate all the help.

Regards,
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,213,530
Messages
6,114,163
Members
448,554
Latest member
Gleisner2

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