| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula
We would like a formula that would count a value once in range of date.
Date Value 01-01-07 3 01-01-07 3 01-01-07 4 01-02-07 1 01-02-07 4 01-02-07 1 01-03-07 3 01-03-07 1 The number is listed twice on 1-1-07; but we would like for it to be counted a one occuring value for the day (not counting a repeated value). The total value would be 2 from 01-01-07 to 01-03-07 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula
Hi,
Your data does not match your stated results. What are you counting in the range of values? You are counting each item once on any given date, so if you have 3 dates with items you must have a minimum of 3 as your total, but you say 2? -- Thanks, Shane Devenshire "Tamra Austin" wrote: We would like a formula that would count a value once in range of date. Date Value 01-01-07 3 01-01-07 3 01-01-07 4 01-02-07 1 01-02-07 4 01-02-07 1 01-03-07 3 01-03-07 1 The number is listed twice on 1-1-07; but we would like for it to be counted a one occuring value for the day (not counting a repeated value). The total value would be 2 from 01-01-07 to 01-03-07 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula
We are counting the number of crews that worked in a month. Sometimes crew 3
will work two shifts in one day. We're not wanting a value of 6. We are hoping to get the number of days crew 3 worked in a month. Each value to the right of the dates represent the crew number. So, for instance, crew 3 worked 2 days between 01-01-07/01-03-07. This is the number we're interested in and not the number of shifts that was worked in a month. I'm sorry I didn't explain it better earlier. ta "ShaneDevenshire" wrote: Hi, Your data does not match your stated results. What are you counting in the range of values? You are counting each item once on any given date, so if you have 3 dates with items you must have a minimum of 3 as your total, but you say 2? -- Thanks, Shane Devenshire "Tamra Austin" wrote: We would like a formula that would count a value once in range of date. Date Value 01-01-07 3 01-01-07 3 01-01-07 4 01-02-07 1 01-02-07 4 01-02-07 1 01-03-07 3 01-03-07 1 The number is listed twice on 1-1-07; but we would like for it to be counted a one occuring value for the day (not counting a repeated value). The total value would be 2 from 01-01-07 to 01-03-07 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Linear Mode
