Dear All
Please find query.
I have a excel sheet where I store all parts details I received .
I want to make a list of all parts .
I cant use remove duplicate function..
Can I get some other way/Formula so that list will keeps on updating as and
when I will add new parts.
Please find attached sheet
Dear Pankaj
Nice explanation thanks,
Dear Prafull
Thanks for kind help
Regards
Shrini
On Thu, Aug 27, 2015 at 6:16 PM, Prafull Jadhav
wrote:
> Dear Shrinivas,
> You will get this after selecting formula and Press F9
> For example
> select 1/(A2:A18=F3) and then Press F9
>
>
>
>
> Regards,
> Pr
Hello All,
Hope you are doing great…
Please send me updated resume to ma...@genuineitllc.com
*Title : SFDC ADMIN*
*Location : Houston, TX*
JD:-
I am currently recruiting for a Salesforce admin for a media company in
downtown Houston. If you or anyone in your network is looking, I would
Hello All,
I am Karthik. I have been using excel VBA for more than 10 years now.
Have always been amazed at the power of excel VBA.
Regards,
Karthik
--
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 @
select that column -Text to Column ( in Data Tab) -Click Finish
Regards,
Prafull Jadhav
9920553518
On 27 August 2015 at 18:49, SUDHIR VERMA wrote:
> Dear Friends,
> Please help me as per attached sheet. I have data of 25k row. there are
> some code formatting as text. So you are request to
Dear Friends,
Please help me as per attached sheet. I have data of 25k row. there are
some code formatting as text. So you are request to please share formula
for this.
Here, example is attached.
Thanking You
Regards
Sudhir
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b
Dear Shrinivas,
You will get this after selecting formula and Press F9
For example
select 1/(A2:A18=F3) and then Press F9
Regards,
Prafull Jadhav
9920553518
On 27 August 2015 at 18:05, Pankaj Sharma wrote:
> Hi Shrinivas,
>
>
> "($A$2:$A$17=F2)" Here, A2:A17 array checking where F2 value is
Hi Shrinivas,
"($A$2:$A$17=F2)" Here, A2:A17 array checking where F2 value is equal or
not like true or false, and 1 is dividing the same value.
For True 1/1 = 1, and for False 1/0 = #DIV/0! ,
The value looks like this:
{#DIV/0!;1;#DIV/0!;#DIV/0!;#DIV/0!;1;#DIV/0!;#DIV/0!;#DIV/0!;#DIV/0!;#DIV/
Dear Abhi
Can you please explain (1/($A$1:$A$17=F2)
Thanks
Shrinivas
On Thu, Aug 27, 2015 at 4:30 PM, Prafull Jadhav
wrote:
> Great ...
> Abhishekji
>
> Regards,
> Prafull Jadhav
> 9920553518
>
> On 27 August 2015 at 15:51, Pankaj Sharma wrote:
>
>> Thank you Abhishek Jain
>>
>> On Th
Great ...
Abhishekji
Regards,
Prafull Jadhav
9920553518
On 27 August 2015 at 15:51, Pankaj Sharma wrote:
> Thank you Abhishek Jain
>
> On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain
> wrote:
>
>> HTH
>>
>> On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma
>> wrote:
>>
>>> HI Expert,,
>>
yup,, nice trick to get last small value...
very useful
On Thu, Aug 27, 2015 at 4:13 PM, Abhishek Jain
wrote:
> Just one thing though...I forgot to freeze the ranges which might result
> in incorrect values. The correct formula would be -
>
> =LOOKUP(2,1/($A$1:$A$17=F2),$B$1:$B$17)
>
> Regards,
Just one thing though...I forgot to freeze the ranges which might result in
incorrect values. The correct formula would be -
=LOOKUP(2,1/($A$1:$A$17=F2),$B$1:$B$17)
Regards,
On Thu, Aug 27, 2015 at 3:51 PM, Pankaj Sharma
wrote:
> Thank you Abhishek Jain
>
> On Thu, Aug 27, 2015 at 3:37 P
Thank you Abhishek Jain
On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain
wrote:
> HTH
>
> On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma
> wrote:
>
>> HI Expert,,
>>
>> i need a formula to find last collected Amount from client.For example
>> PFA.
>>
>>
>>
>>
>>
>>
>> --
>> Are you =EXP(E:RT
Great
On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain
wrote:
> HTH
>
> On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma
> wrote:
>
>> HI Expert,,
>>
>> i need a formula to find last collected Amount from client.For example
>> PFA.
>>
>>
>>
>>
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
HTH
On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma
wrote:
> HI Expert,,
>
> i need a formula to find last collected Amount from client.For example PFA.
>
>
>
>
>
>
> --
> 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
HI Expert,,
i need a formula to find last collected Amount from client.For example PFA.
--
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 conc
Dear all
I wanta template in Excel for maintaining chemicals inventory.
If any one have template please send it to me
Thanks in advance.
--
Shrini
--
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 @
ht
17 matches
Mail list logo
