Help!

P

Priyo

New Member
Joined
Sep 10, 2010
Messages
6
Hello,

I need some help please. I have multiple tabs in a file with Cost Centers #(9 digitis, some of the appearing more than once).

Is there a way I can have a summary sheet with a formula, which will pick up the Cost Center #s, eliminating duplicate Cost center #s in the same tab or in the whole workbook?

Any help would be greatly appreciated!

Thanks,
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
You must log in or register to reply here.

Similar threads

S
  • Question Question
VBA Code that extracts multiple tabs at a time based on lookup tab
2
Replies
10
Views
554
NoSparks
N
N
  • Question Question
Subscription cost summary
Replies
1
Views
163
bobsan42
bobsan42
S
  • Question Question
Best way to lay out financial data to build a dashboard
Replies
1
Views
93
GraH
GraH
N
  • Question Question
Clear data displaying after a Ctrl F 'Find' search
Replies
5
Views
312
Alex Blakenburg
A
K
  • Question Question
Equitable Pricing Model
Replies
3
Views
114
kachauya
K

Forum statistics

Threads
1,224,583
Messages
6,179,683
Members
452,937
Latest member
Bhg1984

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