Posts by Hoowzer

    Thanks Bosco_yip. Unfortunately I only have Office Pro Plus 2016, but your first formula worked wonders for me.


    Appreciate the help Sir:)

    Hi Folks -


    Struggling to find out how to make this work so wanted to reach out.


    On the attached spreadsheet I'm trying to return Column F (Rep Firm) based on some criteria. What I would like to happen is for an equation to look at Column G. If Column G has a:

    • "N" - then nothing needs to happen
    • "Y" - then look at what is in column C (Channel) and do a lookup on the 2nd tab (Lookup) and display the right firm based on that state (Column B) in that row

    For Example for Row 2 -

    • Has a "Y" in Column G
    • Column C reflects it is "HVAC"
    • Column B reflect State is KY
    • Lookup value in Column F should reflect "Miller Components"

    Thanks in advance for the help!

    Files

    • Sample.xlsx

      (21.31 kB, downloaded 106 times, last: )

    You're amazing thank you! I think it will cut about 50% of my time now. One tiny request that will make it save me 80% of the time, instead of returning "match" can it return the actual cell number it's in so I don't have to hunt for it?


    Thanks!

    Hi everyone -


    I'm working on a project for my youth group and I'm a bit stumped. Hoping someone can help here.


    I have 2 columns in the attached (look at the first tab).


    I want to do a vlookup to match if one cell contains another. Because vlookup right now only looks at exact match, I need partial matches. I'm guessing a Macro would work since it's similar to your Ouija board because it breaks up the words.


    So in this example I want to look at column B and then look at column E to find partial matches.


    Example: B501 has "John Bosco" so does e27. So I want a "vlookup" of some sort on column C 501 to say "John Bosco" or return "cell 327"


    As you can see the actual text of the two cells are different, but they have "John Bosco" in common.


    I know this can get complicated but as long as 1 word matches another I'm okay with it because it saves me 80% of the time, and I can check the rest. The key is for it to show all the matches, not just one.


    Vlookup has to match exactly and returns only 1 answer. I need it to match partially and return all the partial matches...


    Any help would be appreciated

    Hi Folks -


    I have a problem and I've been trying to figure out but have't been able to.


    I get a huge file from my partners (roughly 400MB) and I'm trying to find an automated way of splitting that file up based upon the field contents of one column i.e. the column that has the states.


    For example - I want to get every row from GA and split it out into excel, and then do that for every other state.


    Historically I used a CSV splitter then filtered the file, but that just takes way too much time.


    Any thoughts on how to do this?

    Hi Excel Gurus -


    ozgrid.com/forum/core/index.php?attachment/62920/


    Please see excel file above. I am trying to analyze data in 2 different sets for a marketing exercise.


    Columns A-F is the first step where I am trying to determine which mode of marketing works the best - Direct Media or Social. I wanted to ensure the scores did not happen by chance so ran a test and have the p values in Column D. Column F was a function that includes conditional formatting and if it is highlighted in red I do not use either mode because they are not significant. Am I interpreting this correctly? Is there another function I can use to do this automatically?


    Scores are on a scale of 1-99 where 1 is the best score and 99 is the worst.


    Columns I - W is the 2nd step where I am trying to determine which customer preferences I want to advertise with (Music, sports movies). I also ran a t test and got P values in column M-O. My conditional formatting and functions are in Column U-W. What I really want to know at the end of the day is what preference do these personas have? I'm not sure how to interpret this using the P values...can someone help with a function that will show this?

    Hi Excel Gurus -


    ozgrid.com/forum/core/index.php?attachment/62919/


    Please see excel file above. I am trying to analyze data in 2 different sets for a marketing exercise.


    Columns A-F is the first step where I am trying to determine which mode of marketing works the best - Direct Media or Social. I wanted to ensure the scores did not happen by chance so ran a test and have the p values in Column D. Column F was a function that includes conditional formatting and if it is highlighted in red I do not use either mode because they are not significant. Am I interpreting this correctly? Is there another function I can use to do this automatically?


    Scores are on a scale of 1-99 where 1 is the best score and 99 is the worst.


    Columns I - W is the 2nd step where I am trying to determine which customer preferences I want to advertise with (Music, sports movies). I also ran a t test and got P values in column M-O. My conditional formatting and functions are in Column U-W. What I really want to know at the end of the day is what preference do these personas have? I'm not sure how to interpret this using the P values...can someone help with a function that will show this?

    Re: Change conditional format script


    Quote from royUK;726754

    Your code will loop 10000 times, how can that be better than simply manually setting up the format?


    So are you implying it's easier to do 10000 rows manually vs a script?

    Is there a way to change the below script so that it does not highlight values that are "0"?


    Re: Find text in a string & copy to the end & paste in new column




    Ah, yes! Brilliant.


    Thanks for the help

    Hi all -


    I'm trying to do the following.


    Look in a test string in column A "(The blue jean company in Column N)" and find the word "column."


    Once the word "column" is found copy the word column and the remaining text into another cell.


    For example the output should be "Column N" in the new cell.


    Is something like this possible?

    Re: Adding progress bar to code


    Hi Smallman - quick question for you. This script works well on smaller data sets, but once I start trying to use this on sets of data ranging from 100-500K it goes through the process of filtering, but nothing remains afterwards. I'm confused as to why it works on smaller data but not larger data sets. Any ideas on what I can do?