I'm trying to create a named formula or a macro to accomplish the following tasks:
- Read a specified column, if a certain value exists,
- Sum the corresponding values in another column.
- Place the total in a specified cell.
- Insert a blank row below the last specified column...
EIN Participant's Name Course # Completion Date Completed
4320343 ACTON MARILYN 4450300 7/2/2014 Y
4320343 ACTON MARILYN 10021150 6/2/2014 Y
4320343 ACTON MARILYN 4360106 6/4/2014 Y
4320343 ACTON MARILYN 4360106CL 6/4/2014 Y
4372982...
Here is the test data.
EMP# LASTN FIRSTN SENIORITY HOLIDAY WORKED VOLUNTEER MANDATE
1 SMITH JASON 1/2/1980 MLK Y Y
1 SMITH JASON 1/2/1980 PD
1 SMITH JASON 1/2/1980 CD
1 SMITH JASON 1/2/1980 VD
2 JOHNSON WILMA 3/8/1984 MLK Y Y
2 JOHNSON WILMA 3/8/1984 PD Y Y
2 JOHNSON WILMA 3/8/1984 CD Y Y
2...
Im searching for my passion, you know that thing that makes my heart sing. I mean Im listening for the pitter patter in my ticker. So how do I know if Excel is it? Or anything for that matter. Im looking for that thing that will make me turn my tv off. (TV is my crack, Im truly addicted)...
Scenario:
I have 10 employees and 5 holidays for which I must staff 5 employees. To determine which 5, I first need to see which of the 10 employees volunteered to work. Next, once I have the volunteers, I must determine who is least senior of the 10, they will be mandatoried. So, volunteers...
Howdy from down south. I want to be the "go to" person for Excel. Actually, my coworkers already think of me that way, but I really want to be the legend Ive been crowned to be. So here I am. Im hoping to pick the very lint of your brains for all the dirty little Excel tidbits. ;)