# Search:

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

Page 1 of 2 1

1. ## Thread: Matching formula that is too hard for me!

by bran987
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. ## Thread: Matching formula that is too hard for me!

by bran987
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. ## Thread: Matching formula that is too hard for me!

by bran987
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. ## Thread: Matching formula that is too hard for me!

by bran987
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. ## Thread: Matching formula that is too hard for me!

by bran987
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. ## Thread: Find multiple cells that match and if they do concatenate the adjacent cells

by bran987
Replies
4
Views
219

### Re: Find multiple cells that match and if they do concatenate the adjacent cells

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

by bran987
Replies
4
Views
219

### 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. ## Thread: Find multiple cells that match and if they do concatenate the adjacent cells

by bran987
Replies
4
Views
219

### 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. ## Thread: If 2 columns match, and a date is on/between date range, return this value

by bran987
Replies
3
Views
155

### 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. ## Thread: If 2 columns match, and a date is on/between date range, return this value

by bran987
Replies
3
Views
155

### 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. ## Thread: How to make a cell result copy itself into subsequent cells "X" number of times

by bran987
Replies
1
Views
296

### 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. ## Thread: I would like to set conditions up for each zone and have excel assign, help?

by bran987
Replies
4
Views
364

### 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. ## Thread: I would like to set conditions up for each zone and have excel assign, help?

by bran987
Replies
4
Views
364

### 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. ## Thread: I would like to set conditions up for each zone and have excel assign, help?

by bran987
Replies
4
Views
364

### 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. ## Thread: What the heck is this weird blue symbol I've never seen before?

by bran987
Replies
1
Views
693

### 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. ## Thread: Conditional Formatting on a cell based on if it is a multiple of 7

by bran987
Replies
4
Views
7,203

### 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. ## Thread: Conditional Formatting on a cell based on if it is a multiple of 7

by bran987
Replies
4
Views
7,203

### 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. ## Thread: How to find items in a list by searching in a much larger list

by bran987
Replies
3
Views
334

### 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. ## Thread: How to find items in a list by searching in a much larger list

by bran987
Replies
3
Views
334

### 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. ## Thread: Kind of a strange IF statement question here...

by bran987
Replies
1
Views
468

### 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. ## Thread: Recording a macro to make relative keyboard movements from a starting point

by bran987
Replies
4
Views
537

### Re: Recording a macro to make relative keyboard movements from a starting point

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

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

by bran987
Replies
4
Views
537

### 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. ## Thread: Inserting 6 blank rows automatically between groups of data

by bran987
Replies
3
Views
375

### 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. ## Thread: Inserting 6 blank rows automatically between groups of data

by bran987
Replies
3
Views
375

### 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. ## Thread: having trouble with countif and 2 criteria (date AND nonblank?)

by bran987
Replies
9
Views
1,265

### 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