Count IF

[judas]

Hi there, I need some help here, thanks in advance if you can help me!

I have a little Database that's layed out like this:

Date; Name; Proc1; Proc2; Proc3

Every day someone will fill in the different fields for each patient, so some would have 3 procedures made, some only 1, etc. The Procedures can be any of ariound 30 procedures, so in Proc1 there can be ine of 30 procedures.

I need to create a table to summarize this data, i.e. count how many ablations were performed every day...I find this can be made by creating a countif function, but i have read that slows things down.

How would you do it? Thank You!

 

[lenze]

The word is Pivot Table, but you need to correct you data layout.
You only need 1 column for procedures.



lenze

 

[judas]

Yes, i had thought of a pivot table but found the problem you mention. How can I handle the case were a single patient has multiple procedures without entering several lines?

 

[lenze]

I'm guessing, so I don't know. But you only need 1 column for procedures. I assume each patient has a unique ID. There is reason Excel has more rows than columns
HTH

lenze

 

[judas]

That is right, every patient has a unique ID. The only problem would be entering the data, as if a patient had 6 procedures performed, you would have to enter some of the fields 6 times (I Know a copy and paste would work, but I'm trying to make the entering of data as straight forward and error free as possible).

I actually do like your approach better, ¿how would you change the typing of data?

Thanks for your replies!

 

[judas]

Hi...I found this...do you think this is a good option to populate the table? How would you code the macro so it adds a new line for every procedure?

Thanks!!

http://www.meadinkent.co.uk/xl-update-list.htm

 

[lenze]

Just use the built in data form, or possibly John Walkenbach's enhanced version.
http://www.j-walk.com/ss/

lenze