|
|
#22
03-18-2017, 06:10 AM
|
|||
|
|||
TRIED but got "type mismatch"
message for the following.... If Join(Application.Transpose(Application.Transpose(. Cells(r, 1).EntireRow.Value)), "") = _ Join(Application.Transpose(Application.Transpose(. Cells(r - 1, 1).EntireRow.Value)), "") Then I think I will just use the delete duplicates feature in excel and forsake the dupesheet feature. Thanks again for all your help. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| pivot not showing number format with commas | olybobo | Excel | 1 | 05-05-2016 05:09 PM |
 Counting Blanks in 1 Column and Non-Blanks in Another
|
dogwood705 | Excel | 4 | 02-07-2015 08:45 AM |
| Commas within fields in .csv files | gar | Excel | 1 | 01-29-2015 09:24 PM |
|
How to use mid or left functions to seperate city,st,zip with no commas
|
sinaranje | Excel | 4 | 11-11-2014 10:52 PM |
|
No inverted commas in word 2013.
|
tonycrossley | Word | 3 | 01-27-2014 04:55 PM |
Windows 10 
Office 2016
Threaded Mode