| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search, compare, execute based on specified criteria
I am trying to write a script that looks for a cell with specified text
in a specified column, once it finds the cell it needs to check six different columns (a,b,c,d,e,f) one row above and find the column that has an "x", it then needs to place an "x" in its row one column to the right form the previous "x" example: if it finds the cell with "Went up the hill" the script needs to look up one row and check columns (a,b,c,d,e,f) until it finds the "X". In this case it will find the "X" on the row with "JACK AND JILL" in column "a" so it will place an "X" for the row "Went up the hill" (the orginal cell searched for) in column "b" a b c d e f g X JACK AND JILL Went up the hill To fetch 3.5 Pales of Water God bless jsd219 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search, compare, execute based on specified criteria
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search, compare, execute based on specified criteria
Send me a workbook with a detailed explanation and I will try to take a
look. Glad that we have more Austinites around. What do you do ? -- Don Guillett SalesAid Software "jsd219" wrote in message oups.com... I appreciate that and have been researching it but i am stuck. i can not figure out how to set a range of multiple columns on a single row and the row is not a constant. it will change based on the specified criteria searched for in cells God bless jsd219 PS. i live in Austin as well. :-) Don Guillett wrote: homework? use the FIND function along with OFFSET -- Don Guillett SalesAid Software "jsd219" wrote in message oups.com... I am trying to write a script that looks for a cell with specified text in a specified column, once it finds the cell it needs to check six different columns (a,b,c,d,e,f) one row above and find the column that has an "x", it then needs to place an "x" in its row one column to the right form the previous "x" example: if it finds the cell with "Went up the hill" the script needs to look up one row and check columns (a,b,c,d,e,f) until it finds the "X". In this case it will find the "X" on the row with "JACK AND JILL" in column "a" so it will place an "X" for the row "Went up the hill" (the orginal cell searched for) in column "b" a b c d e f g X JACK AND JILL Went up the hill To fetch 3.5 Pales of Water God bless jsd219 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search, compare, execute based on specified criteria
I just sent you an email with a sample spreadsheet in it. thank you for
your help. What do you do ? i own a recording Studio - Music Lane Recording What about you? God bless jsd219 Don Guillett wrote: Send me a workbook with a detailed explanation and I will try to take a look. Glad that we have more Austinites around. What do you do ? -- Don Guillett SalesAid Software "jsd219" wrote in message oups.com... I appreciate that and have been researching it but i am stuck. i can not figure out how to set a range of multiple columns on a single row and the row is not a constant. it will change based on the specified criteria searched for in cells God bless jsd219 PS. i live in Austin as well. :-) Don Guillett wrote: homework? use the FIND function along with OFFSET -- Don Guillett SalesAid Software "jsd219" wrote in message oups.com... I am trying to write a script that looks for a cell with specified text in a specified column, once it finds the cell it needs to check six different columns (a,b,c,d,e,f) one row above and find the column that has an "x", it then needs to place an "x" in its row one column to the right form the previous "x" example: if it finds the cell with "Went up the hill" the script needs to look up one row and check columns (a,b,c,d,e,f) until it finds the "X". In this case it will find the "X" on the row with "JACK AND JILL" in column "a" so it will place an "X" for the row "Went up the hill" (the orginal cell searched for) in column "b" a b c d e f g X JACK AND JILL Went up the hill To fetch 3.5 Pales of Water God bless jsd219 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search, compare, execute based on specified criteria
I develop excel projects. I will look at your workbook.
-- Don Guillett SalesAid Software "jsd219" wrote in message ups.com... I just sent you an email with a sample spreadsheet in it. thank you for your help. What do you do ? i own a recording Studio - Music Lane Recording What about you? God bless jsd219 Don Guillett wrote: Send me a workbook with a detailed explanation and I will try to take a look. Glad that we have more Austinites around. What do you do ? -- Don Guillett SalesAid Software "jsd219" wrote in message oups.com... I appreciate that and have been researching it but i am stuck. i can not figure out how to set a range of multiple columns on a single row and the row is not a constant. it will change based on the specified criteria searched for in cells God bless jsd219 PS. i live in Austin as well. :-) Don Guillett wrote: homework? use the FIND function along with OFFSET -- Don Guillett SalesAid Software "jsd219" wrote in message oups.com... I am trying to write a script that looks for a cell with specified text in a specified column, once it finds the cell it needs to check six different columns (a,b,c,d,e,f) one row above and find the column that has an "x", it then needs to place an "x" in its row one column to the right form the previous "x" example: if it finds the cell with "Went up the hill" the script needs to look up one row and check columns (a,b,c,d,e,f) until it finds the "X". In this case it will find the "X" on the row with "JACK AND JILL" in column "a" so it will place an "X" for the row "Went up the hill" (the orginal cell searched for) in column "b" a b c d e f g X JACK AND JILL Went up the hill To fetch 3.5 Pales of Water God bless jsd219 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search, compare, execute based on specified criteria
Awesome, you rock! i really appreciate it. :-)
God bles jsd219 PS. my numbers were in the email i sent you in the signature, if you have any questions feel free to call me. Again thanks Don Guillett wrote: I develop excel projects. I will look at your workbook. -- Don Guillett SalesAid Software "jsd219" wrote in message ups.com... I just sent you an email with a sample spreadsheet in it. thank you for your help. What do you do ? i own a recording Studio - Music Lane Recording What about you? God bless jsd219 Don Guillett wrote: Send me a workbook with a detailed explanation and I will try to take a look. Glad that we have more Austinites around. What do you do ? -- Don Guillett SalesAid Software "jsd219" wrote in message oups.com... I appreciate that and have been researching it but i am stuck. i can not figure out how to set a range of multiple columns on a single row and the row is not a constant. it will change based on the specified criteria searched for in cells God bless jsd219 PS. i live in Austin as well. :-) Don Guillett wrote: homework? use the FIND function along with OFFSET -- Don Guillett SalesAid Software "jsd219" wrote in message oups.com... I am trying to write a script that looks for a cell with specified text in a specified column, once it finds the cell it needs to check six different columns (a,b,c,d,e,f) one row above and find the column that has an "x", it then needs to place an "x" in its row one column to the right form the previous "x" example: if it finds the cell with "Went up the hill" the script needs to look up one row and check columns (a,b,c,d,e,f) until it finds the "X". In this case it will find the "X" on the row with "JACK AND JILL" in column "a" so it will place an "X" for the row "Went up the hill" (the orginal cell searched for) in column "b" a b c d e f g X JACK AND JILL Went up the hill To fetch 3.5 Pales of Water God bless jsd219 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data based on 2 search criteria | Excel Worksheet Functions | |||
| How do I retrieve data based on multiple search criteria? | Excel Worksheet Functions | |||
| How do I retrieve data based on multiple search criteria? | Excel Worksheet Functions | |||
| How do I compare two dBs(spreadsheets) based on multiple criteria? | Excel Worksheet Functions | |||
| Search for a specific cell based on two criteria | Excel Programming | |||
Linear Mode
