Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find a last value in a column in excel
i set up a table in my spreadsheet that has 45 rows and 16 columns. In
column A, I have multiple values of P01 to P16 (this stands for the projectgroup) What I want to do now is to find the last row that contains P02 for an instance (because that would mean that the project is not finished yet and may not start a new project) and highlight it with yellow, so i can see it easily and be able to update it... i don't know if it's possible but i'm realy hopng that there's a vba code or formula/function that i can use... and one more thing, can anyone pls give me a vba code/formula to compute for duration(colG) on how long the group was able to finish a certain task of their project. startTime and endTime in columns E and F. say for example: P02 PROJ2182 Feb-21-2012 TaskAnnex-01 08:00:00 AM 10:17:00 PM (DURATION) i need a vba code that will help me compute the duration automatically when i enter the endTime in column F. pls help! and thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find a last value in a column in excel
On Feb 21, 10:33*am, Roxan Saligan wrote:
i set up a table in my spreadsheet that has 45 rows and 16 columns. In column A, I have multiple values of P01 to P16 (this stands for the projectgroup) What *I want to do now is to find the last row that contains P02 for an instance (because that would mean that the project is not finished yet and may not start a new project) and highlight it with yellow, so i can see it easily and be able to update it... i don't know if it's possible but i'm realy hopng that there's a vba code or formula/function that i can use... and one more thing, can anyone pls give me a vba code/formula to compute for duration(colG) on how long the group was able to finish a certain task of their project. startTime and endTime in columns E and F. say for example: P02 * *PROJ2182 * *Feb-21-2012 * *TaskAnnex-01 * 08:00:00 AM 10:17:00 PM * (DURATION) i need a vba code that will help me compute the duration automatically when i enter the endTime in column F. *pls help! and thanks in advance! Send file,with complete explanation, to dguillett1 @gmail.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB macro script to find column A in Excel when row not known | Excel Programming | |||
Excel 2002: How to find 0.00 in a column of number? | Excel Discussion (Misc queries) | |||
Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
Excel 2000: How to find a certain character in ANY Column? | Excel Discussion (Misc queries) | |||
How do I tell Excel to find the last item in a column? | Excel Discussion (Misc queries) |