E
emre
I have several individual excel worksheets(files) showing some certain
parameters(ex. Ca, Mg, Turbidity, all related with water characteristics.)
These have been recorded on montly basis, and the recordings have been made
between the years 1985 to 2001. So what i actually have in a worksheet is
smtg like
year parameter january february march .... ....
..... dcmber
1992 Ca 250 300
34 113
1992 Mn 20 13 45
1997 Ca 400 300
1998 Mn 13 30 20
as you see there are more than one parameter in the parameter
column(2 Ca montly readings of corresponding years, again 2 Mn readings etc.)
what i am supposed to is to form a neat table, like below
parameter n min ave max
Ca
Temp
Turbidity
Hg
etc.
where n stands for the total number of readings of that parameter in a
single survey point(each worksheet i have, includes all these parameters of
one corresponding survey station) since the first data(some stations have
missing data lacking the years of 80's)
min stands for the min value amongst the readings of the corresponding
parameter
max is again max value amongst ...
ave is the average of these readings(ex. in years 92,95,96; 3 rows of Ca
readings on montly basis.)
i follow the procedure below.
open a worksheet
choose autofilter
now the filtered, i can select a single parameter and see all values about it.
from now on, i thought i had two choices
1. select the filtered range of cells, with right mouse button click on the
status bar of excel(there are useful func. there;
sum,ave,min,max,countnumber,count)
i have to change the function 4 times(right clik four times) and manually
write the values to another table.
2.select the filtered range of cells, choose four arbitrary but neighbor
cells, use excel worksheet function to do same thing the status bar functions
do(looking for number of values, min of values, max of values, average of
values)
the latter seemed efficient to me so i jumped, but i saw that when you
select autofiltered cells, excel also selects the values hided via the
autofilter function.
this doesn't seem to be a problem with first way, you select your filtered
cells, and it always gives the correct results. but first way takes too much
time.
is there a way to bypass this problem. i tried copy-pasting these filtered
values to some place else, it then works with second way if you select those
pasted values, but again it is a huge loss of time. i want some automation.
i am desperate for help. this is a short question with long explanation.
hope ive explained my problem clearly.(wish i could send one of these
worksheets to this community)
thanks
ozan
parameters(ex. Ca, Mg, Turbidity, all related with water characteristics.)
These have been recorded on montly basis, and the recordings have been made
between the years 1985 to 2001. So what i actually have in a worksheet is
smtg like
year parameter january february march .... ....
..... dcmber
1992 Ca 250 300
34 113
1992 Mn 20 13 45
1997 Ca 400 300
1998 Mn 13 30 20
as you see there are more than one parameter in the parameter
column(2 Ca montly readings of corresponding years, again 2 Mn readings etc.)
what i am supposed to is to form a neat table, like below
parameter n min ave max
Ca
Temp
Turbidity
Hg
etc.
where n stands for the total number of readings of that parameter in a
single survey point(each worksheet i have, includes all these parameters of
one corresponding survey station) since the first data(some stations have
missing data lacking the years of 80's)
min stands for the min value amongst the readings of the corresponding
parameter
max is again max value amongst ...
ave is the average of these readings(ex. in years 92,95,96; 3 rows of Ca
readings on montly basis.)
i follow the procedure below.
open a worksheet
choose autofilter
now the filtered, i can select a single parameter and see all values about it.
from now on, i thought i had two choices
1. select the filtered range of cells, with right mouse button click on the
status bar of excel(there are useful func. there;
sum,ave,min,max,countnumber,count)
i have to change the function 4 times(right clik four times) and manually
write the values to another table.
2.select the filtered range of cells, choose four arbitrary but neighbor
cells, use excel worksheet function to do same thing the status bar functions
do(looking for number of values, min of values, max of values, average of
values)
the latter seemed efficient to me so i jumped, but i saw that when you
select autofiltered cells, excel also selects the values hided via the
autofilter function.
this doesn't seem to be a problem with first way, you select your filtered
cells, and it always gives the correct results. but first way takes too much
time.
is there a way to bypass this problem. i tried copy-pasting these filtered
values to some place else, it then works with second way if you select those
pasted values, but again it is a huge loss of time. i want some automation.
i am desperate for help. this is a short question with long explanation.
hope ive explained my problem clearly.(wish i could send one of these
worksheets to this community)
thanks
ozan