Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-08-24 Thread Manoj Kumar
Please add my number in what'sup group 9910243729 Thanks Manoj On Thu, Aug 11, 2016 at 11:24 AM, Manoj Garg wrote: > Please add 9927199217 > > On Aug 11, 2016 8:51 AM, "Kishore P V K" wrote: > >> Please add 9348264783 >> >> On Wed, Aug 10, 2016 at 11:50 PM, mukesh kumar > > wrote: >> >>> Please

$$Excel-Macros$$ want to learn excel & VBA

2014-11-30 Thread Manoj Kumar
Dear Champs I want to learn excel & VBA so can you send me the notes for the same. Thanks & Regards Manoj Kumar -- 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/disc

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2013-12-12 Thread manoj kumar
> Dear members, > I want to know the excel formula's becoz write now i am making the > excel database if you have the information plz send me the excel > formula's.on my email id manoj3...@gmail.com > > Thanks for your active participation in the group. Feel free to write > bac

Re: $$Excel-Macros$$ Paste special using skip blank

2013-10-19 Thread Manoj Kumar
Hi Ravi Thanks you so much. i got it. Thanks & Regards Manoj Kumar On Sat, Oct 19, 2013 at 1:09 PM, Ravi Kumar wrote: > Dear friend, > > ** ** > > ** ** > > I had also attached the screen shot of excel shortcut. Please see the > attached file. > >

RE: $$Excel-Macros$$ Paste special using skip blank

