Identify values from same column on multiple sheets

F

frankpat

New Member
Joined
Apr 23, 2002
Messages
7
I have a workbook with multiple sheets (a new sheet is created every day). Column A of each sheet has product codes that are highlighted red yellow green or no formatting. I'm trying to create a worksheet that will show me the counts of each unique code. Can anyone help?
Thank you!

1601477100363.png
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
What do you consider "unique" codes, is it dependent on their colors? Can you give an example of how you want the output worksheet should look like?
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Creating Unique list from Customer Order Amount, Customer Name and Order Identifier using the Unique function
2
Replies
11
Views
367
etaf
etaf
M
  • Solved
Identify unique value, lookup in another column, then count distinct values in adjacent column.
Replies
3
Views
48
MarkS1234
M
T
  • Solved
Formula to Number Multi-Part Transactions and Re-Start Count Each Day
Replies
6
Views
285
turn7or5
T
X
  • Question Question
How To Create Multiple Sheets(With Criteria) From One Sheet?
Replies
1
Views
330
Kerryx
K
M
  • Question Question
Formula help with counting and reference cells within multiple worksheets.
Replies
3
Views
68
myall_blues
myall_blues

Forum statistics

Threads
1,224,747
Messages
6,180,712
Members
452,995
Latest member
isldboy

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