| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formula
can a formula be made to do the following:
if a line item has the same name in column C then add 1 to column B i.e. the count column is generated depending on the name field date count name address oct-1 1 bob 123 first st oct 1 1 john 789 ave a oct 5 1 ed 456 main st oct 3 2 bob 123 first st oct 2 1 bill 81 second st oct 2 3 bob 123 first st |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formula
Try the below formula in B2 and copy down as required
=COUNTIF(C$2:C2,C2) 'OR to handle blanks try the below =IF(C2<"",COUNTIF(C$2:C2,C2),"") If this post helps click Yes --------------- Jacob Skaria "ghcajo" wrote: can a formula be made to do the following: if a line item has the same name in column C then add 1 to column B i.e. the count column is generated depending on the name field date count name address oct-1 1 bob 123 first st oct 1 1 john 789 ave a oct 5 1 ed 456 main st oct 3 2 bob 123 first st oct 2 1 bill 81 second st oct 2 3 bob 123 first st |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formula
"Jacob Skaria" wrote: Try the below formula in B2 and copy down as required =COUNTIF(C$2:C2,C2) 'OR to handle blanks try the below =IF(C2<"",COUNTIF(C$2:C2,C2),"") If this post helps click Yes --------------- Jacob Skaria "ghcajo" wrote: can a formula be made to do the following: if a line item has the same name in column C then add 1 to column B i.e. the count column is generated depending on the name field date count name address oct-1 1 bob 123 first st oct 1 1 john 789 ave a oct 5 1 ed 456 main st oct 3 2 bob 123 first st oct 2 1 bill 81 second st oct 2 3 bob 123 first st ALL THE COLUMN B CAME OUT TO 1, I need it to add 1 if it was already listed. See bob has 3 entries. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formula
Did you try the formula?
Copy paste the formula to cell B2 and copy down as required.. Try and feedback If this post helps click Yes --------------- Jacob Skaria "ghcajo" wrote: "Jacob Skaria" wrote: Try the below formula in B2 and copy down as required =COUNTIF(C$2:C2,C2) 'OR to handle blanks try the below =IF(C2<"",COUNTIF(C$2:C2,C2),"") If this post helps click Yes --------------- Jacob Skaria "ghcajo" wrote: can a formula be made to do the following: if a line item has the same name in column C then add 1 to column B i.e. the count column is generated depending on the name field date count name address oct-1 1 bob 123 first st oct 1 1 john 789 ave a oct 5 1 ed 456 main st oct 3 2 bob 123 first st oct 2 1 bill 81 second st oct 2 3 bob 123 first st ALL THE COLUMN B CAME OUT TO 1, I need it to add 1 if it was already listed. See bob has 3 entries. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formula
"Jacob Skaria" wrote: Did you try the formula? Copy paste the formula to cell B2 and copy down as required.. Try and feedback If this post helps click Yes --------------- Jacob Skaria "ghcajo" wrote: "Jacob Skaria" wrote: Try the below formula in B2 and copy down as required =COUNTIF(C$2:C2,C2) 'OR to handle blanks try the below =IF(C2<"",COUNTIF(C$2:C2,C2),"") If this post helps click Yes --------------- Jacob Skaria "ghcajo" wrote: can a formula be made to do the following: if a line item has the same name in column C then add 1 to column B i.e. the count column is generated depending on the name field date count name address oct-1 1 bob 123 first st oct 1 1 john 789 ave a oct 5 1 ed 456 main st oct 3 2 bob 123 first st oct 2 1 bill 81 second st oct 2 3 bob 123 first st ALL THE COLUMN B CAME OUT TO 1, I need it to add 1 if it was already listed. See bob has 3 entries. I just noticed that at the end of the formula the } is missing. I tried to redo it and it will not show up. If I look at the function argument the totals are right. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formula
"ghcajo" wrote: "Jacob Skaria" wrote: Did you try the formula? Copy paste the formula to cell B2 and copy down as required.. Try and feedback If this post helps click Yes --------------- Jacob Skaria "ghcajo" wrote: "Jacob Skaria" wrote: Try the below formula in B2 and copy down as required =COUNTIF(C$2:C2,C2) 'OR to handle blanks try the below =IF(C2<"",COUNTIF(C$2:C2,C2),"") If this post helps click Yes --------------- Jacob Skaria "ghcajo" wrote: can a formula be made to do the following: if a line item has the same name in column C then add 1 to column B i.e. the count column is generated depending on the name field date count name address oct-1 1 bob 123 first st oct 1 1 john 789 ave a oct 5 1 ed 456 main st oct 3 2 bob 123 first st oct 2 1 bill 81 second st oct 2 3 bob 123 first st ALL THE COLUMN B CAME OUT TO 1, I need it to add 1 if it was already listed. See bob has 3 entries. I just noticed that at the end of the formula the } is missing. I tried to redo it and it will not show up. If I look at the function argument the totals are right. I saved the file. then reloaded it and the counts were correct. THANKS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Linear Mode
