Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

i have send you two attachment, which you are taking about ? Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:56 AM, amar takale wrote: > Dear Deba > Again Thanks for help,if i want more than 3 chart show how to modify code. > > On Fri, Dec 14, 2012 a

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Thanks Amar !! Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:52 AM, amar takale wrote: > Dear Deba Rajan, > > First Congratulation for winner of Calendar quiz.Dear Deba which you send > file it is fantastic,Mind blowing,I like it very much.I

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Attachment missed... Hi Amar, PFA the chart sheet, might it will help you out. -deba Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:23 AM, Deba Ranjan wrote: > Hi Amar, > > PFA the chart sheet, might it will help you out. > > > -d

Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution

Hi Amar, PFA the chart sheet, might it will help you out. -deba Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:05 AM, amar takale wrote: > Dear All Experts, > Can you help me above two file,last week you help me which is very > Helpful &knowl

Re: $$Excel-Macros$$ Formula to Calculate Age in Excel

then - just chnage the text as - for count of year- =DATEDIF(D111,TODAY(),"y") = 20 days for count of month- =DATEDIF(D111,TODAY(),"ym") = 11 months for count of days = =DATEDIF(D111,TODAY(),"md") = 17 days -- deba Thanks & Regards, *Deba ranjan* On F

Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.

Done !! Regards, Debaranjan Thanks & Regards, *Deba ranjan* On Sun, Nov 18, 2012 at 9:53 PM, Ayush Jain wrote: > Dear members, > > Let's get set for the new year 2013 > > Here is inviting you to participate in a quiz to make calendar for the new > year i

$$Excel-Macros$$ R-project

Hi All, Sorry, the r-project is not a part of this forum. But i just want to know if somebody might have some idea on this. Any one know about R-project ? if positive please let me know some tips. --Every body have right to know something then nothing !! Thanks & Regards, *Deba ra

Re: $$Excel-Macros$$ How to shrink a picture in userform * *

you are welcome !! Thanks & Regards, *Deba ranjan* On Fri, Oct 12, 2012 at 4:21 PM, Hilary Lomotey wrote: > excellent Deba, it works. thanks > > On Fri, Oct 12, 2012 at 10:40 AM, Deba Ranjan wrote: > >> [image: Boxbe] <https://www.boxbe.com/overview> Thi

Re: $$Excel-Macros$$ How to shrink a picture in userform *

Hi Hilary, After Inserting the Pic in the Userform, you need to go to the properties, and Select the -PictureSizeMode as 1. you can see the pic full. Thanks & Regards, *Deba ranjan * On Fri, Oct 12, 2012 at 4:03 PM, Hilary Lomotey wrote: > i have inserted a pictu

Re: $$Excel-Macros$$ Convert to number

Hi Robin, can use this for cleaning the number:- =IFERROR(CLEAN(TRIM(A2)),"") Thanks & Regards, *Deba Ranjan P* On Mon, Sep 17, 2012 at 12:47 PM, Karan Singh wrote: > Hi Robinson, > > Use =trim(your number) > > Regards > Karan Singh >

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Heartiest Congratulations brother. Thanks & Regards, *Deba Ranjan * On Mon, Sep 3, 2012 at 3:04 PM, Indrajit $nai wrote: > *Congrats Noorain. :)* > * > * > * > * > On Mon, Sep 3, 2012 at 11:59 AM, Rakesh Kumar Sharma < > rakeshks@gmail

Re: $$Excel-Macros$$ Cell show blank but in it show formula

Dear Amar, Use Iferror before the desire formula. you can use: =IFERROR(VLOOKUP(F5,$B$4:$D$9,3,0),"") Thanks & Regards, *Deba Ranjan P* On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote: > > -- > Join official facebook page of this forum @ >

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

My Heartiest Noorain Bro, congrts many more. Really heart of this members. Thanks & Regards, *Deba Ranjan P* On Sat, Aug 4, 2012 at 10:44 AM, अनिल नारायण गवली wrote: > congrats noorian ansari:) > Regards, > Gawli Anil > > On Sat, Aug 4, 2012 at 10:38 AM,

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

Dear JP, See the attached, hope this too will help you for extracting text. Thanks & Regards, *Deba Ranjan P* On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI wrote: > Dear JP, > > Formula is working fine.. > Please see attached sheet. > > On Fri, Ju