2013-10-19 Thread Manoj Kumar
ants() > > Range("A1:A8").SpecialCells(xlCellTypeConstants, 2).Copy Range("C1")** > ** > > End Sub > > ** ** > > ** ** > > * * > > *Warm Regards,* > > *Ravi Kumar.* > > ** ** > > *From:* excel-macros@googlegroups.com [mai

$$Excel-Macros$$ Paste special using skip blank

2013-10-18 Thread Manoj Kumar
Hi Team Can anyone suggest me that. How can I paste data using skip blank. That all the blank cell ignore and data comes in series. Please help me on this. Thanks Manoj -- 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 pa

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

2013-10-08 Thread Manoj Kumar Singh
On Thursday, May 10, 2012 4:19:25 AM UTC-7, NOORAIN ANSARI wrote: > > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL Server. > > If any one have this type of question and answers, Kindly share with group. > > > Thanks ! it really Help to me.

Re: $$Excel-Macros$$ Total Count of Unique ID's

2013-09-23 Thread Manoj Kumar
Try the below formula: =SUM(1/COUNTIF(A2:A595,A2:A595)) After entering this formula, you must press *Ctrl-Shift-Enter.* It will give the desired result*. * Best, Manoj Kumar* * On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar wrote: > > > Dear Seniors, > > > I want total co

$$Excel-Macros$$ Sum between two different data.

2013-08-21 Thread Manoj Kumar
Please help me. I have a data like details mention below. xxx a b c jan2 3 1 feb1 1 2 jan2 2 1 jan4 1 2 mar 1 3 1 I have a able xxx Jan Feb Mar a 81 1 b

$$Excel-Macros$$ Different Validateion

2013-07-15 Thread Manoj Kumar
Dear Expert, In validation we select a range and put the text but i want a different validation. We can put any value in a cell but when we put "No" it will be not consider. Regard Manoj -- 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 of

Re: $$Excel-Macros$$ Error in Excel Report

2013-07-04 Thread Manoj Kumar
please see the example what i need On Thu, Jul 4, 2013 at 5:02 PM, De Premor wrote: > On cell C5, paste this =IF($B5=C$3,REPT("p",C$3),0) > > Rgds, > [dp] > Pada 04/07/2013 18:19, Manoj Kumar menulis: > > > > > > On Thu, Jul 4, 2013 at 4:47

Re: $$Excel-Macros$$ Error in Excel Report

2013-07-04 Thread Manoj Kumar
On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar wrote: > > Dear Expert, > > Please help to sove my Quiry file attached in mail. > > i need fill all data with "p" how many count in header. > > Regard > Manoj > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Error in Excel Report

2013-07-04 Thread Manoj Kumar
Dear Expert, Please help to sove my Quiry file attached in mail. i need fill all data with "p" how many count in header. Regard Manoj -- 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.fac

$$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-07 Thread Manoj Kumar
Dear Expert. please help to solve query. regd Manoj -- 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 concise, accurate thread titles. Poor t

Re: $$Excel-Macros$$ formula required

2013-01-13 Thread Manoj Kumar
Dear Prashant, Please use this.. SUMPRODUCT(($D$2:$D$5=A7)*($G$2:$M$5)) Regard Manoj On Mon, Jan 14, 2013 at 12:19 PM, Prashant Pawle wrote: > Dear Team, > > Need a formula to look up a filed & give sum of figure , sample file > attached > > Regards, > > Prashant > > -- > Join official Faceboo

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

2013-01-02 Thread Manoj Kumar
>> Frank Web Hosts >> Your affordable & quality web hosts >> http://frankhost.net >> >> Phone: +256 752 954 723 >> >> For every domain you purchase from us, we host your website for the first >> 3 months for FREE! >> >> Manoj Kumar > wro

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

2013-01-01 Thread Manoj Kumar
india so i cut the >>> >last 12 digit including space and concat that with first string that i >>> got >>> >from left. >>> > >>> >Regards >>> >Prince >>> > >>> >On Wednesday, January 2, 201

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

2013-01-01 Thread Manoj Kumar
t; regards > Prince > > On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: >> >> Hi, >> >> Is there any way out for removing spaces between numbers only. Spaces >> between the text should be removed. >> >> For example. >>

$$Excel-Macros$$ how to remove space between numbers only.

2013-01-01 Thread Manoj Kumar
Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join

Re: $$Excel-Macros$$ convert excel file to text file

2012-12-07 Thread Manoj Kumar
l 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 can.” - John Wesley > - > > > > > >

$$Excel-Macros$$ convert excel file to text file

2012-12-06 Thread Manoj Kumar
Hi Expert I want to convert many excel file in text format. So is this possible to convert file without open a file or save as options. becouse i have to consolidated many excel file in one excel so is this any suggestion so please help Thanks Manoj -- Join official Facebook page of this forum

Re: $$Excel-Macros$$ Sum required from different sheet..

2012-11-07 Thread Manoj Kumar
Sorry for delay... yes Pravin.. On Wed, Nov 7, 2012 at 6:42 PM, Pravin Gunjal wrote: > *you mean to say that the formula should be changed automatically, > whenever you create a new sheet? > * > > -- Forwarded message -- > From: Manoj Kumar > Date: Wed, N

Re: $$Excel-Macros$$ Sum required from different sheet..

2012-11-07 Thread Manoj Kumar
Hi, Anybody please help me... Regard Manoj On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar wrote: > Dear Expert, > > Please help me ...when I add new sheet ("3") it should be change like > that.."SUM('1:3'!B2)" > > Regard > Manoj > >

Re: $$Excel-Macros$$ inquiry

2012-11-06 Thread Manoj Kumar
I found it... "Me.Pictures.Visible = False" change false to true... u can see all picture one by one.. Regard Manoj On Tue, Nov 6, 2012 at 1:50 PM, DELIN FRANCIS wrote: > Dear Anil, > > if add more names then how can add more pics > please tell me the way boss > > regards > > *Delin.F* > >

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

2012-11-03 Thread Manoj Kumar
May be this will work for you. Thanks shekar. It was very helpful to me. On Sunday, 4 November 2012 05:51:21 UTC+5:30, shekar wrote: > > edit a cell and press enter > > > On 3 November 2012 22:10, Rohan Young >wrote: > >> hi raja, >> >> its not working >> >> regds >> >> >> >> On Sat, Nov 3, 2

$$Excel-Macros$$ Recover Excel File

2012-10-31 Thread Manoj Kumar
Dear Expert, Please tell me any body how can i Restore my excel file after save... I save my excel file and closed. can i get old.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) U

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

2012-10-26 Thread Manoj Kumar
hello,, formula is wrong. On Fri, Oct 26, 2012 at 2:30 PM, Manoj Kumar wrote: > Thanks yaar.. > > it realy wonderful, it help me to make report so easy.. > > > On Fri, Oct 26, 2012 at 2:16 PM, Vabz wrote: > >> PFA >> >> Cheers//Vabs >> >&g

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

2012-10-26 Thread Manoj Kumar
Thanks yaar.. it realy wonderful, it help me to make report so easy.. On Fri, Oct 26, 2012 at 2:16 PM, Vabz wrote: > PFA > > Cheers//Vabs > > > On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Expert, >> >> Please he

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

