hi
is there any way we perform the minus operation in excel similar to the one we do in sql minus i.e
It takes all the results from the first column, and then subtract out the ones that are present in the second column to get the final answer.
hi
is there any way we perform the minus operation in excel similar to the one we do in sql minus i.e
It takes all the results from the first column, and then subtract out the ones that are present in the second column to get the final answer.
The only way:
B1 is the column with numbers witch are substracted from A1 column
In C1 the results will appear
In C1 write this formula:Copy this formulaPlease Login or Register to view this content.
Then paste it on other cells of C column
It will change its form at every cell
I hope that helps
It's a plane,
No, it's a bird,
NO , it,s SuperRazBoss
I dont think thats what he means RazBoss.
SQL Minus means "what data is in the first column that is not present in the second column"
You may be able to use Advanced Filter to do this.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks