# Search:

Type: Posts; User: Scott T; Keyword(s):

Page 1 of 6 1

## Search: Search took 0.10 seconds.

by Scott T
Replies
2
Views
102

### Re: Pulling data

Is this what you want?

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
2. ## Thread: IFERROR Formula help

by Scott T
Replies
5
Views
99

### Re: IFERROR Formula help

IFERROR(value, value_if_error)
If value does NOT return an error then the result of value is displayed.
If value does return an error then value_if_error is returned.

for example...
3. ## Thread: IFERROR Formula help

by Scott T
Replies
5
Views
99

### Re: IFERROR Formula help

Your last iferror does not have a value-if-error that is the value to return if there is an error
4. ## Thread: Index Match Return Second Column, not first

by Scott T
Replies
3
Views
97

### Re: Index Match Return Second Column, not first

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
5. ## Thread: Drop Down List Based On A Cell Value

by Scott T
Replies
3
Views
81

### Re: Drop Down List Based On A Cell Value

In Data validation
pick list
Where I1:I2 is the list for over 10K and H1:H2 is the list for under.
You did not say what should happen if it is equal to 10K. So if needed change from > to >=.

in...
6. ## Thread: SUMPRODUCT / INDEX MATCH Question

by Scott T
Replies
1
Views
92

### Re: SUMPRODUCT / INDEX MATCH Question

Since this formula does not reference the states on sheet 1 you will need make sure it refrences the correct cities on sheet 2. If they are listed in the same order you can copy across.
...

by Scott T
Replies
4
Views
102

Try

<TBODY>

A

B

C
8. ## Thread: Calculating elapsed hours with weekends.

by Scott T
Replies
9
Views
257

### Re: Calculating elapsed hours with weekends.

RED= start date
Blue= end date
F2:F7 = holiday list

...
9. ## Thread: IF and MID and ELSE

by Scott T
Replies
5
Views
156

### Re: IF and MID and ELSE

You can use OR

=IF(OR(MID(B18,2,8)="01330701",MID(B18,2,8)="01732401",next sequences goes here,.. ),"11-13 hours","")
10. ## Thread: Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

by Scott T
Replies
5
Views
103

### Re: Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

In Acrobat under the File menu select "Export to" then "Spreadsheet" then "Microsoft EXCEL workbook"
11. ## Thread: Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

by Scott T
Replies
5
Views
103

### Re: Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

If you have Acrobat then then you can export it as a spread sheet.
12. ## Thread: Fill blanks macro

by Scott T
Replies
3
Views
139

### Re: Fill blanks macro

Select the area and then hit F5 to bring up the go to box.
Select Special...
Then Select Blanks
Type what you want in the cells then press CONTROL and ENTER
13. ## Thread: Calculating elapsed hours with weekends.

by Scott T
Replies
9
Views
257

### Re: Calculating elapsed hours with weekends.

Forgot to account for if it is a work day but before 6AM this should cover that.

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
14. ## Thread: Calculating elapsed hours with weekends.

by Scott T
Replies
9
Views
257

### Re: Calculating elapsed hours with weekends.

Try
<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
15. ## Thread: Match function in reverse direction

by Scott T
Replies
19
Views
746

### Re: Match function in reverse direction

If match is working in reverse then the line with here would be 1 and the row above would be 2...
So is it just the direction of the lookup that is reversed are both the direction and the row...
16. ## Thread: Help conditional formatting not working

by Scott T
Replies
9
Views
204

### Re: Help conditional formatting not working

If you want code to run automatically you can use a change event.
This should be put in the sheet module.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target,...
17. ## Thread: Help conditional formatting not working

by Scott T
Replies
9
Views
204

### Re: Help conditional formatting not working

If you are willing to use VBA then this should work

Sub checkdups()
Dim rng As Range
Set rng = Range("A2:A310")
For Each cell In rng
For Each mcell In rng
If cell = mcell And...
18. ## Thread: How do i calculate margin cost

by Scott T
Replies
1
Views
115

### Re: How do i calculate margin cost

Gross profit margin = (Net sales-Cost of goods sold)/ net sales

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse:...
19. ## Thread: AutoFit Row and add 5 to row height via VBA

by Scott T
Replies
8
Views
185

### Re: AutoFit Row and add 5 to row height via VBA

This will auto fit row 7 then add 5 to the height. change to fit what you need.

Rows(7).AutoFit
myheight = Rows(7).RowHeight
Rows(7).RowHeight = myheight + 5

End Sub
20. ## Thread: Way to use type ahead in a validation list?

by Scott T
Replies
2
Views
105

### Re: Way to use type ahead in a validation list?

This video show how to type in part of a name and have the list update. It used the new dynamic arrays

https://youtu.be/Z-h2UER3b_0

If you do not have the new dynamic arrays then you will can...
21. ## Thread: Lookup and Populate cell

by Scott T
Replies
5
Views
159

### Re: Lookup and Populate cell

I assume you want to use the current year for the number of days in Feb since there are sometimes leap years.

22. ## Thread: User Name Based Drop Down

by Scott T
Replies
3
Views
168

### Re: User Name Based Drop Down

Sounds like you want depended data validation.

see video for details

https://youtu.be/So51kA_LVK8

by Scott T
Replies
3
Views
167

### Re: Constantly Changing Password Macro

If I understand what you want correctly you could have a input box where the user types in the password.

something like

Sub prosheet()
Dim pw As String
24. ## Thread: Trying to test HTML Maker

by Scott T
Replies
3
Views
1,564

### Re: Trying to test HTML Maker

You should have the need code in your clipboard so when you come the forum you can start/reply to a thread and past the code.