Excel function and formula

0

Hello Sir

At present There are 6 columns (A-F) in the data table of attached excel file.
This data table is live streaming data and number of columns keeps changing to 5,7 or even 8.
I want to know which excel function and formula can work to scan row 1 of this table in search of a text (OI Difference) and then add all the +ve values and -ve values separately in the same column ?

Thanks

Viral

Answer
Discuss

Answers

0

Ok, you may be able to do a Search or a Search & Replace.  You will have to give more details or an example of what you mean by 'adding or subtracting 've'  values.  Please show your work up of issue and what the solution would be.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login