Re: $$Excel-Macros$$ Please help me.

& Regards, *Deba Ranjan P* On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay wrote: > Please tell us so that we can edit and learn it. How to make ? > calender_Simple.xls file > > > On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI > wrote: > >> Dear Manoj, &

Re: $$Excel-Macros$$ Please help me.

EAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1) Thanks & Regards, *Deba Ranjan P* On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar wrote: > Dear Expert, > > > I want to make Calender on excel > > when i enter year

Re: $$Excel-Macros$$ Look up errors from 2 sheets.

Thanks Every greato great gurus. Thanks & Regards, *Deba Ranjan P* On Thu, Jul 12, 2012 at 9:36 AM, Seraj Alam wrote: > Hi, > > Please see attached solution of your query and let me knowis it full > fill your requirement or not??? > > > > On Tue, J

Re: $$Excel-Macros$$ Text - Splitting - Help Required through Formula

A3)-FIND("#",SUBSTITUTE(A3," ","#",LEN(A3)-LEN(SUBSTITUTE(A3," ","") Thanks & Regards, *Deba Ranjan P* On Wed, Jul 11, 2012 at 5:26 PM, Manoj Kumar wrote: > Dear JP, > > Select the range Press ALT+D+E Click Delimited Next Cl

Re: $$Excel-Macros$$ no of sheets in a workbook

. Thanks & Regards, *Deba Ranjan P* On Wed, Jul 11, 2012 at 2:15 PM, सुनिता पौडेल wrote: > Dear Deba ji, > > While I do Alt+f11 blank workbook shows. What to do? > However I inserted userform and followed upto step 10. Here i got stuck. > Do I have to copy the codes tw

Re: $$Excel-Macros$$ Extracting a word from the cell.......

G2,LEN(C2)+7,LEN(G2)-LEN(C2&F2)-7)),"") For Forth:- =IFERROR(RIGHT(G2,LEN(G2)-FIND("#",SUBSTITUTE(G2," ","#",LEN(G2)-LEN(SUBSTITUTE(G2," ",""),"G2") Thanks & Regards, *Deba Ranjan P* On Wed, Jul 11, 2012 at

Re: $$Excel-Macros$$ Re: Look up errors from 2 sheets.

Thanks Ji,but could you please solve in the sheet. Thanks & Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 4:08 PM, CoRe wrote: > Hello , > > > In case you have to files .xls and .xlsx you have to make formula with > Insert Function ( ALT + I + F ). > > ins

Re: $$Excel-Macros$$ Look up errors from 2 sheets.

That is what the problem, i have like wise thousand datas which manually not possible to enter one by one, i want to look up by some eventual formulas. Thanks & Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 3:17 PM, Norman Cliff May wrote: > The lookup names have to be ente

Re: $$Excel-Macros$$ Unique Name Query

Hi Karan, PFA... Use this formula for unique extraction: =IFERROR(INDEX($A$1:$A$11,MATCH(0,COUNTIF($C$2:C2,$A$1:$A$11),0)),"") And for counting unique numbers: =SUM(1/COUNTIF(A1:A11,A1:A11)) Thanks & Regards, *Deba Ranjan P* On Sat, Jul 7, 2012 at 11:58 AM, Deba

Re: $$Excel-Macros$$ Excel Function_Code

os in Add-ins, then i hope it will be very easy to solve at a time without much effort and time. And in the first posting i have already attached one example for this. Please check. Thanks & Regards, *Deba Ranjan P* On Thu, Jul 5, 2012 at 11:39 AM, Jai wrote: > > Please tell

Re: $$Excel-Macros$$ Excel Function_Code

Thanks Chile, Working fine. Thanks & Regards, *Deba Ranjan P* On Wed, Jul 4, 2012 at 9:19 PM, ChilExcel wrote: > Please see attached Add-Ins, I think is what you need > > open excel add ins and then search > > functions "user defined" > > you sho

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12)

Verma Ji, congrates...very much Thanks & Regards, *Deba Ranjan P* On Thu, Jul 5, 2012 at 9:21 AM, Anil Gawli wrote: > heartly congrats Mr Rajan..:) > > Regards, > Gawli Anil. > > On Thu, Jul 5, 2012 at 8:32 AM, Raghav wrote: >

Re: $$Excel-Macros$$ Excel Function_Code

Any response please to my query ! Thanks & Regards, *Deba Ranjan P* On Wed, Jul 4, 2012 at 2:12 PM, Deba Ranjan wrote: > Any update please. can we make add-ins to this above query !! > > > Thanks & Regards, > *Deba Ranjan P* > > > > > &

Re: $$Excel-Macros$$ Excel Function_Code

Any update please. can we make add-ins to this above query !! Thanks & Regards, *Deba Ranjan P* On Wed, Jul 4, 2012 at 12:13 PM, Deba Ranjan wrote: > Dear experts, > >i am keep on trying to make mention below function code (concatenate) > as Excel Add-ins. Can we

$$Excel-Macros$$ Excel Function_Code

p; " " Next cell str = VBA.Right(str, Len(str) - 1) Full_con = str End Function -------- Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor t

Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file

Well enjoyed the example the story of santa banta. good fun. Thanks & Regards, *Deba Ranjan P* On Tue, Jul 3, 2012 at 1:54 PM, Divaker Pandey wrote: > :) > As your question as my answer. > > Ek Bucket thi usme pani, patthar , aur lakdi ka tukda tha, uska weight 10 >

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

Dear Ashish and Dilip. Sorry for the delay, its a really awesome stage. heartiest congratulate to both and please keep helping to this group. Thanks & Regards, *Deba Ranjan P* On Mon, Jul 2, 2012 at 9:23 PM, vijayajith VA wrote: > CongratsASHISH *DILIP... >

Re: $$Excel-Macros$$ Remove Punctuation

ot;", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End If Next lngLoop End If Next rngCol MsgBox "Heelo its done" End Sub Thanks Experts. Than

Re: $$Excel-Macros$$ Re: Remove Punctuation

Thanks Lait Ji, Working fine. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 27, 2012 at 4:20 PM, Lalit_Mohan wrote: > Sub RemovePunctuation() > Dim arrPunc As Variant > Dim lngLoop As Long > Dim rngCol

Re: $$Excel-Macros$$ Remove Punctuation

ok ok. thats true, any thanks Anil Ji, Thanks & Regards, *Deba Ranjan P* On Wed, Jun 27, 2012 at 4:02 PM, Anil Gawli wrote: > it is possible but how u hold the values and replace it with others, for > that u have to save the value as temp and then replace it. > > Regar

Re: $$Excel-Macros$$ Remove Punctuation

Thanks Anil Ji, its superb working. Anil Ji, Is there any option for removing all the punctuation mark at a time with code and without userform help ? Thanks & Regards, *Deba Ranjan P* On Wed, Jun 27, 2012 at 3:36 PM, Anil Gawli wrote: > sorry for wrong attachment > jus

Re: $$Excel-Macros$$ Remove Punctuation

Anil Ji, That is working fine , Thanks.. Ok is there any coding for direct remove without user form. --- i mean writing coding and run. Thanks again. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 27, 2012 at 3:15 PM, Anil Gawli wrote: > pls find attached sheet >

Re: $$Excel-Macros$$ Seems Like comments but Not

Thanks all. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 18, 2012 at 11:27 PM, NOORAIN ANSARI wrote: > Dear Deba Ranjan, > > See attachment, we can create it from here. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com &g

Re: $$Excel-Macros$$ Adding Auto Rows

Thanks Rajan ji, Is working fine. Dear Don ji, exactly the same you expect, i mean it should copy and past in the below row and correspondingly the same for other which is unique. Thanks all. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 18, 2012 at 9:02 PM, dguillett1 w

$$Excel-Macros$$ Adding Auto Rows

there any macros or Formula to add row. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not

Re: $$Excel-Macros$$ Vba Password recovery & excel password remover

OK No issue broi was not ware of that. Thanks Thanks & Regards, *Deba Ranjan P* On Fri, Jun 15, 2012 at 10:38 AM, NOORAIN ANSARI wrote: > Hi Deba brother.. > > As per our forum rule, We can't share this type of information. > > Please read rule No. 3 >

Re: $$Excel-Macros$$ conditional formatting

Thanks rajan bro. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 6:41 PM, Rajan_Verma wrote: > See the attached file > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From

Re: $$Excel-Macros$$ Sheet Requirements

Thanks man.. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 6:04 PM, dguillett1 wrote: > Sorry, I deleted it. You really need to try harder > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > >

Re: $$Excel-Macros$$ Sheet Requirements

Thanks Anil Ji,.very thanks and the other members. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 5:54 PM, Anil Gawli wrote: > see the attached sheet > > On Wed, Jun 13, 2012 at 5:43 PM, Deba Ranjan wrote: > >> Thanks... Don

Re: $$Excel-Macros$$ Sheet Requirements

Thanks... Don bro, But still i have confusion on the coding. can you please share with the attachment ? i hope i will get more ideas on attached. thanks for that. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 5:30 PM, dguillett1 wrote: >

Re: $$Excel-Macros$$ conditional formatting

Thanks bro.. awesome. Thnks again Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 4:49 PM, NOORAIN ANSARI wrote: > Dear Deba, > > See attached Sheet. > > for Red you use.. > > =Hour($A1)>4 > > and for yellow > > =Hour($A1)<4 &g

$$Excel-Macros$$ conditional formatting

). Please solve Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attentio

