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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Excel function and formula
0
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.