negatives value selection in excel

April 4, 2012 at 03:47:49
Specs: Windows XP
Can please advice what function to use in excel to automaticly pick up only the negative values s in tab 2 and ignore any other number
Essentially I want excel to recognize in tab 1 whether a column contains a negative number and automaticaly shows it in tab 2 and do not show in tab 2 any positive or =0 values.

See More: negatives value selection in excel

Report •

April 4, 2012 at 04:24:03
I take it by "tab" you mean sheet.

In Sheet 2, A1 enter:


should work.


Report •
Related Solutions

Ask Question