View Full Version : excel query1
simmus0300
2009-07-02, 12:42 PM
I have an excel file inwhich there are two columns-cell id,rx level.I want the same cell id comes once and range of rx level comes. Eg.
Old excel file
cell id rx level
154011 -60
154011 -80
154011 -95
154040 -100
154040 -85
the new excel file shold like this:-
cell id Rx level
154011 -60 to -95
154040 -85 to -100
da_manole
2009-07-03, 02:10 AM
I have an excel file inwhich there are two columns-cell id,rx level.I want the same cell id comes once and range of rx level comes. Eg.
Old excel file
cell id rx level
154011 -60
154011 -80
154011 -95
154040 -100
154040 -85
the new excel file shold like this:-
cell id Rx level
154011 -60 to -85
154040 -85 to -100
What i understood .
you need to split the dates in two ranges between -60 to -85
and -85 to 100
Exactly this it's made in excel (i made a correction )
If the range it's under -100 you will receive an alert
If you don' t want this or it's unclear PM me
Hopefully this it's what you want .it's possible to make this in more ways
BR
gigel
2009-07-03, 04:43 AM
I have an excel file inwhich there are two columns-cell id,rx level.I want the same cell id comes once and range of rx level comes. Eg.
Old excel file
cell id rx level
154011 -60
154011 -80
154011 -95
154040 -100
154040 -85
the new excel file shold like this:-
cell id Rx level
154011 -60 to -95
154040 -85 to -100
can be done in excel:
select columns > data > pivot table > next next next
drag and drop Cells to "row fields" and values to "data idems" twice and right click on value and then field setting and first put max and second put min, from here is very simple :)
hope for thanks and reputation if helped you.
simmus0300
2009-07-03, 10:56 PM
Hopefully this it's what you want .it's possible to make this in more ways
BR
sorry, I have not understood. pl check again the example.xls file.
simmus0300
2009-07-04, 12:12 AM
can be done in excel:
select columns > data > pivot table > next next next
drag and drop Cells to "row fields" and values to "data idems" twice and right click on value and then field setting and first put max and second put min, from here is very simple :)
hope for thanks and reputation if helped you.
thanks.
Now one more query is-
rx level
45
34
56
67
89
I want to reverse the order of values in rx level column
new excel file
89
67
56
34
45
gigel
2009-07-06, 02:15 AM
thanks.
Now one more query is-
rx level
45
34
56
67
89
I want to reverse the order of values in rx level column
new excel file
89
67
56
34
45
if you have
cell_id : value
simple select both columns and go to Data>Sort with cell_id as first criteria "sort by" and descending value as second criteria "then by"
vBulletin® v4.2.5, Copyright ©2000-2024, Jelsoft Enterprises Ltd.