Re: $$Excel-Macros$$ Sheet Requirements

Thanks... Thanks & Regards, *Deba Ranjan P* On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay wrote: > Hi Dear, > > It happens with everybody specially when someone tries to learn new > concepts of IT or any other topic. So keep going and this group is go

Re: $$Excel-Macros$$ Sheet Requirements

, Any way thanks for suggesting that. i will keep trying. i have very confusion in coding when i go trough the books. Like String, long etc. Thanks & Regards, *Deba Ranjan P* On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 wrote: > Forgive me but as I rec

$$Excel-Macros$$ Sheet Requirements

Dear Experts, i have attached a file which contains many sheets. in every sheets there contains data. i want a button which on clicking the whole sheet data consolidated. Please find the attached. thanks... Thanks & Regards, *Deba Ranjan P* -- F

Re: $$Excel-Macros$$ Concatenate Problem.

Thanks group for wonderful Ideas. thank you very much.. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:46 PM, Ahmed Honest wrote: > Rajan, > > 100% agreed, formulae of all Ms Excel can't be compare to the versality of > VBA. My solution is

Re: $$Excel-Macros$$ Concatenate Problem.

Ahmed ji..i think the file is already attached in this group. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:26 PM, Ahmed Honest wrote: > . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Concatenate Problem.

