A message box popups when you duplicate in a column
Thanks
Lloyd

Does anyone know which function to determine 1 and 2 standard deviation?
The STDEV does not specific any number.
Thank you
Eric

Good Day to all!
Is there any possibility to use the SUMIF function along with AutoFilter?
I have the following situation:
Column A: Clients' names

If we want to transpose a range of cells in a row which contains "sum"
formula, the values in the row change after transpose. One olution is to use
"paste link". However the "paste link" is disabled when the transpose
checkbox is checked.

=IF(O2=P2,AND(P2,J2&"                                      "&K2),P2)
I want my register to put a date in to a field if its done on time (there
will be a planned date already specified) and also move text from one cell
and add it onto another one to show that it has been carried ...

I have a line of 500 order numbers & need to break it down into how many line
refer to the different order numbers, i.e o/n 100002 = 2 lines 100003 = 3
lines   100004 = 2 lines = 7 lines on the orders total. Is there any way that
I can sort the column so it counts each individual ...

Hi everyone.  I've spent quite a few hours looking all over the internet and
within this community for the answer to my question.  While there are various
solutions out there [using SUMPRODUCT for example (which I've never used)], I
can't seem to find one that specifically ...

I need to add in the following conditional formats and was wondering if
anyone can help.
If L1 is not equal to N1 the colour row Yellow
If L1 is equal to N1 & O1 equals A, colour row Green

I want to enter eg. barcodes in the rows, it must not allow me to duplicate
the same barcode.
Thanks

I am trying to count the number of entries that appear in a range of data and
see if it matches a cell (or text) that I have.  The problem is the text
could contain a variety of data after the beginning of the statment.
Ie Newspaper Ad could be "Newspaper Ad: The Age", or ...

=(SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CF2:CF64,LEN($A28))=$A28))+SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CG2:CG64,LEN($A28))=$A28))
+
SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CH2:CH64,LEN($A28))=$A28))+

I've got a helper column (column B) with a formula that looks at a
time stamp in column A.  I'm trying to get each cell in column B to
say Yes if the time in the adjoining cell in column A is earlier than
3:30 pm, and No if it's later than 3:30 pm.  What I currently have is

Hello my friends, I tried everything but I am stumped! My database is a list
of 324 names with 24 columns with their details (address and other specific
characteristics  - for example: male, female, English, Spanish, etc...). I
use this database for mail merge. What I am trying ...

Almost got it !
from previous question of Luke "Array Help" yesterday, where the checked
answer is :
on B

I am new in here. Could someone give me a tip on how to manage this:
I have numbers in two columns (Aerea A2:B22).
In A1 I want to sum up the values in A2:A22 where the cell in column A is