Search results for query: *

Here is my program that creates an excel spreadsheet from SQL, but I don't know how to program it so that if the section name changes within one excel document to create a second excel spreadsheet with the 2nd section name. CREATE PROCEDURE sp_PIG_CreateNewSheet @Location varchar(4)...

I have notice that the validation for the duplicate rows will only work if the duplicates are one after the other. If I have a dup on line 37 and the other on 389, it will mark invalided duplicates.

THANKS Bowers74 and xlbo. IT WORKED!!!!!

The 3rd row would not be a duplicate. Only if the data is identical by row, lot or space using the same characters in each cell. The formula didn't work.

I am trying it now, but i forgot to mention that not all the 6 cells in the columns would have data, at the most it would be four.

No 2nd would not be a duplicate.

xlbo Sorry. The only way I think I can explain is: I have an excel sheet with about 8000 lines of data. There are 6 columns and 3 are alpha columns and 3 are numeric columns. The columns combined are like address that can not and should not be duplicated. On the spreadsheet the first row may...

I have question. I am trying to do a true false statement that will return the vaildations as Duplicates or Not Duplicates using just an excel formula for 6 columns. Heres an example Columns: Row# - RowAlpha - Lot# - LotAlpha - Space# - Space Aplha 1 C 1 1...