Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
isolating specific list
Hello,
I have a huge list of patients identified by number... and columns of info like gender, birthday, medical issues etc. I only need the info from 200 specific patients. How can I isolate those rows efficiently? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
isolating specific list
If there is some field which would uniquely identify thiese patients, you
could use auto or advanced filter to show just these patients or to do calulations on just thes patients if there is nothing which uniquely identifies these patients on the preadsheet, I w9ould make a helper row and mark it in a way to do the identification "Elle" wrote: Hello, I have a huge list of patients identified by number... and columns of info like gender, birthday, medical issues etc. I only need the info from 200 specific patients. How can I isolate those rows efficiently? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
isolating specific list
there are 200 patients that i need... and i tried using
=if(B2=pt1,"yes",=if(B2=pt2,"yes"........ with this repeated 200 times to include all the patients that i want... but excel wouldn't take a formula that long.... is there a way i can do an IF statement without listing all the patients in theformula? i tried just using =if(b2=d1:d200.... with my list of patients.. but that didn't work.... any suggestions? thanks =) "bj" wrote: If there is some field which would uniquely identify thiese patients, you could use auto or advanced filter to show just these patients or to do calulations on just thes patients if there is nothing which uniquely identifies these patients on the preadsheet, I w9ould make a helper row and mark it in a way to do the identification "Elle" wrote: Hello, I have a huge list of patients identified by number... and columns of info like gender, birthday, medical issues etc. I only need the info from 200 specific patients. How can I isolate those rows efficiently? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
isolating specific list
But how do you select them, just pt1 up to pt200? And the list is, just
select the whole list (make sure you have headers), then do datafilterautofilter, from dropdown select custom and use (depending on the way they are "branded") if all patients are called pt1 and so on and you want pt1 to pt200 use is greater than or equal to pt1, then in the second choice use is less than or equal to pt200 or if all the patients you want start with pt, then use begins with pt If you just want to get 200 randomly, use a help column and =RAND() copy down, sort by the help column and select the first 200 Also if this works and when you have filtered them just select the visible range and copy and paste somewhere else -- Regards, Peo Sjoblom "Elle" wrote in message ... there are 200 patients that i need... and i tried using =if(B2=pt1,"yes",=if(B2=pt2,"yes"........ with this repeated 200 times to include all the patients that i want... but excel wouldn't take a formula that long.... is there a way i can do an IF statement without listing all the patients in theformula? i tried just using =if(b2=d1:d200.... with my list of patients.. but that didn't work.... any suggestions? thanks =) "bj" wrote: If there is some field which would uniquely identify thiese patients, you could use auto or advanced filter to show just these patients or to do calulations on just thes patients if there is nothing which uniquely identifies these patients on the preadsheet, I w9ould make a helper row and mark it in a way to do the identification "Elle" wrote: Hello, I have a huge list of patients identified by number... and columns of info like gender, birthday, medical issues etc. I only need the info from 200 specific patients. How can I isolate those rows efficiently? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
isolating specific list
thanks the reply
the problem is the patient numbers are random.. for example.. i need pt 4, 89, 154.... any suggestions? "Peo Sjoblom" wrote: But how do you select them, just pt1 up to pt200? And the list is, just select the whole list (make sure you have headers), then do datafilterautofilter, from dropdown select custom and use (depending on the way they are "branded") if all patients are called pt1 and so on and you want pt1 to pt200 use is greater than or equal to pt1, then in the second choice use is less than or equal to pt200 or if all the patients you want start with pt, then use begins with pt If you just want to get 200 randomly, use a help column and =RAND() copy down, sort by the help column and select the first 200 Also if this works and when you have filtered them just select the visible range and copy and paste somewhere else -- Regards, Peo Sjoblom "Elle" wrote in message ... there are 200 patients that i need... and i tried using =if(B2=pt1,"yes",=if(B2=pt2,"yes"........ with this repeated 200 times to include all the patients that i want... but excel wouldn't take a formula that long.... is there a way i can do an IF statement without listing all the patients in theformula? i tried just using =if(b2=d1:d200.... with my list of patients.. but that didn't work.... any suggestions? thanks =) "bj" wrote: If there is some field which would uniquely identify thiese patients, you could use auto or advanced filter to show just these patients or to do calulations on just thes patients if there is nothing which uniquely identifies these patients on the preadsheet, I w9ould make a helper row and mark it in a way to do the identification "Elle" wrote: Hello, I have a huge list of patients identified by number... and columns of info like gender, birthday, medical issues etc. I only need the info from 200 specific patients. How can I isolate those rows efficiently? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
isolating specific list
It's not possible unless you have something that distinguish them unless you
have a list with just the id numbers, then you could tag them in a help column =ISNUMBER(MATCH(A2,List,0)) where List can be a named range with the IDs or a range like $G$2:$G202 copy down and the apply autofilter and filter on TRUE I mean how do you know what numbers to include? -- Regards, Peo Sjoblom "Elle" wrote in message ... thanks the reply the problem is the patient numbers are random.. for example.. i need pt 4, 89, 154.... any suggestions? "Peo Sjoblom" wrote: But how do you select them, just pt1 up to pt200? And the list is, just select the whole list (make sure you have headers), then do datafilterautofilter, from dropdown select custom and use (depending on the way they are "branded") if all patients are called pt1 and so on and you want pt1 to pt200 use is greater than or equal to pt1, then in the second choice use is less than or equal to pt200 or if all the patients you want start with pt, then use begins with pt If you just want to get 200 randomly, use a help column and =RAND() copy down, sort by the help column and select the first 200 Also if this works and when you have filtered them just select the visible range and copy and paste somewhere else -- Regards, Peo Sjoblom "Elle" wrote in message ... there are 200 patients that i need... and i tried using =if(B2=pt1,"yes",=if(B2=pt2,"yes"........ with this repeated 200 times to include all the patients that i want... but excel wouldn't take a formula that long.... is there a way i can do an IF statement without listing all the patients in theformula? i tried just using =if(b2=d1:d200.... with my list of patients.. but that didn't work.... any suggestions? thanks =) "bj" wrote: If there is some field which would uniquely identify thiese patients, you could use auto or advanced filter to show just these patients or to do calulations on just thes patients if there is nothing which uniquely identifies these patients on the preadsheet, I w9ould make a helper row and mark it in a way to do the identification "Elle" wrote: Hello, I have a huge list of patients identified by number... and columns of info like gender, birthday, medical issues etc. I only need the info from 200 specific patients. How can I isolate those rows efficiently? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Isolating text and numbers | Excel Discussion (Misc queries) | |||
Isolating mailadresses | Excel Worksheet Functions | |||
if specific value from list A equals one of the values from list b... | Excel Worksheet Functions | |||
Isolating months | Excel Discussion (Misc queries) | |||
Isolating a custom toolbar to a specific spreadsheet | Excel Discussion (Misc queries) |