snhandle
asked on
Excel formula no vba
I have two columns like below
Column c Column d
2. -
12. -
15. -
18.
25.
I want to create formula where when I have - in the last cell in column d then it should give me the column c data like in above example I want to get 15 number result of my formula
Column c Column d
2. -
12. -
15. -
18.
25.
I want to create formula where when I have - in the last cell in column d then it should give me the column c data like in above example I want to get 15 number result of my formula
EXPERT CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Sam
If I understood the question correctly, OP wants a single cell formula which should return the corresponding value from column C for the last occurrence of "-" in column D.
So as per your sample data, the formula should return 35 in the formula cell.
If I understood the question correctly, OP wants a single cell formula which should return the corresponding value from column C for the last occurrence of "-" in column D.
So as per your sample data, the formula should return 35 in the formula cell.
@Subodh,
So in the modified image above, does the OP want the value of 15 in E1, E3, E5, E1-E3, E1-E5 ?
So in the modified image above, does the OP want the value of 15 in E1, E3, E5, E1-E3, E1-E5 ?
Yes. But as I said it should be a single cell formula which would return 15.
ASKER
Yes it should be single cell formula where it can return 15
@snhandle
There are three formulas provided by three experts which will give you the desired output. It's time for you to test all of them and to choose one of them which you are comfortable with as a solution.
There are three formulas provided by three experts which will give you the desired output. It's time for you to test all of them and to choose one of them which you are comfortable with as a solution.
ASKER
Ok thanks
@snhandle
Can a cell in your column d have any other value after the last "-" ?
Will there be any empty cells in between minus signs?