Thanks.. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:22 PM, Rajan_Verma wrote: > The sorter one: No Loops Required > > ** ** > > *If your data is Vertical then use this* > > ** ** > > Function ConcatAll(rngRange As Range)

Re: $$Excel-Macros$$ Concatenate Problem.

Thanks .very Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI wrote: > See attached sheet. > > > On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI > wrote: > >> Dear Deba, >> >> Please try below U

$$Excel-Macros$$ Concatenate Problem.

Dear experts, Please find the attached file. There is 568 names listed in A2, I want the whole names should come in one single cell with comma. Please.. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 1) Use con

Re: $$Excel-Macros$$ Introduce Yourself !!

Dear Beloved groups, Sorry for the delay, Hi, i am Deba ranjan, Basically i am from Assam and i am *20* years old. i started currently working in organization for past 1 years as back-end Team operation in Chennai and i am pursuing my b.com in part time. i am very very much love with excel

Re: $$Excel-Macros$$ Edit Cell

Thanks Lovely members. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 8:01 PM, dguillett1 wrote: > Unlock all you want to allow > lock that one > protect sheet > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.

Re: $$Excel-Macros$$ Edit Cell

Yes, Yes, its superb working thanks for the guides...Tnks Hilary & Noorain and Rest of this members. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:52 PM, hilary lomotey wrote: > select all the cells, press ctrl +1 go to the protection tab, uncheck

Re: $$Excel-Macros$$ Edit Cell

Thanks , It is possible for A2:A7 range including with E3, i mean for E3, its fine, It s possible for A2 to A7 also the same lock. Please sir, Explain in details how you did !!! Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:47 PM, NOORAIN ANSARI wrote: >

Re: $$Excel-Macros$$ Edit Cell