2012-10-26 Thread Manoj Kumar
Dear Amresh, I need total sum of xx sale.. on 1st oct... Regard Manoj On Fri, Oct 26, 2012 at 1:46 PM, Amresh Maurya wrote: > PFA. > > On Fri, Oct 26, 2012 at 1:04 PM, Manoj Kumar > wrote: > > File allready attached... > > > > > > On Fri, Oct 26, 2012 at

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

2012-10-26 Thread Manoj Kumar
File allready attached... On Fri, Oct 26, 2012 at 1:02 PM, Amresh Maurya wrote: > send me attachment. > > On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar > wrote: > > Anybody Please help me > > > > On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar > wrote: > &

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

2012-10-26 Thread Manoj Kumar
Anybody Please help me On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar wrote: > Dear Expert, > > Please help me to get the currect ans with attached file.. > > > Regard > Manoj > -- > Join official facebook page of this forum @ > https://www.facebook.com/disc

$$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

2012-10-25 Thread Manoj Kumar
Dear Expert, Please help me to get the currect ans with attached file.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Re: Text need in different collume

2012-10-23 Thread Manoj Kumar
Please confirm it is possible without macro Regard Manoj On Tue, Oct 23, 2012 at 12:17 PM, Vabz wrote: > > Hi > > PFA Att > > It contains various methods.. > > > Chherz//Vabz > > On Tuesday, October 23, 2012 11:19:06 AM UTC+5:30, Manoj Kumar wrote: >>

$$Excel-Macros$$ Re: Text need in different collume

2012-10-22 Thread Manoj Kumar
Dear Expert, > > I have data witch has Text and Number i want to do saperate text and > number in next collume. > > man25oj kuma112r ro444ha25n 25s26on7 > > > > Regard > Manoj > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members

Re: $$Excel-Macros$$ Re: Good Laptop to Buy..

2012-10-22 Thread Manoj Kumar
Hi, U Can buy Acer Aspire S3-I5.. Regard Manoj On Mon, Oct 22, 2012 at 4:49 PM, wrote: > ** > Wooww! Gud input.. > > > Cheers//Vabs > Sent on my BlackBerry® from Vodafone > -- > *From: * CoRe > *Date: *Mon, 22 Oct 2012 04:17:49 -0700 (PDT) > *To: * > *Cc: * > *Subj

Re: $$Excel-Macros$$ Abc in a column

2012-10-21 Thread Manoj Kumar
Hi it's really work thanks a lots experts. Regards Manoj On Oct 20, 2012 10:05 PM, "Manoj Kumar" wrote: > Hi expert > > I want ABC in a column. So can u help me on this. In a column ABC from a > to z. > > Thanks > Manoj > > -- > Join o

$$Excel-Macros$$ Abc in a column

2012-10-20 Thread Manoj Kumar
Hi expert I want ABC in a column. So can u help me on this. In a column ABC from a to z. Thanks Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor t

Re: $$Excel-Macros$$ Re: Need formula to update status

2012-10-18 Thread Manoj Kumar
Thanks On Thu, Oct 18, 2012 at 1:05 PM, Vabz wrote: > Hi > > PFA.. > Cheers.. > Rgds//Vabs > On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote: > >> >> >> -- Forwarded message -- >> From: Manoj Kumar >> D

$$Excel-Macros$$ Fwd: Need formula to update status

2012-10-18 Thread Manoj Kumar
-- Forwarded message -- From: Manoj Kumar Date: Thu, Oct 18, 2012 at 12:29 PM Subject: Need formula to update status To: excelvbacli...@googlegroups.com Dear Expert, Please Find the attachment.. Please provide me a formula to update status in coll "F" Regard Manoj

$$Excel-Macros$$ Hard to find Status for me...

2012-10-17 Thread Manoj Kumar
Dear Expert. Please help me.. File attached below.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent

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

2012-10-14 Thread Manoj Kumar
Hi, This is manoj kumar from new delhi.. I am add my new id on this group.. Regard Manoj On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of excel Fans! > >

RE: $$Excel-Macros$$ Automation in excel

2012-10-12 Thread Manoj Kumar
Waiting for reply On Oct 10, 2012 11:52 PM, "Manoj Kumar" wrote: > Actually I don't know about the coding in vba where I can learn coding for > vba. I know only record macro. I want to do coding in my way. What I want > I get it from my data. > > Thanks >

RE: $$Excel-Macros$$ Automation in excel

