# Search:

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

1. ## Thread: Cash Flow Projection Probabilty

by sajohnson05
Replies
1
Views
165

### Re: Cash Flow Projection Probabilty

Can anyone help with this?
2. ## Thread: Cash Flow Projection Probabilty

by sajohnson05
Replies
1
Views
165

### Cash Flow Projection Probabilty

I have a years worth of Cash Flow projections for Capital projects that are based on the start and end dates of construction. Each month i have been tracking the actual's compared to what the...
3. ## Thread: Scatter Plot question

by sajohnson05
Replies
0
Views
136

### Scatter Plot question

I am creating a scatter plot in excel with over 180 points. With that many points I am not able to use data labels to show which point is for what item. Is there a way that I can change the y...

by sajohnson05
Replies
1
Views
111

### Changing years

Currently in a column I have years, ie. 11,20,45. I am wanting to create a formula that when say 2017 changes to 2018 the years increases by 1, ie 11 to 12, 20 to 21 and 45 to 46.

Is there a way...

by sajohnson05
Replies
4
Views
113

### Re: Find text

Is there a way it will work if a certain text is in sheet 1 but the exact is not in sheet 2. Say in sheet 1 it say ICU but in sheet two it may say ICU/CCU.

by sajohnson05
Replies
4
Views
113

### Find text

I am trying to find text from worksheet 2 and put the risk factor into worksheet 1. Any help would be great, not sure the best formula to use.

1

<tbody>
Area Served
Factor

*******
7. ## Thread: VLookup between two sheets

by sajohnson05
Replies
1
Views
136

### VLookup between two sheets

I have attached to screen shots as you see below. What I am trying to do is get what is in column B row 6 into the model(second screen shot) into the corresponding location based on what is selected...

by sajohnson05
Replies
4
Views
158

### Re: Sumif

Below are the fields I am trying to sum. I am trying to sum 0-299 and 300-399

<tbody>
0

PROD SAL & WAG
\$0.00

by sajohnson05
Replies
4
Views
158

### Sumif

I am trying to use the formula "sumif" and i have a range from say 0-299, 300-399, 400-499, 622-699. These are account numbers. Currently i get a 0 in the field when i use the groups as the...
10. ## Thread: Need Help Database

by sajohnson05
Replies
1
Views
137

### Need Help Database

Not sure where to start on the help I am looking for but here goes.

I have a workbook with about 50 worksheets. This is for a budget that I manage. In each worksheet across the top is each month...
11. ## Thread: Help with Formula

by sajohnson05
Replies
5
Views
178

### Re: Help with Formula

Thank you. That was exactly what i needed.
12. ## Thread: Help with Formula

by sajohnson05
Replies
5
Views
178

### Re: Help with Formula

Thank you. The only thing that I failed to mention is that I will have 53 different sites and would need a be able to sum and count by that site
13. ## Thread: Help with Formula

by sajohnson05
Replies
5
Views
178

### Help with Formula

I have two tabs with a list of different sites. I am needing to get cost amounts based on the type of work and also a count of line items per system. Below i have shown what is on one tab and the...
14. ## Thread: Need help with formula

by sajohnson05
Replies
3
Views
164

### Re: Need help with formula

Thank you that was perfect.
15. ## Thread: Need help with formula

by sajohnson05
Replies
3
Views
164

### Need help with formula

I can not figure out my formula that I need. Below is what i am trying to do.

I have an invoice for \$155K and need to split it between 162 locations based on square footage. I am trying to split...
16. ## Thread: Insert line over Multiple sheet

by sajohnson05
Replies
1
Views
164

### Re: Insert line over Multiple sheet

bump. Any help would be great
17. ## Thread: Insert line over Multiple sheet

by sajohnson05
Replies
1
Views
164

### Insert line over Multiple sheet

This is my first post as I am just now learning how to use macros. What I am looking to do is find a date ie 8/1/13 on different sheets in my workbook and these are on different lines. Once I find...
Results 1 to 17 of 17