Sir, The file you have attached is the same that i have attached. Please kindly check. Thanks for the same. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI wrote: > Dear Deba, > > Please see attached sheet, > > If you have any

$$Excel-Macros$$ Edit Cell

Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the E3 cell should not be able to edit, Rest can be edit. Please see the attached. thank you. Thanks & Regards, *Deba Ranjan P* -- FORUM R

Re: $$Excel-Macros$$ Clock Chart (Excellent)

Thanks Bhai. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 6:32 PM, NOORAIN ANSARI wrote: > See attachment > > > On Fri, Jun 8, 2012 at 6:30 PM, Deba Ranjan wrote: > >> i am sorry sir, i can't get you please. >> >> >>

Re: $$Excel-Macros$$ Clock Chart (Excellent)

i am sorry sir, i can't get you please. On Fri, Jun 8, 2012 at 6:29 PM, NOORAIN ANSARI wrote: > Dear Deba, > > Please check here.. > > > > > On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote: > >> Its a awesome design. Can you please tell me , in t

Re: $$Excel-Macros$$ Clock Chart (Excellent)

Thanks you Dear Anil. thanks. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 5:48 PM, Anil Gawli wrote: > Dear Deba > > Goto Options, Advanced and there u'll find Show Sheet Tabs checkbox option > Regards > Gawli Anil > > On Fri, Jun 8, 2012

Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....

i agree with Mangesh. its seems very critical abuse word. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 4:50 PM, Mangesh Dayne wrote: > What do u say so... > It shouldn't happen > > > On Fri, Jun 8, 2012 at 4:49 PM, Viktorija Zukauskiene <

Re: $$Excel-Macros$$ Clock Chart (Excellent)

Its a awesome design. Can you please tell me , in the sheet, we are unable to view the sheets, i mean, Even we insert sheet, we are unable to see the sheet. Please explain me on this. Its make me very interesting parts. !! Thanks & Regards, *Deba Ranjan P* On Thu, Jun 7, 201

Re: $$Excel-Macros$$ Date format calculation

