Search:

Possible solution.

In Column B do a Vlookup to match each record to its serial no.

Used advanced Filter; Select Filter in Place' Select "Unique Records Only"

The FIlter should hide all...

Dear Kweaver:

Excel's Dialog Box for Data Validation is very poorly written. the "ignore blank cells" should actually read "Allow Users to enter drop down items or alternatively leave the cell...

Perhaps the following may help.

Are the numbers using a font color that is the same as the background (such as white on white)?
Select Tools - Options - View Tab and see if the desired view...

HowardC:

What about using Match to compare the two lists.

See the attached.

By using Auto Filter, Advance Filter, or Sort the lists can be customized or if really necessay you could create...

Farrukh:

Attached is a suggested solution.

It uses the following

1. Advance Filter
2. SumIF function
3. A user defined function named "VlookUpAll"

Dear Kiwimuso:

I had a very similar problem. Try this solution

Open VBA and in the immediate window put in the following code:

Application.EnableEvents = False

Switch back to Excel and...

Attached is the long method
It may be off a penny or two due to the way banks round their rates but that can be fixed by rounding the monthly rate to agree with the bank.

Happy computing.

TD

Rudevincy:
Your post states your are working with reports and file names. How is Excel currently creating the reports and files? If its using a VBA procedure can you post the code so...

Marty:

Concerning CELL, According to the Microsoft "Excel 5 Worksheet Function Referenece" book, "The CELL function is provided for compatibility with other spreadsheet programs".
It goes on to...

Same Results different flavor, but again only works for single digit numbers.
Function MaxNum(x)
Dim Z As Integer
Dim MyLen As Integer
Dim i As Integer
Z = 0
MyLen = Len(x)
For i = 1 To MyLen...

Dear Paddydive:

Your orignal post failed to provide the desired results. In addition for each row in the data is it always Yes or No?

For maximum assistance by the entire lounge it is usually...

Dear Paddydive:

Welcome to the lounge.

Pivot Tables are great for numeric or dates but are bad with strings.

Before getting a Pivot Table, I think the use of the functions CountIF and SumIF...

JonTom:

Attached is a non VBA alternative. It is based on the use of simple formulas on each Tab Sheet. The example was set up for Rows 10 to 40, but that can be expanded to any length. By...

Jeremy:

If the data in the cells not having "zero length strings" are all formulas and/or numbers you could use GO TO Special - Select Constants - Select "Text" only.

This should select only...

John:

Welcome to the Lounge. Below is Code I found on the Internet. It works fine on my set-up. What it will do is create a new blank e-mail with the ActiveWorkbook as the attachement.
The...

The attachement is just a screen shot so cannot test.

Quick Tests
Please try in an open cell =Exact(0,$n10)
It should return as True, if it does not you have an issue with the amount in $n10...

tb8100:

Welcome to the Lounge. Your workbook is very well organized and formatted. It already contains large quantities of data.

However, I am not sure what you specifically want to accomplish....

Thanos:

Can you provide a simple example of data and what you expect as a final result. If you are trying to find items that are in both data sets Vlookup would not be the best approach. Perhaps...

For a general overview try Excel 2010: This Missing Manual" by Mathew McDonald or second choice Excel 2010 for Dummies.


However, if you are an Excel power user, the above books may not be a good...

The VBA Code below is from JEZZA who posted it on the site. it's post 5680 and can be found by searching this forum for "Permutations".

Put the Macro in the Module for the Workbook you want.
...

Not entirely sure what you expect

But you may want to try the following Functions "COMBIN" or "PERMU"

If not please send a simple workbook of the data and expected results.

TD

If are working with numbers there is always
= If(ISNA(A1),0,A1)

TD

Try the following VBA code to see if MS Project 7 is being recognized. Note for the example I am assuming that the term "Project" is the name of Project 7
Sub OpenProj()
Dim MyApp as...

Just a guess

Open the VBA Editor
On the VBA Editor Menu Bar Select: Tools Then References
A dialog box should open, make sure that MS Project 7 (or whtever is listed as an Available Reference...

JimmyW

The artlice I found for Excel seems to support the fact that 175 "characters" should be acceptable.

Regards,

Tom Duthie