2012-10-10 Thread Manoj Kumar
und knowledge about Excel VBA , some of them are below :* > > * * > > *This Forum as well **J*** > > *www.ExcelFox.Com* > > *www.excelpoweruser.wordpress.com* > > *http://excelvbaprogramming.wordpress.com/*<http://excelvbaprogramming.wordpress.com/> > > > *

$$Excel-Macros$$ Automation in excel

2012-10-10 Thread Manoj Kumar
Hi experts I want to learn automation in excel first of all tell me. What is automation. how I use in excel. Please give any notes and suggestions to learn. Waiting for reply. Thanks Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+

Re: $$Excel-Macros$$ St id Reqd on Max Date

2012-10-05 Thread Manoj Kumar
sistance. > > --- > > <><><><><><> > > *Ms.Exl.Learner* > <><><><><><> > > > > > > > > On Fri, Oct 5, 2012 at 11:51 AM, Manoj Kumar > wrote: > >> Dear Viper, >> >

Re: $$Excel-Macros$$ St id Reqd on Max Date

2012-10-04 Thread Manoj Kumar
Dear Viper, Please can you solve it without erry..please help.. On Fri, Oct 5, 2012 at 11:47 AM, The Viper wrote: > pfa > > > On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar > wrote: > >> Dear Expert, >> >> >> Request you to kindly help me on th

$$Excel-Macros$$ St id Reqd on Max Date

2012-10-04 Thread Manoj Kumar
Dear Expert, Request you to kindly help me on this matter... Please find the attachment.. I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show 9564 Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ me

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

2012-10-03 Thread Manoj Kumar
you can, > As long as ever you can.” - John Wesley > *----- > > > -- > *From:* Manoj Kumar > *To:* excel-macros@googlegroups.com > *Sent:* Wed, October 3, 2012 7:34:09 AM > > *Subject:* Re: $$Excel-Macro

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

2012-10-03 Thread Manoj Kumar
e you can, > As long as ever you can.” - John Wesley > *----- > > > -- > *From:* Manoj Kumar > *To:* excel-macros@googlegroups.com > *Sent:* Wed, October 3, 2012 3:52:31 AM > *Subject:* Re: $$Excel-Macros$$ Re: Ex

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

2012-10-03 Thread Manoj Kumar
Dear vabz, Thanks. but it's not working.. Regard Manoj On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: > Hi > > PFA Files.. > > Cheers.. > > Rgds//Vabs > > On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Export, &

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

2012-10-03 Thread Manoj Kumar
day, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Export, >> >> I have one folder "x" witch has contain mail's, every mail contain an >> excel file, >> i want to copy all excel file from folder "x" to onther folde

$$Excel-Macros$$ Excel Macro Reqd for Folder to Folder

2012-10-03 Thread Manoj Kumar
Dear Export, I have one folder "x" witch has contain mail's, every mail contain an excel file, i want to copy all excel file from folder "x" to onther folder with different name.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1

Re: $$Excel-Macros$$ Presentation Vba Code

2012-09-27 Thread Manoj Kumar
anybody please help me. On Thu, Sep 27, 2012 at 11:58 AM, Manoj Kumar wrote: > Dear Expert, > > i am making Power point presentation i have a macro to do same size of > all pitcher. but all pitcher showing in different aria. > > i want to do all picture in center of slide.

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

2012-09-25 Thread Manoj Kumar
cells. > > > > Other solution is use "Data Validation". It will not give you auto > complete option. It will give you dropdown for cell and user have to select > value from drop down. > > > > Regards, > > > > Swapnil.

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

2012-09-25 Thread Manoj Kumar
e you dropdown for cell and user have to select > value from drop down. > > Regards, > > Swapnil. > > On Tue, Sep 25, 2012 at 5:16 PM, Manoj Kumar wrote: > >> Not able to understand clearly. can you please the solution in the >> attached file. >> >>

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

2012-09-25 Thread Manoj Kumar
Tuesday, September 25, 2012 3:24:58 PM UTC+5:30, Manoj Kumar wrote: >> >> Hi, >> >> Is there an way to autocomplete the words from the custom list. When >> someone type the first word, the word should be automatically filled and >> display the rest word in

$$Excel-Macros$$ Need Help in AutoComplete with Custom List

2012-09-25 Thread Manoj Kumar
Hi, Is there an way to autocomplete the words from the custom list. When someone type the first word, the word should be automatically filled and display the rest word in should be in selection. Regards, Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexc

