# Search:

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

Page 1 of 6 1

1. ## Thread: Change Coulour if gender is female

by James006
Replies
3
Views
95

### Re: Change Coulour if gender is female

Hi,

You do need to have each name in a cell ...

If your constraint is to keep your current sheet as it is ....

Then you can replicate on a new tab you current sheet ... and generate clean...
2. ## Thread: Template to be save in simple worksheet.

by James006
Replies
1
Views
79

### 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
106

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

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

by James006
Replies
2
Views
75

### 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
106

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

Hi,

You could test

= Edate(A1,12)

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

by James006
Replies
3
Views
104

### Re: Error In Expiry Date Formula

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

by James006
Replies
3
Views
130

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

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

by James006
Replies
2
Views
103

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

Hello,

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

by James006
Replies
2
Views
89

### Re: Formula using indirect

Hi,

Your explanation is a bit confusing ...

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

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

by James006
Replies
5
Views
142

### Re: conditional formatting with time format

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

by James006
Replies
6
Views
222

### 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
12. ## 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
13. ## Thread: conditional formatting with time format

by James006
Replies
5
Views
142

### Re: conditional formatting with time format

Have you tested the formula ...?
14. ## 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...
15. ## Thread: Excel Lookup and SUMIF to data on Different Workbook **Help Please**

by James006
Replies
6
Views
222

### 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
16. ## Thread: Use VBA to find which row on another worksheet contains a given value

by James006
Replies
1
Views
69

### 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
17. ## 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

19. ## Thread: formatting a date

by James006
Replies
18
Views
458

### Re: formatting a date

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

by James006
Replies
1
Views
44

### Re: multiple total time by number

Hello,

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

by James006
Replies
10
Views
118

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

You are welcome

by James006
Replies
10
Views
118

23. ## 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 ...
24. ## Thread: Reverse VLOOKUP....Is it possible??

by James006
Replies
10
Views
118

### 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 ... ???
25. ## Thread: countifs and also unique value

by James006
Replies
1
Views
69

### 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 ...?
Results 1 to 25 of 150
Page 1 of 6 1