# Search:

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

Page 1 of 6 1

1. ## Thread: Art work pricing formula

by Taul
Replies
2
Views
192

### Re: Art work pricing formula

Hi,
If sizes are listed in column A (A2 downward) and the price is listed in column B (B2 downward)
In cell D2 you can type the size needed.
Cell E2 would contain the flowing formula

...
2. ## Thread: Clearing Excel AutoFilter using VBA

by Taul
Replies
5
Views
293

### Re: Clearing Excel AutoFilter using VBA

Hi,
You can check the state of the Autofilter and decide what to do

With ActiveSheet
If .AutoFilterMode = True And .FilterMode = True Then
MsgBox "They are visible...
3. ## Thread: Help with data validation question

by Taul
Replies
1
Views
212

### Re: Help with data validation question

Hi,
If I have understood correctly, you need "Hide Used items in a drop down list"
There is a full explanation here along with a downloadable file to play with:-
...
4. ## Thread: How to mix Subtotal & Countif

by Taul
Replies
5
Views
159

### Re: How to mix Subtotal & Countif

Your file has hidden columns (C, D & E) but no hidden rows.
Therefore you should use the formula posted by sandy666
5. ## Thread: How to mix Subtotal & Countif

by Taul
Replies
5
Views
159

### Re: How to mix Subtotal & Countif

From the help file:-
1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded.
6. ## Thread: Using Indirect to keep cell reference from changing

by Taul
Replies
2
Views
155

### Re: Using Indirect to keep cell reference from changing

Hi Try this
Cell A2 = \$A\$1:\$AB\$500

Change the formula to

=IFERROR(VLOOKUP(\$T\$1-2,INDIRECT("Job!"&\$A\$2),3,FALSE),"--")

by Taul
Replies
4
Views
247

### Re: Dynamic Shapes

Hi,
Take a look at Conditional Format (on the Home ribbon)
Conditional Format - Icon Sets.
use the 4 or 5 coloured arrow sets
This provides a green arrow up, red arrow down and a yellow arrow...
8. ## Thread: Formatting cell size

by Taul
Replies
1
Views
140

### Re: Formatting cell size

I would suggest you do not merge the cells.
Put the data in the column “A” cell only, then select the cells “A to D” and then:-
Click on “Wrap Text”
Format – Format Cells – Alignment – Horizontal...
9. ## Thread: Working out an individuals age in Years, Months, Days if they were born before 1 Jan 1900

by Taul
Replies
4
Views
200

### Re: Working out an individuals age in Years, Months, Days if they were born before 1 Jan 1900

I haven't looked at the downloadable file for a few years but I managed to find an older workbook where I used the formulas, extract blow.

A2 = Name
B2 = DoB
C2 = Date died

formula in col D2...
10. ## Thread: Working out an individuals age in Years, Months, Days if they were born before 1 Jan 1900

by Taul
Replies
4
Views
200

### Re: Working out an individuals age in Years, Months, Days if they were born before 1 Jan 1900

Hi,
I would suggest looking here, lots of interesting stuff on pre-1900 dates and a workaround in a downloadable workbook as an example
http://www.exceluser.com/formulas/earlydates.htm

by Taul
Replies
4
Views
253

### Re: datedif()

I think that post was dated 1st April
12. ## Thread: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

by Taul
Replies
9
Views
612

### Re: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

Hi,
Just for the sake of completeness and in case anyone else is looking for a similar solution. I have found an alternative approach. So I thought I would share it.

Basic solution is here...
13. ## Thread: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

by Taul
Replies
9
Views
612

### Re: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

Hi Oldbrewer,
Just to explain a little more, I’m trying to create a generic formula to handle working periods of time that would be better than the existing formula that I mentioned in the original...
14. ## Thread: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

by Taul
Replies
9
Views
612

### Re: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

Thank you Oldbrewer,
I did not really grasp the full solution you offered, I think my brain must have been worn out as I spent the last few days looking for a work around to the problem. You are...
15. ## Thread: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

by Taul
Replies
9
Views
612

### Re: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

Hi Oldbrewer,
Thank you for the reply, it looks like you have spent some time on this one.
Your formula accounts for different hours on a Friday but it does not account for lunch breaks or...
16. ## Thread: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

by Taul
Replies
9
Views
612

### Working hours between two date/times excluding Lunch and weekends, diff time on Friday

Hi,
I need some assistance with calculating working hours between two date/time cells. The working hours are 8:30 to 17:30 and the lunch break is 12:30 to 1:45

The date/time value could be...
17. ## Thread: File (7MB) takes 25s to save each time (?)

by Taul
Replies
16
Views
687

### Re: File (7MB) takes 25s to save each time (?)

Hi
I suspect there are hidden objects, usually command buttons that are being duplicated. Try this,
On the Home tab, go to Find and in the drop down list, select “Selection Pane”
This will list...
18. ## Thread: Alternative Formula for Nested If/and Function

by Taul
Replies
2
Views
144

### Re: Alternative Formula for Nested If/and Function

Hi,
Welcome to the forum.
Am I correct in assuming the outcome “Non-Corp Gold” is defined by the last 11 characters of the text in cell A1. This appears to be true based on the two examples you...
19. ## Thread: SLA Calulation excluding weekends

by Taul
Replies
5
Views
241

### Re: SLA Calulation excluding weekends

Hi
Yeah, my bad, the correct format is [h]:mm:ss

I notice you are using cell references rather than the Named Range that I suggested, presumably Availability!G47 is the cell containing the End...
20. ## Thread: SLA Calulation excluding weekends

by Taul
Replies
5
Views
241

### Re: SLA Calulation excluding weekends

Hi,
Firstly I would make a few assumptions as I was a little confused about the meaning of “attended”
We are comparing date times between Reported Date (Column “A”) and Call Out Response Date...
21. ## Thread: Help to create the proper schedule planner

by Taul
Replies
4
Views
330

### Re: Help to create the proper schedule planner

You're welcome.

If you want to post a sample of the excel file, you can use the HTML Maker shown the the thread below:-...
22. ## Thread: Help to create the proper schedule planner

by Taul
Replies
4
Views
330

### Re: Help to create the proper schedule planner

Hi,
One way is to use conditional formatting.
select cell D5 and apply conditional format, use the formula

<tbody>
=AND(D\$4>=\$C\$5,D\$4<=\$C\$6)

</tbody>

by Taul
Replies
14
Views
651

Hi,
After doing a little searching I came across an interesting post over at Ozgrid....

by Taul
Replies
14
Views
651

Hi,
Yes, I understand what you are trying to achieve and although we can get the tab back colour and put it into the ToC page via the code, we cannot get the tab font colour.
The best I can offer,...

by Taul
Replies
14
Views
651