vlookup / if ?
In a tech data sheet, I am entering PO #'s in column A:A, and as i fill out
the rest of the rows information, I select a salesperson from a DROP DOWN list in column C:C. What I would like to do is return all PO #'s per each salesperson without duplication. On an individual row basis, i set up: =if(C2="josh",A2,"") where C2 = drop down list & A2 = PO # If column C row 2 = "josh" (from a drop down list) , then return PO # from row column A row 2. If not, return (blank) However, I would like to search the entire column. I want to be able to search column C:C for any time "JOSH" is selected from the list, and return that rows PO # from column A:A. =if(C:C="josh",A:A,"") I assume this will have numerous flaws.. duplicates etc Any ideas? cheers! -Scott |
vlookup / if ?
You could use Advanced Filter and select unique records.
Here's some info: http://www.contextures.com/xladvfilter01.html#FilterUR Dave -- Brevity is the soul of wit. "scott" wrote: In a tech data sheet, I am entering PO #'s in column A:A, and as i fill out the rest of the rows information, I select a salesperson from a DROP DOWN list in column C:C. What I would like to do is return all PO #'s per each salesperson without duplication. On an individual row basis, i set up: =if(C2="josh",A2,"") where C2 = drop down list & A2 = PO # If column C row 2 = "josh" (from a drop down list) , then return PO # from row column A row 2. If not, return (blank) However, I would like to search the entire column. I want to be able to search column C:C for any time "JOSH" is selected from the list, and return that rows PO # from column A:A. =if(C:C="josh",A:A,"") I assume this will have numerous flaws.. duplicates etc Any ideas? cheers! -Scott |
vlookup / if ?
This seems like something I would use to filter an end result. Is there
something I could set up for an ongoing process? Thanks for your reply! "Dave F" wrote: You could use Advanced Filter and select unique records. Here's some info: http://www.contextures.com/xladvfilter01.html#FilterUR Dave -- Brevity is the soul of wit. "scott" wrote: In a tech data sheet, I am entering PO #'s in column A:A, and as i fill out the rest of the rows information, I select a salesperson from a DROP DOWN list in column C:C. What I would like to do is return all PO #'s per each salesperson without duplication. On an individual row basis, i set up: =if(C2="josh",A2,"") where C2 = drop down list & A2 = PO # If column C row 2 = "josh" (from a drop down list) , then return PO # from row column A row 2. If not, return (blank) However, I would like to search the entire column. I want to be able to search column C:C for any time "JOSH" is selected from the list, and return that rows PO # from column A:A. =if(C:C="josh",A:A,"") I assume this will have numerous flaws.. duplicates etc Any ideas? cheers! -Scott |
vlookup / if ?
I'm not sure what you mean by ongoing process.
Perhaps you can record a macro in which you use the advanced filter and then assign that macro to a button. -- Brevity is the soul of wit. "scott" wrote: This seems like something I would use to filter an end result. Is there something I could set up for an ongoing process? Thanks for your reply! "Dave F" wrote: You could use Advanced Filter and select unique records. Here's some info: http://www.contextures.com/xladvfilter01.html#FilterUR Dave -- Brevity is the soul of wit. "scott" wrote: In a tech data sheet, I am entering PO #'s in column A:A, and as i fill out the rest of the rows information, I select a salesperson from a DROP DOWN list in column C:C. What I would like to do is return all PO #'s per each salesperson without duplication. On an individual row basis, i set up: =if(C2="josh",A2,"") where C2 = drop down list & A2 = PO # If column C row 2 = "josh" (from a drop down list) , then return PO # from row column A row 2. If not, return (blank) However, I would like to search the entire column. I want to be able to search column C:C for any time "JOSH" is selected from the list, and return that rows PO # from column A:A. =if(C:C="josh",A:A,"") I assume this will have numerous flaws.. duplicates etc Any ideas? cheers! -Scott |
vlookup / if ?
Your source data seems to be ideal for a pivot table. It can easily be
'refreshed' after new records are added. You can also easily optain information by salesperson, PO, etc. -- T Tipsy "scott" wrote: In a tech data sheet, I am entering PO #'s in column A:A, and as i fill out the rest of the rows information, I select a salesperson from a DROP DOWN list in column C:C. What I would like to do is return all PO #'s per each salesperson without duplication. On an individual row basis, i set up: =if(C2="josh",A2,"") where C2 = drop down list & A2 = PO # If column C row 2 = "josh" (from a drop down list) , then return PO # from row column A row 2. If not, return (blank) However, I would like to search the entire column. I want to be able to search column C:C for any time "JOSH" is selected from the list, and return that rows PO # from column A:A. =if(C:C="josh",A:A,"") I assume this will have numerous flaws.. duplicates etc Any ideas? cheers! -Scott |
All times are GMT +1. The time now is 04:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com