# Search:

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

Page 1 of 6 1

1. ## Thread: Complex Conditional Formatting

by mole999
Replies
1
Views
34

### Re: Complex Conditional Formatting

one way, assuming A and B cols above. In C2
=TRIM(A2&B2), drag down then conditional format C for duplicates, you could then eliminate any known duplicates. Then sort by supplier part number. I'm...
2. ## Thread: prevent table columns incrementing in formulas when you drag and fill a range

by mole999
Replies
2
Views
41

### Re: prevent table columns incrementing in formulas when you drag and fill a range

normally it wsould be restrained with a dollar sign \$ not sure how that works with tables
3. ## Thread: How to find degree value between two numbers

by mole999
Replies
3
Views
72

### Re: How to find degree value between two numbers

if it is a different question, then start a new thread

by mole999
Replies
5
Views
121

### Re: Delaying production

my only though would be to have a delay sheet built so changes there are then part of the model calculation always referenced. I don't understand the problem enough to say more
5. ## Thread: How to find degree value between two numbers

by mole999
Replies
3
Views
72

### Re: How to find degree value between two numbers

If I understand you, 1 full rotation is 360 degrees and you are looking at that in 9ths so 360 divided by 9 = 40 (i.e 9x40=360)

so 4 x 40 = 160 degrees

so the calculation is =(360/9)*4 = 160
6. ## Thread: Setting Command Button Properties When Workbook Opens

by mole999
Replies
1
Views
40

### Re: Setting Command Button Properties When Workbook Opens

you can add a button to a cell, then adjust your cells for size. Good if it dosen't muck up any other layout
7. ## Thread: Shift name based on timestamp

by mole999
Replies
18
Views
227

### Re: Shift name based on timestamp

just a matter of getting the right info from the right places :) The updated version should fit with your data

by mole999
Replies
18
Views
227

9. ## Thread: Shift name based on timestamp

by mole999
Replies
18
Views
227

### Re: Shift name based on timestamp

i was thinking more on the INDEX / MATCH formula but using this formula (adjusted to remove the date) > =A2-INT(A2) The date portion is a whole number so this just leaves the time value

Like...
10. ## Thread: Shift name based on timestamp

by mole999
Replies
18
Views
227

### Re: Shift name based on timestamp

just a thought but i think the date needs to be dropped i the formula otherwise they will never work :)
11. ## Thread: Shift name based on timestamp

by mole999
Replies
18
Views
227

### Re: Shift name based on timestamp

are the columns used the same as the formula above from Aryatect https://www.mrexcel.com/forum/images/statusicon/user-offline.png
12. ## Thread: IFERROR + VLOOKUP + ??? - Returning a value only for a given selection.

by mole999
Replies
5
Views
81

### Re: IFERROR + VLOOKUP + ??? - Returning a value only for a given selection.

what does your formula look like ?
13. ## Thread: Shift name based on timestamp

by mole999
Replies
18
Views
227

### Re: Shift name based on timestamp

if you in another cell use = ISNUMBER(your cell date time value) and it returns as true then it is time, false will say it is text
14. ## Thread: Shift name based on timestamp

by mole999
Replies
18
Views
227

### Re: Shift name based on timestamp

are you using actual time values? or text that looks like time?
15. ## Thread: Shift name based on timestamp

by mole999
Replies
18
Views
227

### Re: Shift name based on timestamp

are there any other overlays that need to be considered, otherwise its a case of extracting the right hand time value and comparing to less than 1
16. ## Thread: Infinite OLAP Refresh Loop

by mole999
Replies
1
Views
44

### Re: Infinite OLAP Refresh Loop

What code in the workbook relates to it?
17. ## Thread: Making a letter point to a specific cell or equation?

by mole999
Replies
10
Views
349

### Re: Making a letter point to a specific cell or equation?

The ZERO in MATCH should set for exact only

a little concerned about B\$3:B\$6 as that indicates to me only three rows are referenced

you might wrap with IFERROR(... formula ... ,"")
18. ## Thread: text format issue

by mole999
Replies
1
Views
64

### Re: text format issue

left and right alignment is the default to show whether text or number in the cell, you can format the column to align left or right, or convert your text numbers to numbers
19. ## Thread: Create Printer Error for testing purposes

by mole999
Replies
11
Views
571

### Re: Create Printer Error for testing purposes

can you force it to print direct rather than spool the job ?
20. ## Thread: Insert IFERROR( and ,"-") at the begining and end of formulas?

by mole999
Replies
4
Views
142

### Re: Insert IFERROR( and ,"-") at the begining and end of formulas?

If you select your formulas and run Marks code then you don't need to do anything else
21. ## Thread: Insert IFERROR( and ,"-") at the begining and end of formulas?

by mole999
Replies
4
Views
142

### Re: How can I insert IFERROR( and ,"-") at the begining and end of formulas?

something like ASAP utilities, if when you do it, you also add ' (i.e. =becomes '=IFERROR( as the first character then it will look like text until you have finished changing, then remove the leading...

by mole999
Replies
3
Views
65

### Re: hyper links to Chrome from Cell

Thanks, I might have to if I can't get the hyperlink to resolve,

by mole999
Replies
3
Views
65

### hyper links to Chrome from Cell

I have been using =HYPERLINK("http://gridreferencefinder.com/","GRF" ) for a while

work has suddenly started to use from the desktop

"C:\Program Files...
24. ## Thread: How to get data from Excel online

by mole999
Replies
1
Views
92

### Re: How to get data from Excel online

can you try accessing from another machine to replicate no access
25. ## Thread: Create Printer Error for testing purposes

by mole999
Replies
11
Views
571

### Re: Create Printer Error for testing purposes

physically turn it off, unplug the LAN, remove a colour cartridge, remove paper or add really thick paper to force a jam any of those should give you numerous errors
Results 1 to 25 of 150
Page 1 of 6 1