Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Thread: =sumif?

    by zone709
    Replies
    4
    Views
    95

    Re: =sumif?

    i got it eric thanks had to take out <
  2. Thread: =sumif?

    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
  3. Thread: =sumif?

    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. 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. 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. Replies
    7
    Views
    236

    Re: Formula help return number once only

    works great thanks for the help
  7. 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
  8. Replies
    6
    Views
    266

    Re: ? How to find duplicate numbers in a column

    Thanks guys
  9. 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. 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. 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. 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. 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...
  14. Replies
    4
    Views
    216

    Re: Formula add 27 everyday in cell

    Thanks for the reply and the help
  15. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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 2 3 4