Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: COUNTIF with Multiple Criterias and Range

    That's alright Andrew. I'll use that as an alternative. Thank you.

    Thanks Par, I tried your technique and it worked. I never thought that you can use the same criteria twice for this type of...
  2. Re: COUNTIF with Multiple Criterias and Range

    Thanks for the reply Andrew. But how do i write it with the percentage inside the formula without using the LEFT/RIGHT function?

    The actual title for the range is - Percentage of players who...
  3. COUNTIF with Multiple Criterias and Range

    Hi Gurus,

    May I please ask for some assistance on how will i be able to get the percentage of each team with members receiving a different set of scores.

    I tried this formula and it doesnt seem...
  4. Replies
    2
    Views
    464

    SUBTOTAL with Multiple Conditions

    Hi gurus!

    I would like to ask for your expertise on how I can resolve this issue of mine.
    I would like to get the average of all the values under the R-E-D category on different locations.
    I...
  5. Re: Extracting records that match different criteria for multiple reports in different sheets

    Thanks Aladin! Appreciate the help

    Let me try to work it out at my end.

    SAV means savings. its actually the Salary, allowance and tax tables.
    Savings is based on the ACTUAL value. thats why I...
  6. Extracting records that match different criteria for multiple reports in different sheets

    Hi Excel Gurus,

    I would like to ask for some assistance on how I can better manage this monthly report. Below are the conditions and the output will be shown in a different sheet in the below...
  7. Replies
    1
    Views
    129

    Re: Data Validation Query With Calculation

    Any help out there?
  8. Replies
    1
    Views
    129

    Data Validation Query With Calculation

    Hi excel guru's,

    I would like to seek your help in creating a dynamic table for the total sale.
    Below are a list of store supplies with different categories and vendors.

    Here is what I want to...
  9. Replies
    2
    Views
    20,141

    Easy-XL or other Add-ins

    Hi,

    i would like to ask if "Easy-XL"is available in other format other than .exe or .msi?

    it is because I wont be able to install it at work. we are not allowed to install any application(.exe...
  10. Replies
    8
    Views
    517

    Re: Date/Time/Public Holidays

    Thanks much!

    Am still trying to fully understand the whole logic of formula...

    but really appreciate the help.
    Now am trying to calculate how many hours it took them to finish the job but i...
  11. Replies
    8
    Views
    517

    Re: Date/Time/Public Holidays

    It works just fine! Many thanks! :)

    Is there a way for the target date to show the time too? Its not much but good to have in one column rather than two.

    this is what i did, a very minor...
  12. Replies
    8
    Views
    517

    Re: Date/Time/Public Holidays

    Hi! Thanks for taking the time to read my post.

    Whatever complaint received after 1600, it will be serviced the next day from 0800 till end of day meaning till 2400, but its only till end of...
  13. Replies
    8
    Views
    517

    Date/Time/Public Holidays

    Hi,<o:p></o:p>
    <o:p></o:p>
    I have quite a challenging procedure that needs the excel MVPs expertise.<o:p></o:p>
    I have been asked to calculate if we are meeting the required SLA in processing our...
  14. Re: How to count similar values in pivot as 1

    Thanks Fazza. AM not that familiar with SQL but let try to study it first.

    Appreciate it
  15. Replies
    10
    Views
    43,940

    Re: How to count "BLANK" cells in a pivot table

    Thanks for the idea :beerchug:!

    I just inserted another column in the data table and hid it so that it wont show to the users.

    I hope it fail me in the pivot table.
  16. Replies
    10
    Views
    43,940

    Re: How to count "BLANK" cells in a pivot table

    <title>Excel Jeanie HTML</title>Here is a sample A1:B13 is the data and from column D to H is the pivot table. How will i show the total number of blank cells in "(blank)" column in the pivot...
  17. Replies
    10
    Views
    43,940

    Re: How to count "BLANK" cells in a pivot table

    Thanks for the help but, what i want is within the pivot table. Pivot table will be the one to count the blanks. I dont want to have a separate column to write down a formula to count the blanks.
    ...
  18. Replies
    10
    Views
    43,940

    Re: How to count "BLANK" cells in a pivot table

    Yes, i only want to count those in the data ranges. I dont have other issues its just i want the pivot table to count the blank cells.
  19. Replies
    10
    Views
    43,940

    Re: How to count "BLANK" cells in a pivot table

    Thanks Aladin. But how do you count blank cells in a pivot table.
  20. Replies
    10
    Views
    43,940

    How to count "BLANK" cells in a pivot table

    Hi,

    Is there a way to count blank cells in a pivot table?

    How about a formula to count blank cells too?

    Thanks much and Merry Christmas! :biggrin:
  21. Excel 2007 security on sheets for shared workbooks

    Hi,

    is it possible to set some security in a specific sheet where in only a specific user can open since the workbook shared with different users?

    Ex. SHEET1 can only be opened by Mr.B and...
  22. Replies
    5
    Views
    301

    Re: Sheet names and VBA

    Cool, thanks again!
  23. Replies
    5
    Views
    301

    Re: Sheet names and VBA

    Thanks bro!
    By the way, what is the 1,255 for?

    One more thing, can we limit the number of user is a specific sheet? What am saying is can we set some security in a specific sheet or making a...
  24. Replies
    5
    Views
    301

    Sheet names and VBA

    Is it possible for the sheet name to appear in a specified cell without using VBA codes?

    Let's say if i rename "SHEET1" to "MYNAME", "MYNAME" will appear in cell A1.

    Thanks!!!:biggrin:
  25. Replies
    8
    Views
    305

    Re: Help on IF function

    Got it Dom! Many Thanks!!!

    crimson_b1ade, am trying it as well thanks too bro!

    Appreciate it!
Results 1 to 25 of 30
Page 1 of 2 1 2