Search:

Type: Posts; User: bran987; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    8
    Views
    189

    Re: Matching formula that is too hard for me!

    Thanks Dante! I had to add some $'s, change all the 3's in the formulas to 2's, and it ended up being -1 that worked on the ROW part instead of -2 (don't know why) but now it works!!!!!!!!
    Many...
  2. Replies
    8
    Views
    189

    Re: Matching formula that is too hard for me!

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  3. Replies
    8
    Views
    189

    Re: Matching formula that is too hard for me!

    Is there a thread that teaches me how to post an example so you can see it? I don't think I was being clear enough.
  4. Replies
    8
    Views
    189

    Re: Matching formula that is too hard for me!

    Hi DanteAmor,

    Thank you, I guess I wasn't totally clear. The phone numbers in columns A and G could be on totally different rows, so I'm trying to make it so it looks all the way up and down both...
  5. Replies
    8
    Views
    189

    Matching formula that is too hard for me!

    Hi everyone,

    Here are the things that are in each column.

    Column A - Phone Numbers
    Column B - Dates
    Column C - Dates
    Column D - Record ID's
    Column E - BLANK
    Column F - Dates
  6. Re: Find multiple cells that match and if they do concatenate the adjacent cells

    Eric I figured it out! Thanks so much man!!!
  7. Re: Find multiple cells that match and if they do concatenate the adjacent cells

    Wow Eric that worked perfectly all across Row 1! Except when I tried to CTRL+C the formula down into the next row it gives #N/A ?
  8. Find multiple cells that match and if they do concatenate the adjacent cells

    I have a spreadsheet with thousands of lines but I will just show one line because each row is independent.

    For the life of me I cannot figure out how to format the example in this message space,...
  9. Re: If 2 columns match, and a date is on/between date range, return this value

    Mark thanks so much!!!! It works perfectly. Have a great weekend!
  10. If 2 columns match, and a date is on/between date range, return this value

    This is so far above my head I am wondering if you guys can help me! Columns A-D are what I want to refer to. DOG/MOM/DAD all have the same date ranges by week. Each combination of DOG/MOM/DAD and...
  11. How to make a cell result copy itself into subsequent cells "X" number of times

    Say I have (cell A1) 10 salespeople and they each sell a (A2) $100/month membership, so I have (A3) $1,000 monthly revenue.

    (A4) is an assumption about how many months the average person will stay...
  12. Re: I would like to set conditions up for each zone and have excel assign, help?

    OK, *sigh* last try I guess. Bumping for suggestions on directions to go to get an answer to something like this? If nothing I guess I will just let this one die.
  13. Re: I would like to set conditions up for each zone and have excel assign, help?

    I guess this is bad news :( no responses.

    Any ideas as to how I could get close to an answer?
  14. I would like to set conditions up for each zone and have excel assign, help?

    Hi, I attached a screenshot of what I'm trying to accomplish:

    I'm trying to assign certain home addresses to zones that I set the conditions for.

    Check out the screenshot and maybe you can...
  15. What the heck is this weird blue symbol I've never seen before?

    I have a spreadsheet that I update and there is a weird blue symbol at the bottom left I have never seen before.

    When I click the line below the symbol it will disappear and then when I click the...
  16. Re: Conditional Formatting on a cell based on if it is a multiple of 7

    Thank you!

    I need to add one more condition, and that is:

    is there any way to set a conditional format for if the number contained in it is NOT evenly divisible by 7?
  17. Conditional Formatting on a cell based on if it is a multiple of 7

    In other words is there any way to shade a cell green only if the number contained in it is evenly divisible by 7?

    Thanks
  18. Re: How to find items in a list by searching in a much larger list

    I need to know which line the item is on the 800,000 item list. I already know that the items in my list do in fact exist on the much longer list.

    So if I could do something that put a 1 in a new...
  19. How to find items in a list by searching in a much larger list

    In other words:

    A1 = 1
    A2 = 5
    A3 = 11
    A4 = 84
    A5 = 100

    For example, that would be the list of numbers I need to find.
  20. Kind of a strange IF statement question here...

    OK I basically have 3 cells to deal with, let's call them A1, A2, and A3

    A1: Can be any number 1 or greater (represents a number of days)
    A2: Will be a date
    A3: Will be a date OR blank

    So I...
  21. Re: Recording a macro to make relative keyboard movements from a starting point

    I'm sorry... the criteria is "0"

    Does that help?
  22. Recording a macro to make relative keyboard movements from a starting point

    I'm trying to record a macro that will do what I'm actually doing with my keyboard over and over again... so try to imagine this is what I'm doing on my keyboard, such as:

    ---------

    Start...
  23. Re: Inserting 6 blank rows automatically between groups of data

    That is incredible! How did you do that so fast? Thank you! I only wish I knew where to begin learning things like that.
  24. Inserting 6 blank rows automatically between groups of data

    Hello everyone

    I'm wondering how to automatically insert blank rows based on this:

    I have company names, about 50. There is about 2,000 lines of data after it's all sorted

    So it will be...
  25. Re: having trouble with countif and 2 criteria (date AND nonblank?)

    Wow you are completely correct. I apologize for getting that backwards.

    Your formula does exactly what I need. THANK YOU!
Results 1 to 25 of 45
Page 1 of 2 1 2