# Search:

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

Page 1 of 7 1

1. ## Thread: week to date percent to goal

by cvbs
Replies
5
Views
186

### [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. ## Thread: week to date percent to goal

by cvbs
Replies
5
Views
186

### [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. ## Thread: week to date percent to goal

by cvbs
Replies
5
Views
186

### [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. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

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

Steve, RG

Thanks... That works great... Sorry for all the confusion!! :D :clapping:
5. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

### 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. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

### 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. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

### 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. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

### 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. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

### 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. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

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

Thank you again .... I appreciate the tip and will use it going forward!:D
11. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

### 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. ## Thread: what am I missing?

by cvbs
Replies
21
Views
733

### 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. ## Thread: Employee Scheduler

by cvbs
Replies
13
Views
898

### 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. ## Thread: Employee Scheduler

by cvbs
Replies
13
Views
898

### 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. ## Thread: Employee Scheduler

by cvbs
Replies
13
Views
898

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

Steve,

My Bad... rough morning.
Lets try this.
Thanks
16. ## Thread: Employee Scheduler

by cvbs
Replies
13
Views
898

### 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. ## Thread: Employee Scheduler

by cvbs
Replies
13
Views
898

### 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. ## Thread: Employee Scheduler

by cvbs
Replies
13
Views
898

### 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. ## Thread: Employee Scheduler

by cvbs
Replies
13
Views
898

### 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. ## Thread: Add drive /run software from that drive?

by cvbs
Replies
3
Views
769

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

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

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

### 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. ## Thread: displaying max number

by cvbs
Replies
7
Views
1,060

### 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. ## Thread: displaying max number

by cvbs
Replies
7
Views
1,060

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