# Search:

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

Page 1 of 6 1

## Search: Search took 0.07 seconds.

by zone709
Replies
4
Views
95

### Re: =sumif?

i got it eric thanks had to take out <

by zone709
Replies
4
Views
95

### Re: =sumif?

this is giving me all numbers. Looking to pull in all numbers that dont have the name equal rental in column D

by zone709
Replies
4
Views
95

### =sumif?

Add numbers up in column C that don't have the word (equp rental) name in column D. I was thinking =sumif <> equp rental, DD

I don't know
4. ## Thread: Formula help return number once only

by zone709
Replies
7
Views
236

### Re: Formula help return number once only

I did but the first name keeps pulling in the same name all the way down. I am leaving now i will check tomorrow. Thanks fro the reply.
5. ## Thread: Formula help return number once only

by zone709
Replies
7
Views
236

### Re: Formula help return number once only

Hey guys thanks for the reply. I just ran into something simliar and tried these formulas but didnt work.

In column B I have names that are the same but only want to return one name at a time like...
6. ## Thread: Formula help return number once only

by zone709
Replies
7
Views
236

### Re: Formula help return number once only

works great thanks for the help
7. ## Thread: Formula help return number once only

by zone709
Replies
7
Views
236

### Formula help return number once only

Hi,

Trying to do a formula to return number only once.

Example
Staring from row A2

I have going down an more.
A
10

by zone709
Replies
6
Views
266

Thanks guys
9. ## Thread: How to find duplicate numbers in a column

by zone709
Replies
6
Views
266

### How to find duplicate numbers in a column

HI trying to find the fastest way i can find duplicate numbers in column BQ. Meaning i have like 500 lines of numbers in BQ. Just want to find out whats duplicting. So if 6 and 6 are in column BQ i...
10. ## Thread: If formula not working right

by zone709
Replies
12
Views
605

### Re: If formula not working right

Hi ok i just tried scotts maybe ill use this thanks. Also the "" works now thanks for the reply
11. ## Thread: If formula not working right

by zone709
Replies
12
Views
605

### Re: If formula not working right

HI I came back here cause I cant get rid of this return "

If nothing returns right instead of returning blank cell like I think its suppose to. It returns " Anyone know why this returns "
...
12. ## Thread: Need to return dates not sure either formula or macro

by zone709
Replies
4
Views
230

### Re: Need to return dates not sure either formula or macro

This is it. Why didnt i think of this this way. Thanks for the help. I really didnt think it out to much. :)
13. ## Thread: Need to return dates not sure either formula or macro

by zone709
Replies
4
Views
230

### Need to return dates not sure either formula or macro

I need to return dates as i have to look back on stuff. I need to return every Monday to Sunday Dates on excel sheet doesnt matter where from 2018 and on.

Example
Starting January 2018 i need to...

by zone709
Replies
4
Views
216

### Re: Formula add 27 everyday in cell

Thanks for the reply and the help

by zone709
Replies
4
Views
216

### Formula add 27 everyday in cell

Hi looking to use a formula that started on 11/24/2018
adding 27 everyday to cell and going forward. So right now it would probably look like 1019 since then. Then tomorrow when i open sheet should...
16. ## Thread: trying to drag 2 cells down at a time returning same cell value and on ?

by zone709
Replies
6
Views
212

### Re: trying to drag 2 cells down at a time returning same cell value and on ?

Figured it out

=IF(INDIRECT("Data!D" & INT((ROW()-3)/2)+8)=0,"",INDIRECT("Data!D" & INT((ROW()-3)/2)+8))

This pulls in on every 2 cells what I needed thanks guys
17. ## Thread: trying to drag 2 cells down at a time returning same cell value and on ?

by zone709
Replies
6
Views
212

### Re: trying to drag 2 cells down at a time returning same cell value and on ?

Ok ill try this thanks for the reply
18. ## Thread: trying to drag 2 cells down at a time returning same cell value and on ?

by zone709
Replies
6
Views
212

### Re: trying to drag 2 cells down at a time returning same cell value and on ?

Not really i am just trying to use to pull in the from the sheet but 2 cells at a time returning same cell 2 at a time. I know there is away to do it but little complicated for me. I have to drag it...
19. ## Thread: trying to drag 2 cells down at a time returning same cell value and on ?

by zone709
Replies
6
Views
212

### trying to drag 2 cells down at a time returning same cell value and on ?

I hve ts in cell B3 and B4.I need to pull the return in like this a I drag down. If I rag this down holding both cells it will go to =data!d10 =data!d10. I need it to go to =data!d9 =data!d9 and so...
20. ## Thread: Formula Help to return every Friday's date and after?

by zone709
Replies
8
Views
339

### Re: Formula Help to return every Friday's date and after?

Ok great thanks for the reply. I thought i did it right but i think i get it.
21. ## Thread: Formula Help to return every Friday's date and after?

by zone709
Replies
8
Views
339

### Re: Formula Help to return every Friday's date and after?

Hi i also needed it for Sunday. So i did thi will this work?

=TODAY()+9-WEEKDAY(TODAY()+1)
22. ## Thread: If formula not working right

by zone709
Replies
12
Views
605

### Re: If formula not working right

Wait the Trim formula is working now thanks. I figured it out thanks for all the help again
23. ## Thread: If formula not working right

by zone709
Replies
12
Views
605

### Re: If formula not working right

Im not sure. In Cell R formula is pulling in the name. Can that be it?
24. ## Thread: If formula not working right

by zone709
Replies
12
Views
605

### If formula not working right

Hi trying to get this to work, but returns nothing blank. What am I missing? If name is present return that number ,1 ,2 or ,3

=IF(R2="Yard",1,IF(R2="Yards",2,IF(R2="Tunnel",3,"")))
25. ## Thread: Formula help to return first name space last name from 2 cells

by zone709
Replies
2
Views
146

### Re: Formula help to return first name space last name from 2 cells

Terriffic works great thanks for the help
Results 1 to 25 of 150
Page 1 of 6 1