S
sip8316
Is there a way to set up multiple variables....What I mean is this:
I have a sheet set up in which in the columns I have tasks to do and in the
rows I have the rooms/buildings they have to be done in. Where they
interesect I have the number of times per week they are done (for example in
the annex trash is done 5 times/wk, in the control room 3 times/wk and so on)
The number of times per week is delegated by an x in a cell for each time.
I have it set up to add the x to find a weekly total but I want to have it
do this for each building and then to take the mode of all the buildings for
a particular task. The only way I coud think of was to make a loop that went
through for each task, and in that loop have it create a variable for
eachexisting room that contained the number of times the task had been done
(for the respective room)
Then To have another that took the sum of all those numbers and displayed
the sum somewhere on the spreadsheet. I will be doing this on many
spreadsheets with anywhere from 5 to 100 buildings.
Any help would be great.
Thanks,
Scott
I have a sheet set up in which in the columns I have tasks to do and in the
rows I have the rooms/buildings they have to be done in. Where they
interesect I have the number of times per week they are done (for example in
the annex trash is done 5 times/wk, in the control room 3 times/wk and so on)
The number of times per week is delegated by an x in a cell for each time.
I have it set up to add the x to find a weekly total but I want to have it
do this for each building and then to take the mode of all the buildings for
a particular task. The only way I coud think of was to make a loop that went
through for each task, and in that loop have it create a variable for
eachexisting room that contained the number of times the task had been done
(for the respective room)
Then To have another that took the sum of all those numbers and displayed
the sum somewhere on the spreadsheet. I will be doing this on many
spreadsheets with anywhere from 5 to 100 buildings.
Any help would be great.
Thanks,
Scott