Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count number of items in a row? help *file included*
Heres a sample http://s41.yousendit.com/d.aspx?id=0...B05HVLE2166564
So I want to count the number of ticks in each row and put the total at the end of each row in the column named 1. I'm then gonna sort by that column and just move the relevant total into the relevant column (1, 2 or 3 or more). It needs to be run on every row at the same time as there are 4500 rows in the proper file and I dont feel like doing it by hand row by row. Any help?! Thanks a lot |
#2
|
|||
|
|||
Hi
I think you'd be better off posting plain text of what you have and what you want. I, for one, will not open unknown attachments. -- Andy. "Carlos" wrote in message om... Heres a sample http://s41.yousendit.com/d.aspx?id=0...B05HVLE2166564 So I want to count the number of ticks in each row and put the total at the end of each row in the column named 1. I'm then gonna sort by that column and just move the relevant total into the relevant column (1, 2 or 3 or more). It needs to be run on every row at the same time as there are 4500 rows in the proper file and I dont feel like doing it by hand row by row. Any help?! Thanks a lot |
#3
|
|||
|
|||
ok table looks something like this...
Patient Num " Cancer " Asthma " Diabetes " COPD " 1 " 2 " 3 or more " ----------------------------------------------------------------------------------------------------- 1 y 2 y y 3 y y 4 y 5 y y y y and I want Patient Num " Cancer " Asthma " Diabetes " COPD " 1 " 2 " 3 or more " ----------------------------------------------------------------------------------------------------- 1 y 1 2 y y 2 3 y y 2 4 y 1 5 y y y y 4 and then i'll format it from there |
#4
|
|||
|
|||
ok that messed up... the 1 2 2 1 4 are meant to be in the "1" column.
thanks |
#5
|
|||
|
|||
Hi
in F2 =COUNTIF(B2:E2,"y") and fill down should give you what you're looking for -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway wrote in message oups.com... ok table looks something like this... Patient Num " Cancer " Asthma " Diabetes " COPD " 1 " 2 " 3 or more " ----------------------------------------------------------------------------------------------------- 1 y 2 y y 3 y y 4 y 5 y y y y and I want Patient Num " Cancer " Asthma " Diabetes " COPD " 1 " 2 " 3 or more " ----------------------------------------------------------------------------------------------------- 1 y 1 2 y y 2 3 y y 2 4 y 1 5 y y y y 4 and then i'll format it from there |
#6
|
|||
|
|||
thanks, that works for one row, row 2.... but how do I fill down for
all the other rows, i'm stupid. thanks |
#7
|
|||
|
|||
Click on the cell in row 2 that you've done. In the bottom right-hand corner
there is a black square. Click on it and drag it down to autofill. -- Andy. wrote in message ups.com... thanks, that works for one row, row 2.... but how do I fill down for all the other rows, i'm stupid. thanks |
#8
|
|||
|
|||
definitely not stupid - you're asking questions :) none of us woke up one
day knowing this stuff .... the fill handle is located at the bottom right hand corner of the cell, if you move your cursor over it you will see a +, clicking & dragging down on this will fill in a formula or a series (try typing january in a cell and filling down or across) .... if you're using the fill handle and you have a column of data to the left or right of the cell you want to fill down, double clicking the + rather than dragging is a quick alternative. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway wrote in message ups.com... thanks, that works for one row, row 2.... but how do I fill down for all the other rows, i'm stupid. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
Count number of unique items in a column that contains duplicates | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Count of unique items meeting condition | Excel Worksheet Functions |