I have 2 problems.
1. I was wondering if it is possible, I have a grid of random numbers. I have used the countif function to determine how many of each number there are in the grid. I was wondering if it is possible to set up a function or button to automatically then put these numbers into a grid below and put them into numerical order?

2. Is it possible when doing a spreadsheet for budgeting purposes, i would normally have an in, out and total column, the total column having a formula =sum(c2+d1) for example where there is an mount going in then change the formula when there is something going out. This is ok for me as i know how to change the formulas, but is there a formula that can identify if there is a figure in column b to then use - and if there is a figure in column c to use +??

Any help apprecited thanks.