Re: $$Excel-Macros$$ Macro required for powerpoint...

2012-09-24 Thread Manoj Kumar
my requirement is pending please help... On Mon, Sep 24, 2012 at 12:34 PM, Manoj Kumar wrote: > Dear Expert, > > i am making my presentation, i use macro to do same size of all picture > after i want all picture show in center of slide... > > > Please help me.. > &g

Re: $$Excel-Macros$$ subtitute function infirmation required

2012-09-18 Thread Manoj Kumar
ep Singh > wrote: > >> >> Hi see below links: >> >> >> http://office.microsoft.com/en-us/excel-help/substitute-function-HP010062578.aspx >> >> >> http://www.techonthenet.com/excel/formulas/substitute.php >> >> Regards, >> Kuldee

$$Excel-Macros$$ subtitute function infirmation required

2012-09-18 Thread Manoj Kumar
Dear Expert, i want know about subtitute. anybody tell me about subtitute function.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ help on Power point

2012-09-10 Thread Manoj Kumar
Dear Expert. Please tell me how can i re-size all slide in one time.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread Manoj Kumar
Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote: > Hi Friends, > > I need your help to divide the string into three parts. > The description and sample is given below : > [image: Inline image 1] > Waiting for your response. > > Thank

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Manoj Kumar
d output in >>> yellow) (looking Minmum marks on Row numbers 10) F10:L10. >>> If anyone got marks less than minimum marks then show failed. >>> >>> On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar >>> wrote: >>> >>>> Dear amar, >&g

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Manoj Kumar
j, > If failed minmum one subject then show failed (required output in yellow) > (looking Minmum marks on Row numbers 10) F10:L10. > If anyone got marks less than minimum marks then show failed. > > On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar wrote: > >> Dear amar, >>

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Manoj Kumar
Dear Amar, Please Use it... =IF(OR(F11<$F$10,G11<$G$10,H11<$H$10,I11<$I$10,J11<$J$10,K11<$K$10,L11<$L$10),"Failed","Pass") Regard Manoj On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar wrote: > Dear amar, > > Please tell what is passing marks...

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Manoj Kumar
Dear amar, Please tell what is passing marks... Regard Manoj On Wed, Sep 5, 2012 at 1:06 PM, amar takale wrote: > Hi All Experts, > Pl solved challenging formula for passing. > > Appreciate the help very much > > -- > Join official facebook page of this forum @ > https://www.facebook.com/disc

Re: $$Excel-Macros$$ How to count the items except repetition

2012-09-04 Thread Manoj Kumar
Dear Amresh, if we need unique agency and unique city how can we find... Regard Manoj On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya wrote: > Hi Pravin, > > find the attached solution. > > use this small formula. > > =COUNTA(C3:C39) > > Regards > Amresh > > > On Wed, Sep 5, 2012 at 10:50 AM, P

Re: $$Excel-Macros$$ Need Help

2012-09-03 Thread Manoj Kumar
ok kuldeep it's my mistake...cell N4 value is wrong... Regard Manoj On Mon, Sep 3, 2012 at 4:47 PM, Manoj Kumar wrote: > Dear Kuldeep, > > Amresh put formule in value but i change range in percentage it's working.. > > Regard > Manoj > > > On Mon, Sep

Re: $$Excel-Macros$$ Need Help

2012-09-03 Thread Manoj Kumar
Dear Kuldeep, Amresh put formule in value but i change range in percentage it's working.. Regard Manoj On Mon, Sep 3, 2012 at 4:45 PM, Manoj Kumar wrote: > Thanks for all > > Amresh's formula is ok for me.. > > Regard > manoj > > On Mon, Sep 3, 2012 at 4:3

Re: $$Excel-Macros$$ Need Help

2012-09-03 Thread Manoj Kumar
ls explain properly. > > Regards > Amresh > > > On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar wrote: > >> Dear Pravin, >> >> Please provide ans.. >> >> Regard >> Manoj >> >> >> On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal wr

Re: $$Excel-Macros$$ Need Help

2012-09-03 Thread Manoj Kumar
Dear Pravin, Please provide ans.. Regard Manoj On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal wrote: > Pl use a meaningful subject for immediate response on your issues > > > On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar wrote: > >> Dear Expert, >> >> Please

$$Excel-Macros$$ Need Help

2012-09-03 Thread Manoj Kumar
Dear Expert, Please help me to find rank in attached file.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

