Hi guys!
I have the following section of a current 'Sheet' i am working on.
Forum Formula.jpg
In Cell 'X8', how do i search within the Range W1:W8 and if any of the Cells contains anything, return this value in Cell 'X8'?
Any advice greatly appreciated
Cheers!
"if any of the cells contain anything"
You're implying there may be more than one that's not blank in that range.
If thats the case then you can either use TEXTJOIN if you have it or VBA is your only other option.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
If there will only be 1 value, you can just sum the range
=SUM(W1:W8)
Thanks Guys!
Yes there is always only 1 value so the SUM function is ideal
I didnt even think of that, much appreciated, feedback left to both of you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks