Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.office.misc
|
|||
|
|||
Double Entries in Excel
"S1L1Y1" wrote...
I have Office XP. I am working with Excel How can I check if I didn't enter something twice? Depends on the layout of the entry cells. If you're entering into a single-area range named RNG, you could use a formula like =SUMPRODUCT((1-ISBLANK(RNG))/(COUNTIF(RNG,RNG)+ISBLANK(RNG)))=COUNTA (RNG) The ISBLANK terms avoid #DIV/0! errors when there are blank cells. The SUMPRODUCT term is the number of distinct, nonblank values in RNG, so this formula checks that the number of these values equals the number of nonblank values in RNG. It returns TRUE when all entries are distinct, FALSE when there are duplicate entries. Your posting had a follow-up tag set to microsoft.public.excel.misc, which is a better newsgroup than microsoft.public.office.misc, but you either multiposted or posted only to the *.office.* newsgroup rather than to the *.excel.* newsgroup but set the follow-up to the latter newsgroup. That's generally a bad idea since it fractures threads. Better to crosspost to multiple newsgroups originally with a follow-up tag to one of them. |
#2
Posted to microsoft.public.excel.misc,microsoft.public.office.misc
|
|||
|
|||
Double Entries in Excel
Thank You. I have many rows that are double not just one cell/ How do I
cross post? Sol "Harlan Grove" wrote in message ... "S1L1Y1" wrote... I have Office XP. I am working with Excel How can I check if I didn't enter something twice? Depends on the layout of the entry cells. If you're entering into a single-area range named RNG, you could use a formula like =SUMPRODUCT((1-ISBLANK(RNG))/(COUNTIF(RNG,RNG)+ISBLANK(RNG)))=COUNTA (RNG) The ISBLANK terms avoid #DIV/0! errors when there are blank cells. The SUMPRODUCT term is the number of distinct, nonblank values in RNG, so this formula checks that the number of these values equals the number of nonblank values in RNG. It returns TRUE when all entries are distinct, FALSE when there are duplicate entries. Your posting had a follow-up tag set to microsoft.public.excel.misc, which is a better newsgroup than microsoft.public.office.misc, but you either multiposted or posted only to the *.office.* newsgroup rather than to the *.excel.* newsgroup but set the follow-up to the latter newsgroup. That's generally a bad idea since it fractures threads. Better to crosspost to multiple newsgroups originally with a follow-up tag to one of them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup double entries... help!!! | Excel Discussion (Misc queries) | |||
list double entries | Excel Discussion (Misc queries) | |||
Checking for double entries | Excel Discussion (Misc queries) | |||
Remove double data entries | Excel Discussion (Misc queries) | |||
Check for double entries in a row | Excel Worksheet Functions |