Need to extract bin# value and if not found then an empty cell must be displayed.
If there are 2 bin#'s are found both most be returned. ( 2 would be the maximum)
If no bin# is found then an empty cell must be displayed!
I tried to fix the issue looking for the " = " charactor and then written my
formulas in column " My formula 1 " + " My formula 2 "
I prefer if it could be written all in one cell if possible so!
In scenario 1 I have no problem , also no issue in scenario 2
The trouble starts if only one ( or none at all ) bin# ( = ) is found then
i get the error " #VALUE!"
Like I said I prefer one cell formula if possible, or a visual basic routine as a
MACRO WOULD ALSO BE FINE IF THAT IS THE ONLY WAY to write this.
IN ROW 20 thru 28 and under Column "C" is the desired results (in a green cell ) I
would like to have....