Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    116

    Pivot Table problem

    Hi All
    I am having a problem with a pivot table which I need help with please. From the data table below I want to get the bootom 5 values but exclude the blank cells from the cvount in the pivot...
  2. Replies
    1
    Views
    139

    Array formula help pease

    Wonder if someone can help me please

    I have a list column A = Team, Column B = Name ID and Column C = Name (in sample "As is")

    What I want to do is create another list (in sample below...
  3. Replies
    6
    Views
    269

    Re: Conditional Formatting

    I have tried both ways and even though I have selected the current selection or the current worksheet edited or cleared and redone it only changes the one cell not all.

    I must be doing something...
  4. Replies
    6
    Views
    269

    Re: Conditional Formatting

    If I can Explain a bit more cos what you said is not working

    Cell A9 =$F$9>$C$173 Cell G9 =$J$9>$G$173
    Cell A13 =$F$13>$C$173 Cell G13 =$J$13>$G$173
    Cell A17 ...
  5. Replies
    6
    Views
    269

    Conditional Formatting

    Hi
    I wonder if anyone can help

    I have a spreadsheet and every cell has a conditional format in it (1230 cells)

    The conditional format is a formula =$AD$9>$AA$173

    All I want to do is take a...
  6. Replies
    5
    Views
    206

    Re: Formula help vlookup and possibly if

    I have managed to sort now and all works perfectly. Thank you very much for your help Aladin much appreciated
  7. Replies
    5
    Views
    206

    Re: Formula help vlookup and possibly if

    Hi
    I cannot seem to get this to work any other ideas please
  8. Replies
    5
    Views
    206

    Formula help vlookup and possibly if

    Hi
    I looking for some help solving this formula if someone could help I would be grateful

    I have used this but does not work =IF($B3=$D$2,VLOOKUP($B3,B:C,2,),FALSE) I just keep getting the same...
  9. Replies
    3
    Views
    120

    Re: Help to solve a formula problem

    colum c just counts how many pallets tipped for a given dcam in another sheet
  10. Replies
    3
    Views
    120

    Help to solve a formula problem

    I have a problem I an trying to solve and wonder if anyone could help please.:)

    I have 3 columns ,what I am trying to do is create a formula that IE every time the same number appeared in column...
Results 1 to 10 of 10