rds,
DILIP KUMAR PANDEY,
mvp<https://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851>
MBA,BCA,B.Com(Hons)
UAE +971 528225509 India +91 9810929744
dilipan...@gmail.com, dilipan...@yahoo.com
Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey
--
Are
Microsoft says:-
Sheets in a workbookLimited by available memory (default is 3 sheets)
See this link also:-
http://office.microsoft.com/en-001/excel-help/excel-specifications-and-limits-HP010342495.aspx
Regards,
DILIPandey
On Mon, Jan 20, 2014 at 3:09 PM, Shankar Bheema wrote:
>
Can you share your expected output as well - manually entered ?
Regards,
DILIPandey
On Thu, Jan 16, 2014 at 5:22 PM, amar takale wrote:
> Dear expert team,
>
> PFA with detailed in sheet.
>
>
> I know this is a very big stuff, hoping that someone helps me to get it
>
Can you upload that file (after removing sensitive data) ?
Regards,
DILIPandey
On Thu, Jan 16, 2014 at 10:32 AM, Robinson Boreh wrote:
> Hallo to you all.
> I converted an excel 2003 with macro to a 2010 excel enabled macro by
> using save as option. I now get an warning every ti
, 7) is G8 of another sheet
Hope this is clear. Thanks.
Regards,
DILIPandey
On Thu, Jan 16, 2014 at 10:20 AM, Robinson Boreh wrote:
> Hi.
>
> I have macro code below. In layman's terms, can someone tell me what
> exactly it means. Am trying to learn macro
>
> 'En
Hi MLT,
Try using below formula which need to be confirmed using key combination:
ctrl shift enter
=IF(ISNUMBER(MATCH(A5,MID($A$1:$A$3,MIN(IFERROR(SEARCH($A$4,$A$1:$A$3),""))+2,1)*1,0)),"Matching","NotMatching")
Regards,
DILIPandey
On Tue, Jan 14, 2014 at 6:10
Hi,
Do you want only 'figures' to be sorted out OR do you want numbers
only to be sorted out ?
Regards,
DILIPandey
--
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On O
Hi Markkim,
I have checked that the answer of the formula =IF(A54=0,1,0) is 1
because A54 is blank in your sample sheet.
If I assume that you will have some value in A54, then the answer will
be 0 and then your below code is working fine :-
If range("A54") <> 0 then
Else
.
E
Hi Richard,
If the dates are present in B10 and C10, use following formula:-
=(DAY(EOMONTH(B10,0))-DAY(B10)+1)/DAY(EOMONTH(B10,0))
+IF(ISERROR(DATEDIF(DATE(YEAR(B10),MONTH(B10)+1,DAY(B10)),DATE(YEAR(C10),MONTH(C10)-1,DAY(C10)),"m")),-1,DATEDIF(DATE(YEAR(B10),MONTH(B10)+1,DAY(B10)),DATE(YEAR(C10),
Hi Ayoub,
It would be very helpful for the "Group" if you can share a sample
scenario of your problem.
Thanks,
DILIPandey
On May 31, 2:45 pm, ayoub Kakande wrote:
> Urgent help needed
>
> I have 18 subjects, 6 of them are compulsory from the other 12 a
> student offers
Hi Qcan,
For the better understanding of the group, can you transfer the
details in an excel spreadsheet and send the same as an attachment.
Thanks,
DILIPandey
On May 15, 10:45 pm, qcan wrote:
> Hi,
>
> I am looking for a couple of formulas that can be used to calculate an
>
Many congratulations Ashish... Keep up the helping spirit.
Best of Luck.
DILIPandey
On Apr 2, 2:24 pm, Ayush Jain wrote:
> Hello Everyone,
>
> Ashish Koul has been selected as 'Most Helpful Member' for the month of
> March'11
> He has posted 48 posts in Mar
Congrats Ashish...!!
Best Regards,
DILIPandey
On Mar 1, 8:38 pm, Ayush wrote:
> Hello Everyone,
>
> Ashish Koul has been selected as *'Most Helpful Member'* for the month of
> Feb 2011.
> He has posted 97 posts (13% of total posts) in February 2011 and helped many
>
13 matches
Mail list logo