| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting time-frames
Thanks. This did the job.
"Nayab" wrote: Suppose you need to find the numbers lying in the bucket 0.75 -1, 1-1.25, 1.25-1.5, 1.5-1.75, 1.75-2 then, if your input is in column A as 0.75 0.76 0.96 1.9 1.2 1.4 then do a vlookup in column B of the sort =VLOOKUP($A1,$M$1:$N$6,2,1) where M1 to N6 contains 0.75 a 1 b 1.25 c 1.5 d 1.75 e 2 f and then in column C you can find the count by using =COUNTIF($B$1:$B $6,N1) Final sheet looks like: 0.75 a 3 0.75-1 0.75 a 0.76 a 1 1-1.25 1 b 0.96 a 1 1.25-1.5 1.25 c 1.9 e 0 1.5-1.75 1.5 d 1.2 b 1 1.75-2 1.75 e 1.4 c 0 2 f Its difficult to explain this way and will make sense if I can share my spreadsheet with you. But, I hope this helps to some extent. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) | Excel Discussion (Misc queries) | |||
| Freeze /Split frames | Excel Worksheet Functions | |||
| Can Excel Calculate time down to Frames i.e. Television or Film | Setting up and Configuration of Excel | |||
| freezing frames | Excel Worksheet Functions | |||
| Calculation of Hrs and Mins from 2 Time Frames | Excel Worksheet Functions | |||
Hybrid Mode
