• OK, it's on.
  • Please note that many, many Email Addresses used for spam, are not accepted at registration. Select a respectable Free email.

Need Help with Excel Formatting

Local time
Today, 14:58
Joined
Dec 8, 2012
Messages
1,038
Location
L'eau
#1
Hey all,

I need to manipulate some raw data.

Long story short, I can't figure out how to change the protocol on the other software to collect values that are exclusively over "100".

All I need is to be able to delete all cells in my spreadsheet that have a value less than 100.

Thanks!
 

ProxyAmenRa

Here to bring back the love!
Local time
Tomorrow, 04:58
Joined
Sep 30, 2009
Messages
4,675
Location
Australia
#2
You could do it the slow way by writing if statements:

B1=if(A1>100,1,0)

Or you can write a visual basics function.

Or you can program a macro.
 

Polaris

Radioactive vision
Local time
Today, 07:58
Joined
Oct 13, 2009
Messages
2,003
#3
Just use the filter function to select all the values < 100, then delete them. If you have too many values below 100, just filter all values > 100 and copy these to a new spreadsheet.
 
Local time
Today, 14:58
Joined
Dec 8, 2012
Messages
1,038
Location
L'eau
#4
Polaris, I can't figure out your method. Proxy, your code gives me TRUE/FALSE, idk what I'm doing.
 

ProxyAmenRa

Here to bring back the love!
Local time
Tomorrow, 04:58
Joined
Sep 30, 2009
Messages
4,675
Location
Australia
#5
Polaris, I can't figure out your method. Proxy, your code gives me TRUE/FALSE, idk what I'm doing.
Yes, that is correct. So you can hide the unnecessary lines by right clicking on the line number and left click hide. If you have numerous lines, this process can be slow.

if(A<b,0,1) should not give true/false, it should give 0/1.
 
Top Bottom