2012-09-03 Thread Manoj Kumar
Dear Rakesh, Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)* Regd Manoj On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma wrote: > Hi Experts, > > I need the actual remit amt agnst tracking on sheet2 when data was found > repeated on sheet1 with positive or nigative amt. > See the att

Re: $$Excel-Macros$$ Need help

2012-08-22 Thread Manoj Kumar
s.Count > > For i = 1 To EndCol > For j = 1 To Cells(2, i).Value > Cells(3 + j, i).Value = Cells(3, i).Value / Cells(2, i).Value > Next j > Next i > End Sub > > --- > Ms.Exl.Learner > --- > > > On Wed,

Re: $$Excel-Macros$$ Need help

2012-08-22 Thread Manoj Kumar
right if required. > > --- > Ms.Exl.Learner > --- > > > > On Wed, Aug 22, 2012 at 3:41 PM, Manoj Kumar > wrote: > >> i need the formula witch divide randomly A3, in cell A4 to A8 >> when i add A4 to A8 it show 200.. >> >> >>

Re: $$Excel-Macros$$ Need help

2012-08-22 Thread Manoj Kumar
unjal** > * > > > On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar > wrote: > >> Hi, >> >> Please help me to collect data in attached file.. >> >> >> Regard >> Manoj >> >> -- >> Join official facebook page of this forum @

$$Excel-Macros$$ Need help

2012-08-22 Thread Manoj Kumar
Hi, Please help me to collect data in attached file.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urg

Re: $$Excel-Macros$$ is that is sunday

2012-08-17 Thread Manoj Kumar
Hi Sundarvelan, Tri it.. =Text(a1,"ddd") Regard Manoj On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh wrote: > > Hi Sundarvelan, > > Please share a sample worksheet. > > Regards, > Kuldeep Singh > > > On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote: > >> Dear friends, >> >> I need to find

Re: $$Excel-Macros$$ Barcode

2012-08-09 Thread Manoj Kumar
Thanks dear Manoj On Aug 9, 2012 8:58 PM, "NOORAIN ANSARI" wrote: > Dear Manoj, > > One easy way to create bar code in excel > > Please visit here > http://strokescribe.com/en/create-barcode-excel-2007-activex.html > > On Thu, Aug 9, 2012 at 8:31 PM,

$$Excel-Macros$$ Barcode

2012-08-09 Thread Manoj Kumar
Dear group I want to make a barcode in excel. So i how make a barcode plz help me on this. Thanks Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor t

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

2012-08-03 Thread Manoj Kumar
*Cong Noorain! Ji* On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 wrote: > Good work! > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Ayush Jain > *Sent:* Friday, August 03, 2012 12:40 PM > *To:* excel-macros > *Subject:* $$Excel-Macros$$

$$Excel-Macros$$ Can anybody tell me about Indirect

2012-08-01 Thread Manoj Kumar
Hi, Please provide value from use Indirect.. Regard Manoj -- 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 attention

Re: $$Excel-Macros$$ conditional formatting

2012-07-25 Thread Manoj Kumar
Dear Smitha, Please find the attachment.. it will help you... Regard Manoj On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R wrote: > Hi, > > Please help in conditional formatting or use of if formula in the > following case. Excel attached. > > Closing Stock Verification stock required 1 1 if

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

2012-07-20 Thread Manoj Kumar
ok thanks On Fri, Jul 20, 2012 at 6:00 PM, NOORAIN ANSARI wrote: > Manoj Please change reference of range, As per need otherwise it will show > same result. > > > On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar > wrote: > >> Dear Noorain Ji, >> >> when

Re: $$Excel-Macros$$ Please provide me Excel 2003 & 2007 Short Key

2012-07-19 Thread Manoj Kumar
Thanks dear..€. On Thu, Jul 19, 2012 at 12:50 AM, NOORAIN ANSARI wrote: > Dear Manoj, > > Please find attached short cut for excel 2003,2007 and 2010. > > > On Thu, Jul 19, 2012 at 1:18 PM, Manoj Kumar > wrote: > >> Hi. >> >> Please provide me Excel 2

$$Excel-Macros$$ Please provide me Excel 2003 & 2007 Short Key

