• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Dynamic Range Sum Based On Single, Dynamic Criterion Cell

    Column B = Employee initials. Column H = Parts run per jobs in rows 2 through 8. Data from another 60+ employees follows this representative batch. Employee initials will always be in column 2 and will always be in the row above the first line entry for job numbers and parts manufactured...
  2. M

    Production Schedule Breakouts

    I've discovered a follow-on problem. When my job numbers break into the 20000 and above, range, Excel will not recognize them. Jobs numbered 19999 and below work in the formulas I've tried, but injected the number 20000, 20001, and above don't. All cells formatted the same. No differences in...
  3. M

    Production Schedule Breakouts

    Sheet names are consistent. Only job data changes within each feeder sheet. Changes are dynamic and occur two or more times a day, depending on job completion status. (We're trying to provide near real-time data to our production leads.) Regrettably, I can spell "VBA", but cannot program in...
  4. M

    Production Schedule Breakouts

    Follow-up Example: Customer Feeder Sheet #1, Columns A through D, enter the following data. Row 1: ABC, 4/5/10, 12345, 4A123 Row 2: BCD, 4/8/10, 23456, 4B123 Customer Feeder Sheet #2, Columns A through D, enter the following data. Row 1: XYZ, 4/15/10, 34567, 4C123 Row 2: CDE, 4/18/10...
  5. M

    Production Schedule Breakouts

    1. First few columns are the same for all feeder sheets. After D, columns are not in fixed locations. Due date for one customer may be in M, but may be in J for the next customer, based on specific customer needs. However, column C always contains job number. 2. Only one entry. Example...
  6. M

    Production Schedule Breakouts

    Okay, you amazed me, yesterday; here's another. Multiple worksheets. Column headings vary in column placement among the sheets. I need to find data based on a job number. I enter the alphanumeric job number into cell c3 (example) on a master spread sheet. The formula needs to search across...
  7. M

    Hiding Zero Values in Charts

    Amazing! First, to get a response. Second, to get a response that quickly. Third, the response actually worked. Much thanks. I'll be telling others of your website!
  8. M

    Hiding Zero Values in Charts

    Formula in progressive monthly results cells is =SUMIF($D$2:$D$99,$D121,F$2:F100), changing as the months evolve. Therefore, where nothing has happened, return is nothing; I suppose, "zero". However, the line chart I'm using to visualize progression still displays the zero values; meaning...
  9. M

    Hello .. Introduce yourself

    Yours is the easiest Excel help site I've ever found. (Just found it this morning.) I know enough about Excel to be considered very good by others, but 'dangerous' to myself. Will be posting a question if, in the next few minutes, I don't find my answer among your other posts. Looking...
Back
Top