On Saturday, June 4, 2016 at 9:12:54 AM UTC+5:30, Prabhakar S H wrote:
>
> it is not happening because i have to get repated dates & names as per the
> attached format.
>
>
> On Friday, June 3, 2016 at 8:38:06 PM UTC+5:30, Abhi wrote:
>>
>> Why not just use pivot ?
>>
>> On Fri, Jun 3, 2016 at 8
it is happening because i have to get repated dates & names as per the
attached format.
On Friday, June 3, 2016 at 8:38:06 PM UTC+5:30, Abhi wrote:
>
> Why not just use pivot ?
>
> On Fri, Jun 3, 2016 at 8:35 PM, Prabhakar S H > wrote:
>
>> Hi Friends,
>>
>> I have Employee database where data
Why not just use pivot ?
On Fri, Jun 3, 2016 at 8:35 PM, Prabhakar S H
wrote:
> Hi Friends,
>
> I have Employee database where data is in raw & i need in column. Please
> refer attached file & help.
>
>
> Rgds,
> Prabhakar
> 9844430518
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* "drew...@gmail.com "
> >
> *To:* MS EXCEL AND VBA MACROS >
, November 6, 2015 2:07 PM
Subject: Re: $$Excel-Macros$$ Need excel formula for text to columns by " - "
not "-"
Excel 2007, but it only allows for one character not three
On Friday, November 6, 2015 at 11:23:11 AM UTC-5, Paul Schreiner wrote:
What version of excel are you
Excel 2007, but it only allows for one character not three
On Friday, November 6, 2015 at 11:23:11 AM UTC-5, Paul Schreiner wrote:
>
> What version of excel are you using?
>
> If it is Excel 2007 or later, there is a text-to-columns option in the
> "Data" tab.
>
> If you're looking for a VBA fun
What version of excel are you using?
If it is Excel 2007 or later, there is a text-to-columns option in the "Data"
tab.
If you're looking for a VBA function, you should be able to record a macro
while you utilize this icon.
If you're actually looking for an Excel FORMULA as you requested, you're
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
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
Dear ikhan,
Pl find attached herewith.
Warm Regards,
Gawli Anil
On Tue, Feb 19, 2013 at 11:47 AM, Imran khan wrote:
> Hi,
>
> Can anyone help me count cell by color? I have attached sheet which i need
> to count all green color.
>
> regards,
> Imran Khan
>
> --
> Are you =EXP(E:RT) or =NOT(EXP
Dear Sriram,
Please try it..
=INDEX($H$1:$N$1,0,SMALL(IF($H2:$N2=$C2,COLUMN($H$1:$N$1),""),COLUMN(A1))-7)
with ctrl+shift+Enter
Hope it helps to u.
See attached sheet.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
PM, sriram ji wrote:
>
> Dea
Hi,
See attached file. The result cells are painted yellow. The formulas are
array formulas (you have to validate them with Ctrl+Shift+Enter instead of
“Enter”)
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de amrahs k
Envoyé : dimanche
20 matches
Mail list logo
