Hello friends,
Following is a small block of data. I need to write a formula, such that
Output in B1
If A1="All Segments",
Combine A2, A3, A4, A5 (into B1).....till another "All Segments" is encountered
If A1<>"All Segments", return '0'
X A B
1 All Segments...
First of all, a great site. Got redirected over here from pagalguy.com article speaking about the same. I am a beginner in excel, and hope to excel in it.
Here is my doubt:
Say I have a value of 'x' in D4, & a value of 75 in K2
Now in C6, I want a value 'y' based on the value in D4.
The...