| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i tell if i have ented the same numbers twice in a column
I enter orders we receive for our business. I list them down in a column, is
there anyway I can tell if I have entered one more than once without having to go back and check every time? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a column
You could use conditional formatting, with a formula of say
=COUNTIF(B:B,B1)1. This will then highlight them both as you enter it. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" <items entered wrote in message ... I enter orders we receive for our business. I list them down in a column, is there anyway I can tell if I have entered one more than once without having to go back and check every time? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a column
If you apply a conditional format to your column your can make duplicate entires stand out, so as soon as the second value is entered they will both change colour If your data is in column A try the following in cell a2 =COUNTIF(A:A,a2)1 entered under formula is in conditional formating and select a colour to highlight it This can then be copied and pasted as formats to the other cells If it does not work, check that excel has not enclosed the formula in quotes, if it has delete them! Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=538446 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a column
thank you that is a great idea i will try that
"items entered twice" wrote: I enter orders we receive for our business. I list them down in a column, is there anyway I can tell if I have entered one more than once without having to go back and check every time? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a col
thank you that has helped
"Dav" wrote: If you apply a conditional format to your column your can make duplicate entires stand out, so as soon as the second value is entered they will both change colour If your data is in column A try the following in cell a2 =COUNTIF(A:A,a2)1 entered under formula is in conditional formating and select a colour to highlight it This can then be copied and pasted as formats to the other cells If it does not work, check that excel has not enclosed the formula in quotes, if it has delete them! Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=538446 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a col
i'm sorry i tried that and it wouldn't work correctly
"Bob Phillips" wrote: You could use conditional formatting, with a formula of say =COUNTIF(B:B,B1)1. This will then highlight them both as you enter it. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" <items entered wrote in message ... I enter orders we receive for our business. I list them down in a column, is there anyway I can tell if I have entered one more than once without having to go back and check every time? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a col
i'm sorry i tried and it wouldn't work correctly
"Dav" wrote: If you apply a conditional format to your column your can make duplicate entires stand out, so as soon as the second value is entered they will both change colour If your data is in column A try the following in cell a2 =COUNTIF(A:A,a2)1 entered under formula is in conditional formating and select a colour to highlight it This can then be copied and pasted as formats to the other cells If it does not work, check that excel has not enclosed the formula in quotes, if it has delete them! Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=538446 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a col
Do want to expand on that? What did happen?
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" wrote in message ... i'm sorry i tried that and it wouldn't work correctly "Bob Phillips" wrote: You could use conditional formatting, with a formula of say =COUNTIF(B:B,B1)1. This will then highlight them both as you enter it. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" <items entered wrote in message ... I enter orders we receive for our business. I list them down in a column, is there anyway I can tell if I have entered one more than once without having to go back and check every time? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a col
FALSE popped up I put the correct letters in place of the ones you had in
there and it still didn't respnded correctly. Here is an example of what the numbers look like that i key in 239089 694185 276784 All of which are keyed in column D "Bob Phillips" wrote: Do want to expand on that? What did happen? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" wrote in message ... i'm sorry i tried that and it wouldn't work correctly "Bob Phillips" wrote: You could use conditional formatting, with a formula of say =COUNTIF(B:B,B1)1. This will then highlight them both as you enter it. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" <items entered wrote in message ... I enter orders we receive for our business. I list them down in a column, is there anyway I can tell if I have entered one more than once without having to go back and check every time? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a col
I suggested adding it in Conditional Formatting, not in a worksheet. To do
so, select your column (say column B), goto FormatConditional Formatting, change Condition 1 to Formula Is, and add that formula. Click Format, select Pattern, choose a colour, then OK. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" wrote in message ... FALSE popped up I put the correct letters in place of the ones you had in there and it still didn't respnded correctly. Here is an example of what the numbers look like that i key in 239089 694185 276784 All of which are keyed in column D "Bob Phillips" wrote: Do want to expand on that? What did happen? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" wrote in message ... i'm sorry i tried that and it wouldn't work correctly "Bob Phillips" wrote: You could use conditional formatting, with a formula of say =COUNTIF(B:B,B1)1. This will then highlight them both as you enter it. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "items entered twice" <items entered wrote in message ... I enter orders we receive for our business. I list them down in a column, is there anyway I can tell if I have entered one more than once without having to go back and check every time? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i tell if i have ented the same numbers twice in a col
Why not apply validation so it will tell you when you enter a number more
than once? http://www.cpearson.com/excel/NoDupEntry.htm try to read the instructions carefully this time, the suggestions you received previously all work but you need to follow them, conditional formatting is applied via formatconditional formatting, not by putting the formulas in cells -- Regards, Peo Sjoblom http://nwexcelsolutions.com "items entered twice" wrote in message ... i'm sorry i tried and it wouldn't work correctly "Dav" wrote: If you apply a conditional format to your column your can make duplicate entires stand out, so as soon as the second value is entered they will both change colour If your data is in column A try the following in cell a2 =COUNTIF(A:A,a2)1 entered under formula is in conditional formating and select a colour to highlight it This can then be copied and pasted as formats to the other cells If it does not work, check that excel has not enclosed the formula in quotes, if it has delete them! Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=538446 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a column of numbers, with a condition | New Users to Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Consecutive Numbers down a column not to Exceed 49 | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
Linear Mode
