Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
check if there is any double information
How can I make a formula in one cell, to check in a list of products if there
is any double information. Like if there is twice "Eggs" in the list? I made already next to each cell lets say in B2 and on this formula SUMPRODUCT(LEN($A$26:$A$33)-LEN(SUBSTITUTE(LOWER($A$26:$A$33),D27,"")))/LEN(D27)) and in C2 I put in =A1 And then in a different place I put in =IF(SUM(C26:C30)-COUNT(C26:C30)0,"''You entered a product twice''","") But I want to do this all in one cell, is there a way to do this in one cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check for double information | Excel Worksheet Functions | |||
Sorting a Column and taking row information with it. | Excel Worksheet Functions | |||
Excel CSV file: How to preserve double quotation mark on Unix ftp? | Excel Discussion (Misc queries) | |||
Importing information from 2 workbooks into a 3rd one | Links and Linking in Excel | |||
Importing information from 2 workbooks into a 3rd one | Excel Worksheet Functions |