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
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 do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://
l
> A2.
>
> *Paul*
> -- ---
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you c
, 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
aces 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 >
> *
ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: "drew1...@gmail.com"
To: MS EXCEL AND VBA MACROS
Sent: Friday, November 6, 2015 10:04 AM
S
Hello,
I would be very grateful if someone could provide a formula for dividing
text to columns using " - " as a deliminator.
Many Thanks,
Andrew
--
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 @
htt
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
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 Brother,
What is this xlsm file as this formula is not working in my excel sheet.
On Tue, Feb 19, 2013 at 11:57 AM, अनिल नारायण गवली
wrote:
> Dear ikhan,
>
> Pl find attached herewith.
>
> Warm Regards,
> Gawli Anil
>
> On Tue, Feb 19, 2013 at 11:47 AM, Imran khan wrote:
>
>> Hi,
>>
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
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(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/
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
12 décembre 2010 08:14
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Need Excel Formula or VBA Function to Solve the
Query.
Dear Experts,
I have described my query in the attached workbook. I need excel formula or
any appropriate function to solve my query.
Please help me
25 matches
Mail list logo
