Lookup (unique and duplicated values) from Multiple worksheets and return sheet name

sleek12

Board Regular
Joined
May 3, 2014
Messages
62
Office Version
  1. 365
Platform
  1. Windows
1584820228431.png


1584820323736.png


small errata, 21/8 70,000=70,000 variance,
Crossposted from:-
Chandoo.org
However its not been answered to.

New Microsoft Excel Worksheet (3).xlsx
AB
1Sheet nameDetails
2DTBhas three columns Date, particulars, Amount
3BARCLAYS1has three columns Date, particulars, Amount
4BARCLAYS2has three columns Date, particulars, Amount
5BARCLAYS3has three columns Date, particulars, Amount
6BARCLAYS4has three columns Date, particulars, Amount
7BARCLAYS5has three columns Date, particulars, Amount
8BARCLAYS6has three columns Date, particulars, Amount
9BARCLAYS7has three columns Date, particulars, Amount
10BARCLAYS8has three columns Date, particulars, Amount
11BARCLAYS9has three columns Date, particulars, Amount
12STANDARD1has three columns Date, particulars, Amount
13STANDARD2has three columns Date, particulars, Amount
14STANDARD3has three columns Date, particulars, Amount
15STANDARD4has three columns Date, particulars, Amount
16STANDARD5has three columns Date, particulars, Amount
17MPESAhas five columns Receipt no. ,Completion on time, Details,Amount ,Other party info
18KCB001has three columns Date, particulars, Amount
19NIC001has three columns Date, particulars, Amount
20NIC002has three columns Date, particulars, Amount
21NIC003has three columns Date, particulars, Amount
22NIC004has three columns Date, particulars, Amount
23For illustration purposes only, I don’t want to input all 24 worksheets !!!!
24bankworksheets=>
 
Last edited:

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,213,531
Messages
6,114,172
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