Hi
It mean you are trying to create dependent drop down..see example in
attached sheet.
Thanks!!
On Tue, Jul 9, 2013 at 1:36 PM, SG wrote:
> Thanks for the reply bt it doesn't solve my purpose.Let me try one more
> time to explain.
> What i want is that when i select domain, then, only name &
try this udf
Function nm(rng As Range) As String
Dim cl As Range
For Each cl In rng
If Mid(cl.Value, 3, 1) = "-" And Mid(cl.Value, 7, 1) = "-" Then
nm = Left(cl.Value, 12)
Exit For
End If
Next
End Function
if its nt working in that case share s
Thanks for the file, one minor problem
if we have some texts in the same cell, what should I do
for example:
\
nn-nnn-n Text Commision Tax etc etc
I tried Left(cl.value,12) but it didn't work
Thanks
On Tue, Jul 9, 2013 at 9:24 AM, ashish koul wrote:
> chk the attached file . see if it hel
try this =LEN(A2)-LEN(TRIM(A2)) and fill down till end
On Tue, Jul 9, 2013 at 7:55 PM, Anil Kumar wrote:
> Hi
>
> Please Help me attachment file.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
Hi
Please Help me attachment file.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
chk the attached file . see if it helps
On Tue, Jul 9, 2013 at 7:47 PM, wrote:
> Here is a sample file with 2 example sheets
> On Monday, July 8, 2013 1:43:08 PM UTC-5, ha...@mst.edu wrote:
>>
>> Hi All,
>> Basically, I want to find a text from specific category and return the
>> text/number to
Here is a sample file with 2 example sheets
On Monday, July 8, 2013 1:43:08 PM UTC-5, ha...@mst.edu wrote:
>
> Hi All,
> Basically, I want to find a text from specific category and return the
> text/number to a specific cell.
> For example,
> API NUMBER: (return the value here)
> Find API number
Have u send the file which i mailed you few days back
On Tue, Jul 9, 2013 at 1:36 PM, SG wrote:
> Thanks for the reply bt it doesn't solve my purpose.Let me try one more
> time to explain.
> What i want is that when i select domain, then, only name & accuracy in
> that domain will display on re
can u share the sample file
On Tue, Jul 9, 2013 at 12:13 AM, wrote:
> Hi All,
> Basically, I want to find a text from specific category and return the
> text/number to a specific cell.
> For example,
> API NUMBER: (return the value here)
> Find API number from the following text(be aware:API #
I missing in our formula (iserror)
=IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),"",C1)
.
Enjoy
Team XLS
On Tue, Jul 9, 2013 at 5:22 PM, raghunandan rallapalli <
raghunandan.rallapa...@gmail.com> wrote:
> Sir, kindly give solution for the attached file,
> thanks in advance
>
>
Thanks for the reply bt it doesn't solve my purpose.Let me try one more
time to explain.
What i want is that when i select domain, then, only name & accuracy in
that domain will display on report sheet..
then ,if i select any project in that domain, then it's correponding name &
accuracy will
11 matches
Mail list logo