In Excel, rows and columns can be deleted manually but,
'Is there any function in Excel by which:
1) I can delete rows/columns of data which does not pass the condition set by me
2) I can delete rows/columns of data which does pass the condition set by me'?
I use more than one internet connections in my pc, and I use networx to monitor internet usage through my pc, but networx cannot monitor usage from different connections separately.
though it can export all data to Excel.
in Excel the data looks like:
Connection Time Duration Total data usage(bytes)
X
X
Y
Y
A
X
I can delete rows of connections Y and A manually if I want to know total usage of connection X, but I want to do it with just one click I mean by some function.
'Is there any function in Excel by which:
1) I can delete rows/columns of data which does not pass the condition set by me
2) I can delete rows/columns of data which does pass the condition set by me'?
I use more than one internet connections in my pc, and I use networx to monitor internet usage through my pc, but networx cannot monitor usage from different connections separately.
though it can export all data to Excel.
in Excel the data looks like:
Connection Time Duration Total data usage(bytes)
X
X
Y
Y
A
X
I can delete rows of connections Y and A manually if I want to know total usage of connection X, but I want to do it with just one click I mean by some function.