# Search:

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

Page 1 of 6 1

1. ## Thread: Countif or Vlookup or something else?

by nparsons75
Replies
10
Views
216

### Re: Countif or Vlookup or something else?

Hi,

This is the formula I am using...

=SUMPRODUCT(--("Desc1"=\$A\$17:\$A\$5000),--(""<>E\$17:E\$5000))

A is the value for the lookup, E is the column I want to count. Physically in E after...
2. ## Thread: Countif or Vlookup or something else?

by nparsons75
Replies
10
Views
216

### Re: Countif or Vlookup or something else?

Hi, The results are not showing as expected, i do have filters on the table, could this be the issue?
3. ## Thread: Countif or Vlookup or something else?

by nparsons75
Replies
10
Views
216

### Re: Countif or Vlookup or something else?

Hi, for some reason the result is giving me the count of non blanks in Col A.

IGNORE....

This was because I selected a field for the value as opposed to typing the value in quotes within the...
4. ## Thread: Countif or Vlookup or something else?

by nparsons75
Replies
10
Views
216

### Re: Countif or Vlookup or something else?

Apologies, its hard to explain, let me try again.

So, I have one main table, (Table 2). In Col A of this table is a long list of different part descriptions. One of which is "Desc1". In Cell,...
5. ## Thread: Countif or Vlookup or something else?

by nparsons75
Replies
10
Views
216

### Countif or Vlookup or something else?

Hi, I have a table which contains data in Col A (Part Description). I have a cell which I need to look at Col A, if Col A = Desc1, look in Column N and count the non blanks.

Is there a function...
6. ## Thread: Locked Cells / Range Edits / Cell Selection

by nparsons75
Replies
2
Views
177

### Re: Locked Cells / Range Edits / Cell Selection

Hi, thanks for your time and reply. I have already checked that and they are ticked. Both are ticked, select locked and unlocked cells.
7. ## Thread: Locked Cells / Range Edits / Cell Selection

by nparsons75
Replies
2
Views
177

### Locked Cells / Range Edits / Cell Selection

Hi, I have set up various ranges only to be edited by authorised people by adding them to the security within the permissions area. However, When I now click on one of these areas to change and press...
8. ## Thread: Allow edit ranges, cursor problem

by nparsons75
Replies
0
Views
176

### Allow edit ranges, cursor problem

Hi, I have set various ranges to be protected so only specific users can edit the ranges. Should they not be set to allow, they will be requested to enter a password. This all appears fine, however...
9. ## Thread: VBA Code Error

by nparsons75
Replies
1
Views
108

### VBA Code Error

Hi,

I have a macro running which includes this information below. When the macro runs I get this error:

Run time error '1004'
The pivot table field name is not valid. To create a pivot table...

by nparsons75
Replies
1
Views
223

### Erratic cursor behavior after applying edit range passwords

HI,

I have set numerous range passwords to enable certain people to edit. for soe strange reason, once activated the cursor will not move around the spreadsheet properly, its all over the place?...
11. ## Thread: allow edit range

by nparsons75
Replies
2
Views
340

### allow edit range

Hi, I have allowed edit ranges for a number of different people. Once setup I have then locked the cells and protected the sheet.

When I try and cursor around now, the cursor is erratic taking me...

by nparsons75
Replies
5
Views
124

### Re: Protecting Columns

Hi, that was looking great, I have tried it in excel 2016, the option is there but will not work...

by nparsons75
Replies
5
Views
124

### Re: Protecting Columns

Hi,

Ok, so I have two different levels of people of whom I would like to be able to edit certain things. For example, supervisor can edit some areas and a manager with have more areas available to...

by nparsons75
Replies
5
Views
124

### Protecting Columns

Hi,

Is it possible to protect certain columns with a password. I would like to password protect some columns in order to allow only a certain number of authorised people to edit them?

Thanks,
15. ## Thread: Pivot to show top 5, However.....

by nparsons75
Replies
12
Views
424

### Re: Pivot to show top 5, However.....

Hi,

Yes I do see get and transform, something I have never used to be honest.
16. ## Thread: Pivot to show top 5, However.....

by nparsons75
Replies
12
Views
424

Hi,

17. ## Thread: Pivot to show top 5, However.....

by nparsons75
Replies
12
Views
424

### Re: Pivot to show top 5, However.....

Hi Rory, thanks for the help, however, I havent got power query or even know what it is...:laugh:
18. ## Thread: Pivot to show top 5, However.....

by nparsons75
Replies
12
Views
424

### Re: Pivot to show top 5, However.....

its very hard to explain...

My data in the main table is mixed, some data is vertical, some horizontal. I need to pivot the horizontal data which is not always possible, pivot data should be...
19. ## Thread: Pivot to show top 5, However.....

by nparsons75
Replies
12
Views
424

### Re: Pivot to show top 5, However.....

Hi, It wont let me. I have a pivot table built from calculated fields, however it will not let me filter as it will with a normal pivot table?
20. ## Thread: Pivot to show top 5, However.....

by nparsons75
Replies
12
Views
424

### Pivot to show top 5, However.....

I have a normal table of data, in most cases the data is vertical, however, within the table is some data that is horizontal, by this I mean running along the columns as opposed to in rows. I have...
21. ## Thread: Week numbers and formula

by nparsons75
Replies
1
Views
122

### Week numbers and formula

Hi, I have a table with for example 10 rows, in Col A is a name, In Col B is a formula which calculates the average of the next 52 columns. Each of the 52 columns represent a week of the year.

I...
22. ## Thread: text in cell based on value of another cell

by nparsons75
Replies
3
Views
131

### Re: text in cell based on value of another cell

Thank you, that works perfect, however, as this works, I have now realised another issue....

In A1 the score will vary and based on the score value I need to add some text. For example, between 0...
23. ## Thread: text in cell based on value of another cell

by nparsons75
Replies
3
Views
131

### text in cell based on value of another cell

Hi, I have a scoring system that I would like to display text in a cell base don the score.

For example, should the score be between 0 and 1.5 in A1 then this text will display in B1. "This is a...
24. ## Thread: Conditional formatting if, and etc...

by nparsons75
Replies
3
Views
123

### Re: Conditional formatting if, and etc...

PERFECT, thank you so much.

How do i copy the formula in to numerous cells so that it works for the other cells also? Column A and B, if I drag it down it remains for the original cell.
25. ## Thread: Conditional formatting if, and etc...

by nparsons75
Replies
3
Views
123

### Conditional formatting if, and etc...

Hi,

I have 2 columns, A & B.

Currently in A is no data and the same in B.

Should data be added to column A, then column B with highlight in red (fill). Then, when Column B has data added,...
Results 1 to 25 of 150
Page 1 of 6 1