Need Help with Excel Formatting

[The Introvert]

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]

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]

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.

 

[The Introvert]

Polaris, I can't figure out your method. Proxy, your code gives me TRUE/FALSE, idk what I'm doing.

 

[ProxyAmenRa]

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.

 

[The Introvert]

Got it. Thank you