Posts by DonJ

  • Percentage Of Cell Value To Number Count

    Hey guys,


    I know for some of you this will be pretty simple but im having trouble figuring it out. Attached is a shortened version of what i am trying to do. I want the Percent Attendance column to represent the cumulative percentage(hope I used the correct phrase). So for Person 1, it should currently say 100%, person 2 it should say 66.67% and so on. There are 5 days that i want to get the percentage, but because we haven't gotten to 2 of them yet, using a regular sum formula for the entire five days gives me the wrong values. Any thoughts?


    Thanks,


    Don

  • Merge Adjacent Cells At Each Change In Column

    I have a list of values, some are like values, others are not. is there a way to have the column to the right automatically merge the cells which have like information to their left. Attached is a sample file.


    I want to be able to have the cells in column B automatically merge based on the values in column A. I'm not sure if this can be done, but figured I would ask before I spend hours merging cells.


    Thanks,


    Don

  • Summing Totals Of Filter Results

    A friend of mine asked if there is a formula that will add the "Y"'s and "N"'s based off of a filter per certain dates. Below is a brief example.


    2/18/2009 Y
    8/15/2006 N
    2/18/2009 Y
    8/15/2006 N
    4/6/2005 N
    4/6/2005 N



    We want to be able to sort by dates so regardless of which date we pick, below the Y's and N's will be the total for the Y's and N's that are visible. If sorted by April, it will show 2 N's and 0 Y's, and so on. Is there any formula out there that can do this. The simpler it is the better.


    Thanks,


    Don

  • Putting The "right" Command In A Macro

    I am trying to add a formula to use the "Right" command in a macro, but I dont want it to remove any characters on certain cells. For instance i want to remove the seventh digit from the right only if it is a Zero. If it is any other number, i want it to skip that cell.


    00234XX
    021V54Q
    1405RS1
    5843TP1


    So i would only want it to remove the zero from the top two and leave the last two as they are. The ammount of information changes on a daily basis so the formula would have to be able to distinguish the values of the first digit. Any help is appreciated if this is possible.


    Thanks,


    Don

  • Convert Multiple Cells Into One

    Re: Convert Multiple Cells Into One


    Thank you for the input. I took a look at the pivot tables and I am definately going to have to experiment with them more. I however dont think they would help me much this time because the data I am trying to get has to be put into an already existing spreadsheet. The data that I am pulling from, such as the example has to be imported to another spreadsheet, which I was thinking about using vlookup to match the info up. I have used Excell for years, but untill now I have never done much when it comes to scripting or macros. I tried changing the variable for Y and X, but it sends it into an endless loop or something. Sorry for the lack of knowledge, I never knew Excell was capable of so much. I think I have begun to get myself into things a bit over my head now. Thank you all for your help so far, and any additional help is appreciated.


    Thanks again.

  • Convert Multiple Cells Into One

    Re: Converting Multiple Cells Into One


    Im not sure what a pivot table is Batman.


    The script does work, but there is something I didn't think of. The data from the left column of my document isn't just numbers, it has letters also. So it keeps erroring out on "Y = Y + 1 ". I keep getting a runtime error '6', Overflow error. Hopefully this doenst cause any major problems or changes. I dont really know what to try or change to get it to work.


    Thanks again.

  • Convert Multiple Cells Into One

    In the attached file, I created an example of a list I’m trying to break down and combine data from multiple cells into one cell. As it shows on sheet1, level 1 has two people who occupy it, Paul and Peter. I am trying to get the names Paul and Peter to be combined in one cell next to the #1 as shown on sheet2. I want it to put the correct amount of people next to their corresponding number as shown on sheet2. Is there anything that I can use that may make my life a little simpler? This will be done on a weekly basis, and incorporates a couple hundred items. Any help is appreciated.


    Thanks.

  • Move Data From One Column To Multiple Columns

    Re: Move Data From One Column To Multiple Columns


    Thank you very much Jetted. this is working great so far. I have come across one minor problem that im sure is easy to fix. I have two items with similar names, such as L_MATCH and L_MATCH_2. If i wanted to just pull the information that is related to L_MATCH it also pulls the information for L_MATCH_2 and puts the information from both in the same column. How can I make it look for only L_MATCH so I only get that information? Otherwise this is working out wonderfully. Thanks for your help so far.

  • Move Data From One Column To Multiple Columns

    I am trying to move information that is pulled from a database to look cleaner and easier to read. All of the information exports out into column A only. The attachment is a brief example of what it looks like, and what I’m trying to get it to look like.


    There are a couple thousand sets of information, and their much longer. Each one has 58 lines plus the blank separator row.


    I have some basic experience with formulas and macros, but I haven’t had any luck trying to manipulate any of them to give me the information the way I have shown. I would prefer to not have to manually type or cut and past the information in if possible.


    Thanks to anyone who can assist.

  • Formula to find something in a column that i specify

    Re: Formula to find something in a column that i specify


    thank you for your response. I guess I didnt explain it the way I should have. I did some more searching and found that the command COUNTIF was exactly what i was looking for. The color thing would have been nice, but not necessary I found out. Thank you for your response, I appreciat it.

  • Can you automatically hide duplicate entries?

    I am trying to hide any duplicate rows in a spreadsheet that is exported from a much larger database.


    For instance. Say the column i am trying to sort by, and hide duplicates looks something like this.


    1
    3
    5
    1
    1
    8


    I want to know if there is a way to have excell automatically hide every row that has a 1 in it, but one. So when im done, there will be only one 1, 3, 5, and 8 in the column. This will be going into a macro, along with other things. The information that is pulled is well over 1000 rows, and it is pulled weekly, so if it has to be done manually, it will take quite a while each week. Thanks in advance for all your help.

  • Formula to find something in a column that i specify

    I am trying to write a formula that will allow me to enter a number in a field, and find it in another column that i specify and select it or color it so i know where it is. If there is a duplicate, i would like it to find both. Or, if I have numbers from 1-10, and i click on one of the numbers in that column, it will find the same number in another column. Im not sure if i am explaining this correctly, but im not too savvy with excell, and i havent been able to find anything in help yet that was helpful. Thank you for your time and any help is much appreciated.