# Search:

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

Page 1 of 6 1

1. ## Thread: Template to be save in simple worksheet.

by James006
Replies
1
Views
67

### Re: Template to be save in simple worksheet.

Hello,

If I understand your request ... you need to Copy Paste Values which can be performed as file is saved as new file ...

Hope this will help

by James006
Replies
6
Views
78

### Re: adding date using date() function

For sure ... problem is solved ...:smile:
3. ## Thread: opying into cells if particular criteria is met

by James006
Replies
2
Views
71

### Re: opying into cells if particular criteria is met

Hello,

You should take a look at AutoFilter ...

Hope this will help

by James006
Replies
6
Views
78

### Re: adding date using date() function

Hi,

You could test

= Edate(A1,12)

Hope this will help
5. ## Thread: Error In Expiry Date Formula

by James006
Replies
3
Views
98

### Re: Error In Expiry Date Formula

You are welcome :smile:
6. ## Thread: Responsive list / pivot - No VBA

by James006
Replies
3
Views
122

### Re: Responsive list / pivot - No VBA

You are welcome ...:smile:
7. ## Thread: rank.eq with multiple if conditions

by James006
Replies
2
Views
100

### Re: rank.eq with multiple if conditions

Hello,

Have you tried an array formula with all your conditions ... ?
8. ## Thread: Formula using indirect

by James006
Replies
2
Views
88

### Re: Formula using indirect

Hi,

Your explanation is a bit confusing ...

May be you should try =Offset(yourcell,-1,0) ...

Hope this will help
9. ## Thread: conditional formatting with time format

by James006
Replies
5
Views
141

### Re: conditional formatting with time format

You are welcome
10. ## Thread: Excel Lookup and SUMIF to data on Different Workbook **Help Please**

by James006
Replies
6
Views
206

### Re: Excel Lookup and SUMIF to data on Different Workbook **Help Please**

With so many external links, you should probably take a look at Power Query

https://www.howtoexcel.org/power-query/the-complete-guide-to-power-query/

Hope this will help
11. ## Thread: Top 10% Salaries

by James006
Replies
6
Views
129

### Re: Top 10% Salaries

For sure you have noticed Large() function deals with the ranking of amounts and not with the percentages ...

You could test

=A2>=Percentile(yourRange,0.9)

Hope this will help
12. ## Thread: conditional formatting with time format

by James006
Replies
5
Views
141

### Re: conditional formatting with time format

Have you tested the formula ...?
13. ## Thread: Top 10% Salaries

by James006
Replies
6
Views
129

### Re: Top 10% Salaries

With the very ' skinny ' description you gave of your data structure ... quite tough to come up with a proposal ...

Probably a helper column based on your Salary column would produce your expected...
14. ## Thread: Excel Lookup and SUMIF to data on Different Workbook **Help Please**

by James006
Replies
6
Views
206

### Re: Excel Lookup and SUMIF to data on Different Workbook **Help Please**

Hi,

Working with closed files does change several things ...

see : https://exceloffthegrid.com/getting-values-from-a-closed-excel-workbook/

Hope this will help
15. ## Thread: Use VBA to find which row on another worksheet contains a given value

by James006
Replies
1
Views
68

### Re: Use VBA to find which row on another worksheet contains a given value

Hi,

With the Find method ... :wink:

see following link for explanation :

https://www.ozgrid.com/VBA/find-method.htm

Hope this will help
16. ## Thread: Top 10% Salaries

by James006
Replies
6
Views
129

### Re: Top 10% Salaries

Hi,

AutoFilter offers the possibility of extract what you are looking for ...

Hope this will help

by James006
Replies
6
Views
101

18. ## Thread: formatting a date

by James006
Replies
18
Views
452

### Re: formatting a date

You are welcome ...:smile:
19. ## Thread: multiple total time by number

by James006
Replies
1
Views
41

### Re: multiple total time by number

Hello,

Have you tried to format your Total Hours with [hh]:mm format ?
20. ## Thread: Reverse VLOOKUP....Is it possible??

by James006
Replies
10
Views
114

### Re: Reverse VLOOKUP....Is it possible??

You are welcome

by James006
Replies
10
Views
114

22. ## Thread: Count number of unique codes in a column

by James006
Replies
6
Views
101

### Re: Count number of unique codes in a column

Hi,

Apparently 70'000 records is too much for Excel to swallow ...

Would suggest to Insert a Pivot Table ... much safer ...
23. ## Thread: Reverse VLOOKUP....Is it possible??

by James006
Replies
10
Views
114

### Re: Reverse VLOOKUP....Is it possible??

Can you post the formula you are using ...

Why are you pointing to " Reverse VLOOKUP " as the solution to your question ... ???
24. ## Thread: countifs and also unique value

by James006
Replies
1
Views
68

### Re: countifs and also unique value

Hello,

Unfortunately ... your explanation is very confusing ...

What is in Column C, in Column D, in Column E, in Column Q, in Column V ...?
25. ## Thread: can excel help pick out top choice?

by James006
Replies
1
Views
36

### Re: can excel help pick out top choice?

Hi,

So what is the result you are looking for ...?
Results 1 to 25 of 150
Page 1 of 6 1