2012-07-19 Thread Manoj Kumar
Hi. Please provide me Excel 2003 & 2007 Short Key Regard Manoj -- -- 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 att

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread Manoj Kumar
ri.com > *Please* *Consider the environment. Please don't print this e-mail unless > you really need to.* > > > On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar > wrote: > >> Thanks Noorain Ji... >> >> >> On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI &g

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread Manoj Kumar
oorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar > wrote: > >> Dear Expert, >> >> Please help me to make report >> I have data in 1 sheet I want make report in sheet 2. >> >> Regard

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

2012-07-11 Thread Manoj Kumar
- >> =TRIM(IFERROR(LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3,1)),FIND(" >> ",RIGHT(A3,LEN(A3)-FIND(" ",A3,1,"")) >> Third word:- >> =RIGHT(A3,LEN(A3)-FIND("#",SUBSTITUTE(A3," >> ","#",LEN(A3)-LEN(S

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

2012-07-11 Thread Manoj Kumar
Thanks Noorain Ji... its working.. On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI wrote: > Dear Manoj, > > You can also try > =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found") > > On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar > wrote: >

Re: $$Excel-Macros$$ Index Formula Help

2012-07-01 Thread Manoj Kumar
Dear Sudhir Please find the attachment... Regard Manoj On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA wrote: > Dear All, > > Please look at attachment and help me. > > > thanking u > > Regards > > > Sudhir > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, ac

Re: $$Excel-Macros$$ Re: Help in Access

2012-06-29 Thread Manoj Kumar
ROM [Mar'12]; > union > SELECT distinct [Store ID] > FROM [Apr'12]; > union > SELECT distinct [Store ID] > FROM [May'12]; > > Regards > Prince Dubey. > > > > > On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote: >> >> De

Re: $$Excel-Macros$$ Re: Help in Access

2012-06-29 Thread Manoj Kumar
more > columns to it just by adding column name with , and the same column in > group by seperated by ,) > > Regards, > Lalit Mohan > > On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote: > >> Dear Experts, >> >> >> I have data in month wise da

Re: $$Excel-Macros$$ Excel Q & A

2012-06-20 Thread Manoj Kumar
Tkanks Krishna On Thu, Jun 21, 2012 at 12:09 PM, Maries wrote: > Nice Collection Thanks > > > On Wed, Jun 20, 2012 at 9:11 PM, Anil Gawli wrote: > >> Hi Krishna, >> >> Thanks 4 sharing ... >> >> Regards, >> Gawli Anil >> >> On Wed, Jun 20, 2012 at 8:35 PM, NOORAIN ANSARI > > wrot

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-17 Thread Manoj Kumar
Dear Avinash. Sub gg() For a = 1 To Sheets.Count Sheets(a).Activate Range("a1:dd5").Select Selection.Font.Bold = True Next End Sub Regard Manoj On Sun, Jun 17, 2012 at 11:39 PM, Avinash wrote: > Dear Experts, > > I have 1 workbook and there are 10 subsheets in that workbook. > i hav

Re: $$Excel-Macros$$ formula

2012-02-27 Thread Manoj Kumar
; >>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >>> >>> On Mon, Jan 16, 2012 at 11:51 PM, Manoj Kumar >>> wrote: >>> >>

$$Excel-Macros$$ formula

2012-01-16 Thread Manoj Kumar
Hello Members i want grow my excel formula knowledge. Please provide help and some notes . regards Manoj -- 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,

Re: $$Excel-Macros$$ Advance HappyChristmas

2011-12-25 Thread Manoj Kumar
merry christmas to all regards manoj On 12/23/11, sunil bn wrote: > Hi Friends, > Happy Merry Christmas In Advance...[?][?] > > -- > [image] > *Regards* > **Sunil B.N > ***9035858585 > [image] > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread ti

Re: $$Excel-Macros$$ MIS Opening

2011-12-20 Thread Manoj Kumar
Dear Sir, Thanks for your suggestion... Regards Manoj On Mon, Aug 29, 2011 at 7:10 PM, Manoj Kumar wrote: > Dear Sir, > > Please find the attached CV in this mail, and revert for the same ASAP. > > Regards > Manoj Kumar > > > On 8/25/11, Rahul Gandhi wrote: > &g

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

2011-10-11 Thread Manoj Kumar
See if this helps... Best, Manoj Kumar On Tue, Oct 11, 2011 at 1:14 PM, wrote: > Hi group, > > I have numeric data in column, each cell contains 5 to 6 numeric values but > are less 7 characters. > For example: 12345, > 385469. > > What I want is, what ever is the coun

  1   2   >