Thanks its working...thank you very much. Thanks & Regards, *Deba Ranjan P* On Tue, Jun 5, 2012 at 7:11 AM, David Grugeon wrote: > You may need a formula like > =LEFT(A1,FIND(":",A1)-1)/24+MID(A1,FIND(":",A1)+1,FIND(":",A1,FIND(":",A1)

Re: $$Excel-Macros$$ Date format calculation

Sir, i mean the times are like wise: hour, minute, second It can be 2000 hours can be 300 mins can be 200 seconds... Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 6:29 PM, Rajan_Verma wrote: > But how can second be 64? > > ** ** > &g

Re: $$Excel-Macros$$ Date format calculation

Dear Asa, Can you please explain in the sheet itself. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 1:22 PM, Asa Rossoff wrote: > Hi Deba, > > ** ** > > *For the Login Time column,* the reason SUM is not working properly is > that many of the

Re: $$Excel-Macros$$ Date format calculation

Please have a look on this Dear Experts. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 9:27 AM, Deba Ranjan wrote: > Yes...exactly. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Sun, Jun 3, 2012 at 1:28 PM, Raj

Re: $$Excel-Macros$$ Date format calculation

Yes...exactly. Thanks & Regards, *Deba Ranjan P* On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma wrote: > Hi > > What do you mean by this Login time : “879:55:64” is it 879 Hour 55 > Minute and 64 Seconds?? > > ** ** > > * * > > *Regards* >

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

Congratulations Rajan , Awesome Job Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 8:03 AM, xlstime wrote: > Congratulations Rajan > > On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Rajan Verma

$$Excel-Macros$$ Date format calculation

Dear Experts, i have again got confusion in date and time format calculation, Please see the attached file, i have elaborate the details in the sheet. Please help in calculating the problem. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

Dear Rajan, thats a very great vb code that you have shared to us, Thank you ver much. can you please tell me, if i want to send more then 1 person, what i need to do. i have to insert comma after every mail ID ? Thanks & Regards, *Deba Ranjan P* On Wed, May 30, 2012 at 9:1

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

Sir, i dont have any tool for breaking password. If you have any set up you can let me know, or else, Please share the file without password. thank you Rajan Sir. Thanks & Regards, *Deba Ranjan P* On Tue, May 29, 2012 at 6:05 PM, Rajan_Verma wrote: > ** ** > > Sorry

Re: $$Excel-Macros$$ MACRO

Noorain Sir, Can you please send me the file too in my mail ID, the file that you share with Mangesh. mail:- drdeva...@gmail.com Thanks & Regards, *Deba Ranjan P* On Wed, May 30, 2012 at 8:25 AM, NOORAIN ANSARI wrote: > Hi Joseph,aruna,lupinskip and anjali, > > I

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

Great expertise Noorain sir, . can we create formula without using vb macors for this extractions ? Thanks & Regards, *Deba Ranjan P* On Tue, May 29, 2012 at 11:09 AM, Ashish Bhalara wrote: > Its a great macro Noorainji, Thanks. > > Ashish Bhalara > > >

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

... Thanks & Regards, *Deba Ranjan P* On Mon, May 28, 2012 at 7:12 PM, Rajan_Verma wrote: > Hi, > > ** ** > > If your data in Alphanumeric value in *A1* then use it in *B1* > > ** ** > > * > =IFERROR(SUM(INT(MID(A1,LARGE(--ISNUMBER(INT(MID(A1,RO

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

& Regards, *Deba Ranjan P* On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma wrote: > Just give the front end. > how you want to attached the file.. where you will put the Email ID and so > on > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91

Re: $$Excel-Macros$$ Time Mean calculation

Thanks. Thanks & Regards, *Deba Ranjan P* On Fri, May 25, 2012 at 4:37 PM, NOORAIN ANSARI wrote: > Deba, I am sending Userform Query ASAP. > > > On Fri, May 25, 2012 at 4:36 PM, Deba Ranjan wrote: > >> Thank you very much Noorain sir,Its absolutely w

Re: $$Excel-Macros$$ Time Mean calculation

Thank you very much Noorain sir,Its absolutely working. -- what about the userform that i posted ? Thanks & Regards, *Deba Ranjan P* On Fri, May 25, 2012 at 4:30 PM, NOORAIN ANSARI wrote: > Dear Deba, > > Please see attached workbook... > > --

$$Excel-Macros$$ Time Mean calculation

Dear Experts, i have some doubt in mean time difference calculation. i have provided my query in attached worksheet. Please open the sheet, i have got some error and i marked it as red color. Thank you. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BA

Re: $$Excel-Macros$$ Automatic token numbers

Thanks . Thanks & Regards, *Deba Ranjan P* On Wed, May 23, 2012 at 5:05 PM, NOORAIN ANSARI wrote: > *=IF(B3<>"","LD000"&SUBTOTAL(3,$B$3:B3),"")* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Automatic token numbers

*Dear Anil and Experts, The formula you have given was absolutely correct. Thanks once again for the same. Thank you very very much.* Thanks & Regards, Deba Ranjan P On Tue, May 22, 2012 at 3:53 PM, hilary lomotey wrote: > Just add =if(b3<>"","LD000&

Re: $$Excel-Macros$$ Automatic token numbers

& Regards, Deba Ranjan P On Tue, May 22, 2012 at 2:54 PM, Anil Gawli wrote: > See the attached Sheet. > > > On Tue, May 22, 2012 at 12:32 PM, Deba Ranjan wrote: > >> *Dear Experts and Sir, >> >> >> *While on the data entry form in excel, for

Re: $$Excel-Macros$$ Form tracker and new base-1

and suggestions. * Thanks & Regards, Deba Ranjan P On Mon, May 21, 2012 at 11:37 AM, Anil Gawli wrote: > > See the attached File > On Mon, May 21, 2012 at 10:46 AM, Deba Ranjan wrote: > >> *Hi experts, >> >> Please find the attached file. There you

Re: $$Excel-Macros$$ Form tracker and new base

; Regards, Deba Ranjan P On Fri, May 18, 2012 at 5:48 PM, Anil Gawli wrote: > It might possible that the macro will not assigned to it > kindly assigned to it and run it. > updated file is attached .FYI > > On Fri, May 18, 2012 at 5:43 PM, Deba Ranjan

Re: $$Excel-Macros$$ Form tracker and new base

so much so much Anil and all the experts. * Thanks & Regards, Deba Ranjan P On Fri, May 18, 2012 at 3:23 PM, Anil Gawli wrote: > At my end it is working fine. > > > > > > > > > > On Fri, May 18, 2012 at 3:00 PM, Deba Ranjan wrote: > >> *D

Re: $$Excel-Macros$$ Form tracker and new base

customer should reflect on the form itself. I think you have got my point !. Please try sir, thanks * Thanks & Regards, Deba Ranjan P On Fri, May 18, 2012 at 2:32 PM, Anil Gawli wrote: > Latest file Attached > > > On Fri, May 18, 2012 at 9:54 AM, Deba Ranjan wrote: &g

Fwd: $$Excel-Macros$$ Form tracker and new base

*Dear Expert, Please anyone help me on my query, the query is in the attached file. i have been looking on this and trying for past couple of days back. thank you experts. * Thanks & Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan Date: Wed,

Re: $$Excel-Macros$$ Form tracker and new base

*Dear Anil, Thank you so so much for that. any way when you get time please do it. But the attached file that you have send is not at all working properly for customer name too. please find it. * Thanks & Regards, Deba Ranjan P On Wed, May 16, 2012 at 3:51 PM, Anil Gawli wrote:

Fwd: $$Excel-Macros$$ Form tracker and new base

. * Thanks & Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan Date: Wed, May 16, 2012 at 12:24 PM Subject: Re: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com *Hi Anil, It was a awesome attempt, and done it, thanks for

Re: $$Excel-Macros$$ Form tracker and new base

. * Thanks & Regards, Deba Ranjan P On Wed, May 16, 2012 at 11:41 AM, Anil Gawli wrote: > > > On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: > >> *Dear Experts, Waiting for the revert with solution. Thanks >> * >> >>

Fwd: $$Excel-Macros$$ Form tracker and new base

*Dear Experts, Waiting for the revert with solution. Thanks * Thanks & Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan Date: Tue, May 15, 2012 at 10:22 AM Subject: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com *Hi Exp

$$Excel-Macros$$ Form tracker and new base

*Hi Experts, Very good morning, Dear groups and experts, i have some data base which need to be created in userform, i have explained in the attached file. Please help me sort out this problem. Thanks in advance. * Thanks & Regards,* * *Deba Ranjan P*** -- FORUM RULES (986+ mem

Re: $$Excel-Macros$$ Office stock

Hi Smitha, Please try this too, its good working. below>>!! * =IF(R[-4]C="","",VLOOKUP(R[-4]C,'Stock n cnsmpn-May 2012'!C[-2]:C[2],5,0)) * Thanks & Regards,* * *Deba Ranjan P*** On Thu, May 10, 2012 at 7:54 AM, NOORAIN ANSARI wrote: > Hi Smit

Re: $$Excel-Macros$$ Graph formatting condition

*Thank you so much *Don Guillett. very thanks. Thanks & Regards,* * *Deba Ranjan P*** On Wed, May 9, 2012 at 7:41 PM, dguillett1 wrote: > Modified graph . You can make other changes to graph > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille..

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

*Congrats Rajan Shahab, And Thanks every member of Excel forum who have devoted their times in analytical for solving problem and vice versa. * Thanks & Regards,* * *Deba Ranjan P*** On Fri, May 4, 2012 at 2:45 PM, Ankit Agrawal wrote: > Congratulation Rajan and other excel&#x

Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

*Hi *Vijay, You can you try formula, it will help you out.:- For Date diffrence:- =DATEDIF(A2,(B2),"md") For Month diffrence :- =DATEDIF(A2,(B2),"ym") For Year diffrence :- =DATEDIF(A2,(B2),"y") Thanks & Regards,* * *Deba Ranjan P*** On Fri, May 4

$$Excel-Macros$$ Time calculation sheet

*Hi Experts, I have attached the file which i am unable to calculate the time sheet. please help me out to sort out. thanks in advance. * Thanks & Regards,* * *Deba Ranjan P*** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Macro coding

*Thanks.. i will try to find out myself . Thanks once again. * Thanks & Regards,* * *Deba Ranjan P*** On Sat, Apr 28, 2012 at 5:42 PM, Rajan_Verma wrote: > These Codes are written by a Human not by machine .. you need to learn how > to write the Computer instruction, you ca

  1   2   >