scooper2000
New Member
- Joined
- Mar 30, 2011
- Messages
- 2
Problem 1.
**The number of rows and columns is different on each excel file.
** Row 1 consist of title: First Name, Last Name, Phone, City, State, etc.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
I currently have the state abbreviation under the column title "State", which in this example is column H and I have this formula =IF(OR(H2="CO",H2="CA",H2="SC",H2="WV",H2="WI",H2="KS"),"Yes","No") in the column title " Region" which in this example is column V. This will display either "Yes" or "No" under the Region (V) column depending on the state in the H column. However, the state column is not always in H and same with the "Region" Column is not always in V. Can some help me with the code so that it can locate the column with the title "State" and perform the function in the "Region" column?
Problem 2 (similar to problem 1)
Column with the title name "Region" in this example is in column V. I have this formula =COUNTIF(V2:V1000,"Yes") in the column title "Num Count" which in this example is column W. The "Region" and "Num Count" is not always in the same column. Please help me with the code to locate the column with the title Region and perform the count under "Num Count" column.
Problem 3
Locate column with the title name "Last Results" and put "None" or "Good" accordingly by the data in the Region column. If the data in the Region column shows "Yes" then put Good and if the data shows "No" then put none. See excel file attached. "Last Results and Region is not always in the same column so it needs to do the search for the title name before performing the actions.
Problem 4
Column with the title name "File Name" is in column O and this formula =MID(O2,4,9) is under the column title "File Date". I need the same thing done for these title name like problem 1 and 2 since these two title is not always in the same column. Locate the column with the title name "File Name" and perform MID function in column title "File Date".
Once the MID Function is done in the "File Date" column. I need it to be in MM/DD/YY format in the "File Date" column. For some reason after it does the MID function, I cannot format the column. Due to this reason, our system does not recognize it as numeric digits. I always have to retype the date before I can import the file.
<o></o>
I would like all three of these codes separately so that I can run them as needed. alt +F11
I hope someone can help me with this. I have attached a sample file so that you can have a better picture of one I trying to accomplish. Thanks in advance!!!!
<o></o>http://www.box.net/shared/14tj7ppbd5
**The number of rows and columns is different on each excel file.
** Row 1 consist of title: First Name, Last Name, Phone, City, State, etc.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o><o
></o>I currently have the state abbreviation under the column title "State", which in this example is column H and I have this formula =IF(OR(H2="CO",H2="CA",H2="SC",H2="WV",H2="WI",H2="KS"),"Yes","No") in the column title " Region" which in this example is column V. This will display either "Yes" or "No" under the Region (V) column depending on the state in the H column. However, the state column is not always in H and same with the "Region" Column is not always in V. Can some help me with the code so that it can locate the column with the title "State" and perform the function in the "Region" column?
Problem 2 (similar to problem 1)
Column with the title name "Region" in this example is in column V. I have this formula =COUNTIF(V2:V1000,"Yes") in the column title "Num Count" which in this example is column W. The "Region" and "Num Count" is not always in the same column. Please help me with the code to locate the column with the title Region and perform the count under "Num Count" column.
Problem 3
Locate column with the title name "Last Results" and put "None" or "Good" accordingly by the data in the Region column. If the data in the Region column shows "Yes" then put Good and if the data shows "No" then put none. See excel file attached. "Last Results and Region is not always in the same column so it needs to do the search for the title name before performing the actions.
Problem 4
Column with the title name "File Name" is in column O and this formula =MID(O2,4,9) is under the column title "File Date". I need the same thing done for these title name like problem 1 and 2 since these two title is not always in the same column. Locate the column with the title name "File Name" and perform MID function in column title "File Date".
Once the MID Function is done in the "File Date" column. I need it to be in MM/DD/YY format in the "File Date" column. For some reason after it does the MID function, I cannot format the column. Due to this reason, our system does not recognize it as numeric digits. I always have to retype the date before I can import the file.
<o
></o>I would like all three of these codes separately so that I can run them as needed. alt +F11
I hope someone can help me with this. I have attached a sample file so that you can have a better picture of one I trying to accomplish. Thanks in advance!!!!
<o
></o>http://www.box.net/shared/14tj7ppbd5
Last edited:
