Formula question...

M.E. MAD

Board Regular
Joined
Nov 13, 2003
Messages
60
I want to be able to generate a unique list based on having a formula check all workbooks for location (column a:a:), then job order (column b:b). Once it has checked both columns, I would like to create a list based on the unique orders found. Oh! And if someone could tell me how, I can post an example of the workbooks.

Thanks to all the braniacs for the help, in advance...

Mike in California
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Mike:

To post part of your worksheet on MrExcel Board use HTMLmaker (Colo's Cool utility) downloadable from the bottom of this MrExcel page!
 

M.E. MAD

Board Regular
Joined
Nov 13, 2003
Messages
60
I have downloaded the utility...now, How is it supposed to work?

thanks...
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
If you have successfully downloaded HTMLmaker utility, it is to be installed as an Add-in for the EXCEL application. When it has been installed as an Add-in, you will see a menu item HTML added to the main menu bar next to Help.

If you see the HTML menu item on the main menu bar, to post part of your worksheet on MrExcel Board, select the referenced cells on the worksheet, then click on the HTML menu item, and then follow the directions from the dialog box that pops up.

There are a number of posts on this subject -- so you may also want to view those posts on the Board for additional help.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,321
Messages
5,769,444
Members
425,546
Latest member
DisMissive

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
Top