I need help very necessary
I've offered this demand, "Mr. Excel forum"
Frankly, everyone make every effort to help, but all the solutions are not required.
I need a drop-down list, instead of the "Combo Box"
To achieve the same result, but the formulas
Thanks to all
Link to the forum Thread "Mr. Excel"
May wish to view it
Value corresponding to the name
Here's one way to do it.
=IF(ISERROR(N(INDIRECT("B"&SMALL(IF($A$1:$A$7=C1,R OW($A$1:$A$7)),ROW($A$1:$A$7))))),"",INDIRECT("B"& SMALL(IF($A$1:$A$7=C1,ROW($A$1:$A$7)),ROW($A$1:$A$ 7))))
As array formula
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
In your example you have used a drop down and based on selection you know the row no of selected value even if it is repeated or not but in case of formula how would excel know which number of instance you are picking.
Last edited by LalitPandey87; 07-15-2014 at 08:27 AM.
Fantastic, Mister, "Fox Excel"
But this solution has been reached in "Mr. Excel" But in another way
But you can show only one value in the cell "D 1" and change with the cell "C 1"
You could be the solution your way?
As a result, as the file sender?
Thank you very much again for this wonderful solution
Last edited by emmye998; 07-15-2014 at 09:44 AM.
Just use this formula in C2 and drag down
=IF(D2<>"",C1,"")
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Unfortunately, "Mr. Fox"
This is not required, it seems that I did not explain the idea, well
I want this cell (D1) is changed with the change of the cell (C 1)
Like this:
I don't think you understood what I was proposing. Please check the attachment.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
very sorry Mister, "Fox"
For your efforts with me, thank you for your patience my sir
If we changed the title of the post to:
"Get a cell change depending on the change all values, even if the value of similar"
We'll get to the solution
It seems I did not explain the topic well yet:
I want to change the cell "D1" change depending on the "C1" Well this is happening.
2 - I want to be changed (D1) even if the condition is a duplicate value corresponding to this condition
In other words, if the "M1" in the column "A" corresponds to "2" in the column "C" shows "2" in cell "D1". If we wrote this "M1" in cell "C1".
If the "M1" in the column "A" corresponds to "5" in the column "C" shows "5" in cell "D1". If we wrote this "M1" in cell "C1".
If the "M1" in the column "A" corresponds to "2" in the column "C" shows "2" in cell "D1". If we wrote this "M1" in cell "C1".
Last edited by emmye998; 07-17-2014 at 01:44 PM.
Posting Permissions
Reply With Quote
Bookmarks