Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. 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. 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. 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. 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. 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. 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. 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. 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. 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...
  10. 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. 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...
  12. 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...
  13. 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...
  14. 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. 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. Replies
    12
    Views
    424

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

    Hi,

    Office home business 2016
  17. 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. 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. 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. 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. 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. 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. 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. 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. 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 2 3 4