1. H

    Pivot Table (from Database): count total of grouped items

    Hi everyone, Is it possible to display the number of grouped items as a value or as a bracketed suffix to the name? For example: Accessoires would show "Accessoires (12)" and Accessoires Indoor would be "Accessoires Indoor (39)" even though it is collapsed. Alternatively, B3 would show the...
  2. M

    Enter Timestamp for each time cell value changes

    I have dynamic low of day (LOD) stock prices in column A and last stock prices (LSP) in column B. The data is pulled from an external web service and never hard coded. I need to create 11 additional columns of data based on these two values: Column C would display the times the LSP fell below...
  3. ibmy

    Count if the value is positive and negative 'itself'

    Hi, Column A // Column B -0.1 // 1 0.1 // 2 -0.1 // 3 0.3 0.7 0.2 // 1 -0.2 // 2 -0.2 // 1 0.2 // 2 0.7 // -0.5 // 1 0.5 // 2 -0.5 // 3 0.5 // 4 0.5 // 0.3 // Rule: 1. The starting value can be negative or postive 2. Reset the count if :- i- value is...
  4. G

    Count consecutive negative numbers

    I am looking for a formula or vba, whichever is easier, where if the value in the row is negative, it will count until the next 0 or positive number, for the whole column. An example is below. I searched and couldn't find the exact thing I was looking for. Any help will be greatly appreciated...
  5. ibmy

    Count with interval conditional

    Column A / Column B // Column C 0 / 0.1 // (1) 0 / -0.1 // (2) 0 / 0.1 // (3) 0 / -0.1 // (4) 0 / 0.1 // (5) -0.1 / 0 // (1) 0.1 / 0 // (2) 0.1 / 0 // (1) 0.7 / 0 // -0.1 / 0.5 // Rule: 1) Starting value is...
  6. H

    How many sets of a number can I make?

    Hi! I have a huge set of data that includes hours employees have worked during a pay period. I need to know how many employees have worked 40 hours during the pay period. I can combine employees to get to one 40 hour employee. For example, if I have someone who has worked 40 hours they count as...
  7. E

    count if...

    hi Do you know how i can count how many times a number is shown in a column "item" but for each "order" counting as once, like the example? : ABCDE1OrdersItem21333133total of 33:24122525562337222
  8. R

    Employees over the year calculation

    Dear experts, I have an excel list of all employees with the hire date and termination date since the start of the company in 2002 up to now, 3 columns. The list includes the employees which are currently employed and the ones who left. So the employees who left have a hired and termination...
  9. E

    Count unique numbers

    Hi, I am trying to count the numbers from the first column (ItemCode). Some of those numbers are duplicated so the duplicated ones that are the same need to have the same number in the column "Numbers". Meaning for exapmle 31112802 which is duplicated, has a number of 2 and the next 31112802...
  10. K

    Possible to pull data from a website to show count of unread faxes?

    Hello, I am looking to see if it is possible to pull data into google sheets (or excel) directly from a website to show a live count of how many unread items there are. This is for a business where we receive faxes through a system called SRFax. My best guess for something like this would be...
  11. J

    Finding instances between time ranges that cross midnight

    Hello all, I feel like the answer lies here somewhere, but I'm having difficulty combining the possible answers into one, elegant solution. I'm trying to find the number of instances that a customer comes in to when they leave. I am trying to find out how many customers are present during...
  12. S

    Count chartbjects from multiple sheets in a excel file

    I have 3 charts in three different sheets in excel workbook. I want to count the number of charts present in excel workbook. I have tried activesheet.chartobjects.count It gives the count of charts present in that particular sheet. Can anyone has solution to count all the charts present across...
  13. A

    Count for multiple categories

    Hi Experts! I need to fill in the count of the following clients: Category ClientA ClientB ClientC Medical Dental Vision Here is the source data: Client Category ClientA Medical ClientA Dental ClientB Vision ClientC Dental What should I do?
  14. S

    Count Areas with a formula

    I am trying to count areas with a formula. Please see below. Thanks in advance! <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px...
  15. M

    COUNT Cells

    I have 2 columns on Sheet 2 In column 1 it says Mon all the way down to A10 Then Tues for a few more cells below, then Weds for a few cells and so on. The list is sorted in order To the right in Column B some cells have numbers in them and some are blank On Sheet 1 I want a summary, so it...
  16. S

    COUNTIFS(AND( help

  17. L

    CountIf True

    =COUNTIF(Data[Column1],TRUE) I have the above mention formula but i want to modify it to add that if Counts of Assets in BU is blank dont count the true now is counting 1,221 but it should be 1177
  18. A

    Formlua Help

    Hi, I need help writing what I think should be an easy formula. I am trying to get a count of people based on their department. The column that I want to count is located in Column AM. I need a formula that will count the number of entries that contains the department's name (ex. Human...
  19. L

    Count if Date Matches

    =COUNT(Raw_Data[Week],44,Raw_Data[Region]) How can i change the above formula to count if the date under the header name Date in sheet Raw_Data matches the date in D2 or withing the week of the date under the calculation Sheet and the if the header named Count of assets in BU have data (if...
  20. K

    Count data between dates

    Hello Folks , I am working on a file where in i am setting control limits "Upper Control Limit" and "Lower Control Limit" Sheet is working fine for me however need a small logic to be build in the below formula . =COUNTA(C24:C$523) In the above Formula "C24:C523 is the range where Dates are...

Some videos you may like

This Week's Hot Topics