Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Match value in row and the find specific value in that table

    Solved
  2. Re: Match value in row and the find specific value in that table

    I can ofcause use index match but the I'll only get to the row of the ID. How do I calculate number of rows bellow (in this case) the ID until next empty cell so I get the last row in that specific...
  3. Match value in row and the find specific value in that table

    https://screenshot.net/r4rlxf1

    Hi,

    this should be easy but I can't seem to find the solution.

    See attached picture on top of the page (couldnn't add it as a picture in the post?). First I...
  4. Re: Popup if cetain part of cell is over a certain value

    Ofcause it should say e.g. IT14 in cell L16 (as in the VB script).
  5. Popup if cetain part of cell is over a certain value

    Hi,

    I'm tring to create a popup i the last two figures in a cell is over a certain value.

    the cell refered to contans 2 letters and 2 figures and I need only to refer to the two figures in the...
  6. Replies
    3
    Views
    167

    Re: Percentrank with array more than 9768 rows

    Hi,

    thank you, you are so right. The problem was because I had a cell with error on way down in the document. I thought I deleted all data but apparently missed one cell. Sorry for this and thank...
  7. Replies
    3
    Views
    167

    Percentrank with array more than 9768 rows

    Hi,

    I'm trying to use the Percentrank function to rank salaries, but the list is more than 10.000 rows which Percentrank doesn't seem to like. I can use the function as long as I keep the array...
  8. Replies
    2
    Views
    2,111

    Re: Slicer: how to lock slicer to one option only?

    Anybody please, can't work this out.
  9. Replies
    2
    Views
    2,111

    Slicer: how to lock slicer to one option only?

    Hi,

    I have a sheet with individual information for employee that I have created a pivot table from and added slicers, so far so good.

    Now to the problem, one of the columns in the individual...
  10. Replies
    7
    Views
    1,969

    Re: "Complex" formulas in pivottable?

    Ahhhhh I solved it :nya:

    I created a pivot table from the pivot table I pasted in my first post by pressing the key combination (Alt+D+P) in a new sheet. In the list of data source options choose...
  11. Replies
    7
    Views
    1,969

    Re: "Complex" formulas in pivottable?

    Sorry can't get it to work as the pivot is based on an individual list. I also tried to create an pivot table out of the pivot table I pasted above but to no success, Excel didn't like it.

    Any...
  12. Replies
    7
    Views
    1,969

    Re: "Complex" formulas in pivottable?

    Yes same here, it's frustrating!
  13. Replies
    7
    Views
    1,969

    Re: "Complex" formulas in pivottable?

    Sorry I forgott to mention that shown above is the pivot tabel, the table was derived from a individual list with employees.

    FoxSeaLady, I will try your version.

    Any other sugestions.
  14. Replies
    7
    Views
    1,969

    "Complex" formulas in pivottable?

    Hi,

    I have a problem that I can't seem to figure out.

    I have a list with job grades and am trying to calculate difference in sallary for men and women. As it is today I have calculated this...
  15. Re: How do I count = signs in a row with arguments, driving me crazy!

    Ahhhh brilliant, your my hero of the day!!
  16. How do I count = signs in a row with arguments, driving me crazy!

    HI,

    I've a problem that is drivning me crazy. I'm creating an Excel sheet with statistics for a yearly salary review.

    In the document that the managers will fill in there is a column for the...
  17. Updating master sheet with data from multiple sheets

    Hi,

    I've a problem that I can't find the solution to.

    I have multiple data sheets with tables and I want to create a master sheet table that automaticly will update when now rows/data is added...
  18. Re: How can I extract filtered values from a table?

    Awesome AK, thanks a lot! You're my hero today :)

    /Per
  19. How can I extract filtered values from a table?

    Well I have a list with names and countries:

    Country Name
    US Ben
    UK John
    UK Liza
    FR Karen
    US Carl
    FR Sophie
    US Anders
  20. Re: How to get get cell valure based on parameters

    Thanks AK it seems to be working :)

    /Per
  21. How to get get cell valure based on parameters

    Sorry if the title didn't say it all.

    I have a probelm which I can't seem to solve.

    I have a list called "DATA" and in column A I have countries (Sweden, USA, France and so on) and in column B...
  22. Replies
    19
    Views
    739

    Re: MIN value without 0 in seperate cells?

    So sorry guys, of cause it worked. My bad.

    Thank a lot for the patience :), it really helped me big time.
  23. Replies
    19
    Views
    739

    Re: MIN value without 0 in seperate cells?

    I can't get it to work? It still includes all the columns not just A, E and I?
  24. Replies
    19
    Views
    739

    Re: MIN value without 0 in seperate cells?

    I used shift+ctrl+enter. I will try it again. Thanks a lot for the help and patience :D
  25. Replies
    19
    Views
    739

    Re: MIN value without 0 in seperate cells?

    Thanks, but it still includes all the cells not just A2, E2 and I2? Or am I doing something wrong?
Results 1 to 25 of 28
Page 1 of 2 1 2