Search:

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

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    229

    [SOLVED] RG, Thank You !!! It is excellent !!! ...

    RG,

    Thank You !!! It is excellent !!! Thanks for the perseverance ;) YOU are the man. Very much appreciated.

    cvbs
  2. Replies
    5
    Views
    229

    [SOLVED] RG, Thanks for the reply. I see that your...

    RG,

    Thanks for the reply. I see that your formula does work w/o problem if there are no merged cells, however that is something that I can not change w/in this sheet. The results keep coming...
  3. Replies
    5
    Views
    229

    [SOLVED] week to date percent to goal

    Good Morning all,

    I am in need of creating a if then formula that will give me a w.t.d. % to goal.

    I have attached a sheet w/ data filled in through Wed. I want to be able show the % of...
  4. Replies
    21
    Views
    906

    Steve, RG Thanks... That works great... Sorry...

    Steve, RG

    Thanks... That works great... Sorry for all the confusion!! :D :clapping:
  5. Replies
    21
    Views
    906

    Gentleman, Column A & B are the numbers that...

    Gentleman,

    Column A & B are the numbers that are given to me. Column "C", what last years sales were is what I am trying to determine. Steve, to your question as to what does the percentage ,...
  6. Replies
    21
    Views
    906

    Steve, It is column C (last years) sales I am...

    Steve,
    It is column C (last years) sales I am trying to get by using the reported (this years) sales numbers (column A) and the percent of increase or decrease that is shown in column B ...

    ...
  7. Replies
    21
    Views
    906

    trying again

    Sorry ... I did not see the advance ... add attachment paper clip

    I do appreciate all your help and please accept my apology for the error in posting and having you do all that work.

    Thank...
  8. Replies
    21
    Views
    906

    Sorry for the follow up here. however I am still...

    Sorry for the follow up here. however I am still not getting the results to come out to the percent that was given to me as the amount of change. Here is a pic of the formulas I have tried.

    Thank...
  9. Replies
    21
    Views
    906

    Steve, Thank you for the input.... what...

    Steve,

    Thank you for the input.... what would you recommend for the formula to use ... even if it was less than 100% or even negative. Is there a formula you would use that could work for ALL...
  10. Replies
    21
    Views
    906

    Thank you again .... I appreciate the tip and...

    Thank you again .... I appreciate the tip and will use it going forward!:D
  11. Replies
    21
    Views
    906

    Thank you both for the replies. A follow...

    Thank you both for the replies.

    A follow up to the "round". .. Was the original formula incorrect to get last years sales or is round used because we are looking for an already given...
  12. Replies
    21
    Views
    906

    what am I missing?

    Hell all,

    Attached is an excerpt of sheet I am working on and this one piece is driving me nuts. I realize it is not a far drive, however I would rather not be making it!!!

    I have a given...
  13. Replies
    13
    Views
    1,035

    scheduler

    Steve,

    The first should have the blank template, before anyone manually fills in anything (and without any of the information you are asking about. You may want to highlight those cells that you...
  14. Replies
    13
    Views
    1,035

    Steve, Oversight on my part in setting up...

    Steve,

    Oversight on my part in setting up the examples where the calcs were eliminated in the manual sheet. They should be there as they are shown in the computer and blank.

    My logic to...
  15. Replies
    13
    Views
    1,035

    Steve, My Bad... rough morning. Lets try...

    Steve,

    My Bad... rough morning.
    Lets try this.
    Thanks
  16. Replies
    13
    Views
    1,035

    sdckapr: Thanks for helping .... I am...

    sdckapr:

    Thanks for helping ....
    I am attaching the workbook as requested ... please let me know if you have any other questions.
  17. Replies
    13
    Views
    1,035

    The "blank" sheet "Associate Schedule for the...

    The "blank" sheet "Associate Schedule for the week" is the same as rows 30 thru 36. I have put hours to work in for Monday thru Wed. Manager hours will not be counted in total hours available,...
  18. Replies
    13
    Views
    1,035

    Sdckapr.... My apologies .... the cells starting...

    Sdckapr.... My apologies .... the cells starting with B31 through u36 will be filled in depending on the number of associates employed at that time. the cells that show data currently are manually...
  19. Replies
    13
    Views
    1,035

    Employee Scheduler

    Hello all,

    I am trying to create a sheet that will auto schedule associates based on their ranking in productivity and their availability.

    (ie) .. if Associate #1 is ranked #1 in...
  20. Replies
    3
    Views
    807

    Add drive /run software from that drive?

    Hello all,

    I have been given an older Dell Optiplex tower that has a very small c: hard drive. I wanted to download and install "open Office" to use. Once I got the information from the web...
  21. Thread: solve for x ?

    by cvbs
    Replies
    7
    Views
    874

    solve for x ?

    helllo all

    I was thinking that excel had a function that could do this but for the life of me I could not remember it so if it is not available I need a formula that would solve for the following....
  22. Thread: vblookup problem

    by cvbs
    Replies
    3
    Views
    646

    many thanks

    Thank you sdckapr .... much appreciated for the quick reply... this will make my day much better :cool:
  23. Thread: vblookup problem

    by cvbs
    Replies
    3
    Views
    646

    vblookup problem

    Good Afternoon all,

    Attached is a sheet that has an excerpt from a list that I am using the vblookup formula with and it is returning the wrong answer 2 times within the column. Please review...
  24. Replies
    7
    Views
    1,107

    is the >= (and the rest of the formula) to be...

    is the >= (and the rest of the formula) to be added to the front part??? or are you saying Start with the =vlookup and forget the portion I already have????
  25. Replies
    7
    Views
    1,107

    RG, Sorry .... to many things going on at...

    RG,

    Sorry .... to many things going on at once ...
    =if(b2>90,vlookup(t3,tables!a4:b6,2)*A10 in the cell A10 is the running total number of hours that the person worked so far this year. ...
Results 1 to 25 of 166
Page 1 of 7 1 2 3 4