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