Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Names in 2 Columns
I have a list of referring md's for a 2 yr period. In Col A ref md (2005)
Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would like to do is to combine Col A & C and sum B & D. The issue is that Col A & C do not contain the same doctors. If Col A & C were the same then it would be sum b & D. Thanks Brad |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Names in 2 Columns
Not sure how your speadsheet is laid out. Each doctor should have his own row
Not A B C D Dr. A Dr. A Dr. B Dr. C Dr. D Dr. D Should Be A B C D Dr. A Dr. A Dr. B Dr. C Dr. D Dr. D Leave Blanks if Dr. didn't give referels for certain years. Then the sum would work properly. "alyzar" wrote: I have a list of referring md's for a 2 yr period. In Col A ref md (2005) Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would like to do is to combine Col A & C and sum B & D. The issue is that Col A & C do not contain the same doctors. If Col A & C were the same then it would be sum b & D. Thanks Brad |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Names in 2 Columns
Joel,
The problem is that "col a" and "col c" dont match up. There are more ref md's in 2006 then 2005. Is there an easier way of combining "a &c" other than inserting rows to make the name macth up? Hope this is clear for you Thanks Brad "Joel" wrote: Not sure how your speadsheet is laid out. Each doctor should have his own row Not A B C D Dr. A Dr. A Dr. B Dr. C Dr. D Dr. D Should Be A B C D Dr. A Dr. A Dr. B Dr. C Dr. D Dr. D Leave Blanks if Dr. didn't give referels for certain years. Then the sum would work properly. "alyzar" wrote: I have a list of referring md's for a 2 yr period. In Col A ref md (2005) Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would like to do is to combine Col A & C and sum B & D. The issue is that Col A & C do not contain the same doctors. If Col A & C were the same then it would be sum b & D. Thanks Brad |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Names in 2 Columns
one method might be to insert a new column c and column F
in Cell C1 =countif(A:A,A1,B:B)+Countif(D:D,A1,E:E) and in F1 enter =countif(A:A,D1,B:B++countif(D:D,D1,E:E) and copy C1 and F1 down as far as you want "alyzar" wrote: I have a list of referring md's for a 2 yr period. In Col A ref md (2005) Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would like to do is to combine Col A & C and sum B & D. The issue is that Col A & C do not contain the same doctors. If Col A & C were the same then it would be sum b & D. Thanks Brad |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Names in 2 Columns
How difficult would it be to make the Drs in A & C allign. Script could be
written to get them to allign. "alyzar" wrote: Joel, The problem is that "col a" and "col c" dont match up. There are more ref md's in 2006 then 2005. Is there an easier way of combining "a &c" other than inserting rows to make the name macth up? Hope this is clear for you Thanks Brad "Joel" wrote: Not sure how your speadsheet is laid out. Each doctor should have his own row Not A B C D Dr. A Dr. A Dr. B Dr. C Dr. D Dr. D Should Be A B C D Dr. A Dr. A Dr. B Dr. C Dr. D Dr. D Leave Blanks if Dr. didn't give referels for certain years. Then the sum would work properly. "alyzar" wrote: I have a list of referring md's for a 2 yr period. In Col A ref md (2005) Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would like to do is to combine Col A & C and sum B & D. The issue is that Col A & C do not contain the same doctors. If Col A & C were the same then it would be sum b & D. Thanks Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching names in two columns | Excel Discussion (Misc queries) | |||
match names in 2 different columns | Excel Discussion (Misc queries) | |||
Have 2 columns of names - need to filter out names not duplicated | Excel Worksheet Functions | |||
Separate names into 2 columns? | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |