Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with generating a formula PLSE.
what i would like to do is add any number under the 'no people' column, which
would then place a 1 under the relevent time for each person. see below for example: Time No People 10-11 2 11-12 3 between 10-11 there are 2 people working. 10am 11am 1 1 1 1 1 under 10am, there are 2 x 1 which equal 2people working. are there any formulas to do this? if so how do you apply them to different worksheets? ie mon, tue. Many thanx in advance xx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Formula generating a column of data? | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |