Hi,
Is there a better way of doing this?
Basically just want to return the "Yes"s with the name of the return.
Hi,
Is there a better way of doing this?
Basically just want to return the "Yes"s with the name of the return.
Hi,
If I understand correctly, try this formula in J5.
Else provided expected result.
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Hey,
Not what I meant, but thanks anyways and for your efforts. I want to essentially:
a) combine columns J, L, N by taking just the "YES"s.
b) no numbers
your request is still unclear, but maybe this...
=IF(I5>0,"YES","NO")&" "&IF(K5>0,"YES","NO")&" "&IF(M5>0,"YES","NO")
If this not what you want, please provide a few samples of your you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Column B is what I want - just wondering if theres a better way
The type of returns are displayed in one column, but only the yeses.
aahh OK thanks.
I would probably change your formulas to this...
J5=IF(I5>0,"Net","")
L5=IF(K5>0,"gross","")
N5=IF(M5>0,"Total","")
Then change your concat to this
=TRIM(J5&" "&L5&" "&N5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks