Re: $$Excel-Macros$$ lookup and sum

PFA On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS wrote: > Dear Expert, > > please help me out lookup and sum from sheet2 > > regards > LAKSHMAN > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ Using Small Formula

=lower(a1) A1 is your first value, then you can drag. On Monday, August 8, 2016, sourav devrani wrote: > A > > B > > C > > D > > How to small these values using Small Formula. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file

Please send your sample txt file as attachment. On Sun, Jul 31, 2016 at 6:46 PM, Puttu * wrote: > any help please :( > > On Sat, Jul 30, 2016 at 10:19 PM, Puttu * wrote: > >> Some one look and help on this please >> >> On Sat, Jul 30, 2016 at 12:16

Re: $$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA

Under Condition Formatting Tab, I have put 2 conditions. Please see under Conditional Format > Manage Rules Screenshot attached. On Sat, Jul 30, 2016 at 12:55 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Abhishek Jain, > > Many Many thank you for s

Re: $$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA

On Fri, Jul 29, 2016 at 4:13 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear All > > Please see the attachment and solve the problem . > > Sanjib > > > > -- > - > > -- > 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

Re: $$Excel-Macros$$ Need Excel Formula

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

Re: $$Excel-Macros$$ List of unique items

Please share an example workbook. On Fri, May 27, 2016 at 3:10 PM, Louis Omoya wrote: > Hi all? Thid is my first post in the group. I appreciate the support > online communities such as this offer. > > To my problem (which i have spent 2 days with no success). > > I have a

Re: $$Excel-Macros$$ diff between two dates in no of years,months and days

Plz see attached On Thu, May 26, 2016 at 5:26 PM, Vaibhav Joshi wrote: > Dear Experts > > I want to calculate gratuity for employees. > I want to know difference between date of joining & date of leaving in no > of years completed, no of months completed & no of days (in

Re: $$Excel-Macros$$ Search for several names in one cell

Please see attached On Wed, May 25, 2016 at 4:43 PM, André D'Avila wrote: > Hello Experts! > > I have a cell containing the info "Invoice Google Nr 123456789" and > another containing "Invoice Twitter Nr 1234567" for exemple. > > And I have a list of keywords that I

Re: $$Excel-Macros$$ help required

unt details line wise for the amount which needs to > be reconciled with my ledger account ensuring amount received for all lines > which mentioned. awaiting your help. > I would be having only amount column similar for both vendor & ledg so pls > help me out. > > Thanks, > Regards.

Re: $$Excel-Macros$$ Need - Formula weekly bonus

; 700-600=100 ( 100*1.5=150 ) > > Limit for 900 > > On 24 May 2016 at 12:27, Abhishek Jain <abhishek@gmail.com> wrote: > >> Please explain a bit more what exactly do you need. >> >> On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal <iqbal.hp...@gmail.com>

Re: $$Excel-Macros$$ Need - Formula weekly bonus

Please explain a bit more what exactly do you need. On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal wrote: > Hi, > > Anybody help me ! > > > > -- Forwarded message -- > From: Shaikh Iqbal > Date: 23 May 2016 at 19:55 > Subject:

Re: $$Excel-Macros$$ Hyperlink for multiple sheets

http://www.get-digital-help.com/2012/07/18/create-links-to-all-sheets-in-a-workbook/ On Fri, May 13, 2016 at 3:06 PM, Pravin Gunjal wrote: > Hi Friends, > > I have 48 sheets in a file and have one summary sheet in the beginning of > the same file. > > > > I would like to use

Re: $$Excel-Macros$$ extracting numbers

In all but one of your examples, the number you want to extract appears right after the text "_POV_" for which you can use the following formula - =MID(A1,FIND("_POV_",A1)+5,1) It will extract ONE character AFTER the text _POV_ HTH On Thu, May 5, 2016 at 11:24 AM, Izhar

Re: $$Excel-Macros$$ Plz Solve this

PFA. When you make other cells bold, be sure to hit the F9 button to re-calcualte. HTH On Thu, May 5, 2016 at 11:12 AM, Sushma David wrote: > Hi Champs, > > Please solve this query. > > > > Regards, > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Remove all macros from all the excel files on a computer

moved > once in all. > > Pravin. > > > *With regards,**Pravin Gunjal* > *Mobile: 77100 * > *97250* > > > > > On Mon, May 2, 2016 at 6:07 PM, Abhishek Jain <abhishek@gmail.com> > wrote: > >> >> http://www.mrexcel.com/forum/excel-questions/

Re: $$Excel-Macros$$ Remove all macros from all the excel files on a computer

http://www.mrexcel.com/forum/excel-questions/518757-delete-all-macros-workbook.html On Mon, May 2, 2016 at 5:41 PM, Pravin Gunjal wrote: > Hi, Good Evening > > I would like to know whether is there any provision to remove all macros > from all the excel files on a computer? >

Re: $$Excel-Macros$$ Macro error in opening file

st > file only.. Which 04 L1. Xlsx > > Pls suggest > On Apr 28, 2016 11:02 AM, "Abhishek Jain" <abhishek@gmail.com> wrote: > >> In your first macro, instead of: >> >> Workbooks.Open (MyFile) >> >> use: >> >> Workb

Re: $$Excel-Macros$$ Macro error in opening file

In your first macro, instead of: Workbooks.Open (MyFile) use: Workbooks.Open (path & MyFile) HTH On Thu, Apr 28, 2016 at 9:26 AM, Secret Shot wrote: > Hi all, > > Can anybody pls look into it. I am really hoping that I will get > resolution from this forum. > On Apr

Re: $$Excel-Macros$$ Screenshot in different designs

Try searching for something like "screen capture with effects" BTW, the TNT Screen Capture tool has paper-tear effects like the one in your example. On Wed, Apr 27, 2016 at 12:31 PM, Pravin Gunjal wrote: > Dear Friends, > > This is apart from excel knowledge, I would like

Re: $$Excel-Macros$$ Help Required

Please see attached. It gets the result from an UDF so be sure to copy the function as well if you intend to use it in another file. HTH On Tue, Apr 26, 2016 at 4:22 PM, Neeraj Chauhan wrote: > Dear sir, > > > > I want all Indus id in one row with Comma > > > >

Re: $$Excel-Macros$$ Problem in Pivot Table

Try this: 1. Right-click a cell in the pivot table 2. Click on PivotTable options 3. Click on the Data tab 4. In the Retain Items section, select None from the drop down list. 5. Click OK, then refresh the pivot table. On Mon, Apr 25, 2016 at 12:54 PM, Pravin Gunjal

Re: $$Excel-Macros$$ Help for a logical formula

clear now. > > Thanks a lot for your response. > > > On Tue, Apr 19, 2016 at 9:23 AM, Abhishek Jain <abhishek@gmail.com> > wrote: > >> Sorry I am unable to understand your query. >> >> If the value is same in Col A and Col B, your formula is correctly

Re: $$Excel-Macros$$ Help for a logical formula

Sorry I am unable to understand your query. If the value is same in Col A and Col B, your formula is correctly displaying in Col C. What exactly do you want? On Tue, Apr 19, 2016 at 11:15 AM, Rajeev Kumar wrote: > Dear Experts, > Please look in to the attached sheet and

Re: $$Excel-Macros$$ pls help in match two columns

Some part of your query is not clear. Please give a sample output as to what exactly you want. Rgds, On Fri, Mar 25, 2016 at 7:10 PM, Cute Awesome wrote: > Dear All, > > Pls help me out in matching two columns wherein i'll be having cost of > products which i have send

Re: $$Excel-Macros$$ If Condition formula required

Please see attached. HTH On Wed, Mar 2, 2016 at 10:28 AM, amar takale wrote: > Dear Paul Sir > > Pls look into this topic.I think we will use (If+Search) formula but I > cant possible how to modified it. > > Regards > Amar > > On Mon, Feb 29, 2016 at 7:49 PM, amar takale

Re: $$Excel-Macros$$ Edit Logo possible?

Dear Amar, To me this seems to a wordart object, you can re-create it and try to make as similar as possible or change it all the way to your likings. Please see a sample attached. Under the Format tab, you can change it as you may like, including the text. HTH On Wed, Mar 2, 2016 at 10:25 AM,

Re: $$Excel-Macros$$ How to execute a function only if the cell is not blank

=IF(G:G<>"",MONTH(G:G),"") HTH On Mon, Feb 8, 2016 at 12:28 PM, James Johnston wrote: > Hey guys, I am creating a budget. I set up a google form to enter > expenses and now am trying to create the backend. > > So far I have one sheet for the transactions

Re: $$Excel-Macros$$ Date formula for Age Calculation

Look at the second name "Carme" in your sheet. Your formula is picking up the first 02 digits of the DOB and taking them as 'month' and there is no 16th month in the calender. You either need to change your formula or the dates themselves. HTH On Sat, Feb 6, 2016 at 2:50 PM, amar takale

Re: $$Excel-Macros$$ Excel Exctact Data

Does this help? On Wed, Feb 3, 2016 at 11:54 AM, Vijayendra Rao wrote: > Dear Expert, > > > > I have time sheet which is received from my team and I tried to extract > data in to separate columns. I have tried with combination of formula of > “left, mid, right, find”

Re: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns

Do you already have the list of unique ids or you want to create it? As for the counting part, there are more than one ways to achieve this - based on type of data and how it is stored. For better understanding, a sample workbook with what you have and what you want will help. However, anywhere

Re: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns

Something like this: ? https://exceljet.net/formula/count-unique-values-in-a-range-with-countif On Sun, Jan 31, 2016 at 9:45 AM, Theresa Welton wrote: > Unfortunately, that is not what I am looking for. I have employees > participating in activities, these activities

Re: $$Excel-Macros$$ Create Multiple sheet

Open the attached file. Please note that you can only run this macro only once because when you do it again, it will already have the sheets created with those names and hence would give you an error. I gathered that you need it likewise (make copies once). If you want further copies, just

Re: $$Excel-Macros$$ first letter to be Capital letter

=PROPER(A1) Drag down! On Fri, Jan 22, 2016 at 12:18 PM, Vinod Kumar wrote: > Dear Team, > > Pls. asst. how to change first letter of a word to Cap's, in multiple cell. > > -- > 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)

Re: $$Excel-Macros$$ Custom view change automatically after time set

Change the code to this: Private Sub Workbook_Open() ActiveWorkbook.CustomViews("TODAY'S BIRTHDAY").Show Application.Wait (Now + TimeValue("00:00:10")) ActiveWorkbook.CustomViews("ALL PERSONS").Show End Sub Change the highlighted time delay as per your need. On Fri, Jan 15, 2016 at 8:52 AM,

Re: $$Excel-Macros$$ CURSOR SHOULD BE ON NAME MANAGER WHEN EVER I OPEN THE FILE

I assumed that by 'cursor' you mean cell pointer. I couldn't understand in what context you referred to name manager as I don't see any named range as 'CAL' in your file. What I gathered is that whenever you open this file, you want your cell pointer on a specific cell on a specific sheet. Excel

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

When you are subtracting, you are excluding the start date. On Mon, Jan 11, 2016 at 10:30 AM, Izhar wrote: > Please open the attachment see the question. > Thanks in advance. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Please elaborate what do you mean by "revision times". Do you want to show the time when it was most recently updated or you want to show how many times has it been updated? On Mon, Jan 11, 2016 at 9:52 AM, Kat wrote: > Hi all, > > I want to create a xlsm file which

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Please see if this solves your purpose - http://www.vbaexpress.com/kb/getarticle.php?kb_id=837 On Mon, Jan 11, 2016 at 11:55 AM, Kat wrote: > Hi Abhi, > > In terms of revision times, I want to show all the current revision times. > Also, in the future, if there is any

Re: $$Excel-Macros$$ Required Missing Date

Hi Plz share a sample workbook. On Sunday, January 10, 2016, Ahmed Emam wrote: > Dear All members, > > I have an excel sheet which being extracted from a fingerprints device > that shows all dates employees had put their fingers already to prove their > presence. > > My

Re: $$Excel-Macros$$ Merge cell entries & use of alt + enter formula

In your formula, you can add* (10)* wherever you want to have an "Alt-Enter". You also need to format your output cell for "wrap - text" to have correctly separated lines. For spell check, you can use the built in spell checker in Excel from the *Review tab*, short cut key is *F7*. I am afraid

Re: $$Excel-Macros$$ formatting cell

hort I have a date of material received in cell a1 and qty in cell b1. > But shelf life of material is only 15 days so i want to highlight that > once the 15 days over > I cant put formula in B1 so I want conditional formating > > > Regards > Shrinivas > > > On Thu, D

Re: $$Excel-Macros$$ formatting cell

You can use below formula in B1 and set desired format. Then copy B1 and select rest of the cells where you want the formatting and use Paste Special > Formats. *=AND(A1<>"",A1<=TODAY()-15)* On Thu, Dec 31, 2015 at 11:50 AM, Shrinivas Shevde wrote: > Dear all > One

Re: $$Excel-Macros$$ Re: Enable/Disable text box based on User Login

Dear Rajeev, Please see attached. User 1 - ADMIN admin123 User 2 GUEST guest123 *Both user names and passwords are case-sensitive.* HTH, Abhishek On Wed, Dec 30, 2015 at 1:11 PM, Rajeev Kumar wrote: > Please find attached file and help as per requirement. > > Thanks

Re: $$Excel-Macros$$ Enable/Disable text box based on User Login

Please share sample of your worksheet and mention what textboxes you want to be disabled in Guest mode. Rgds, Abhishek On Wed, Dec 30, 2015 at 11:08 AM, Rajeev Kumar wrote: > Dear Experts, > I am here by requesting for an sampel workbook for following: - > 1) When open a

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

PFA On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote: > Repected Friends 1] Which formula I should use in E 13 --- I want the > value depends upon Risk Group & Table As per B4 :D9 2] First I have to > see the Group which I & II then Table A/B/C/D It will take depends

Re: $$Excel-Macros$$ Help with Custom Vlookup

you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > -- > *From:* Abhishek Jain <abhishek@gmail.com> > *To:* Paul Schreiner <schreiner_p...@a

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

gt; > On Thu, Nov 5, 2015 at 6:55 PM, big smile <bigsmile...@gmail.com> wrote: > >> Thanks a lot >> >> But if i put Table A then it shows 0 only. For Table A -- Both Risk Group >> I /II not work.. >> >> On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain

Re: $$Excel-Macros$$ Re: Help with Custom Vlookup

Thanks Mandeep ji, I do know that cell has a limit of characters, but my each returning value has only 3 characters and max possible matches are 10 per lookup value, so the maximum characters per cell would be 30. I guess that's not the issue there. Nevertheless, I would look into the alternate

$$Excel-Macros$$ Help with Custom Vlookup

Hi All, I intend to use this piece of UDF I found on internet for my requirement - Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long) Dim r As Range Dim result As String result = "" For Each r In lookuprange If r = lookupval Then result = result & " " & r.Offset(0,

Re: $$Excel-Macros$$ Fwd: VBA to pick up current date in last column

Dear Praveen, Paul has already provided solution to your query. Thanks & regards, Abhishek On Tue, Oct 27, 2015 at 12:57 PM, Pravin Gunjal wrote: > Hi Friend > could you plz helm me out on the issue. > Thanks in advance. > > Regards > Pravin Gunjal > -- Forwarded

Re: $$Excel-Macros$$ VBA to pick up current date in last column

PFA... On Mon, Oct 26, 2015 at 4:02 PM, Pravin Gunjal wrote: > Dear Friends > > I have attached an excel file in which I have used macro to get "Created > by" field automatically once the values are entered in column N (Qty). > Likewise I want the last column (Entry Date) to

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

Yes, we can. On Sun, Oct 4, 2015 at 3:47 PM, PRADEEP KUMAR KOKNE < pradeepkumar...@gmail.com> wrote: > Hello all, > > Can you write code for to filter(Column S)-> select the complete visible > data and paste it in new workbook and save it. > > Example: Column S can have 50 lines data with 10

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015 17:54, "nyree" <nyree.willi...@gmail.com> wrote: > >> Hello Abhishek >> >> That's pefect! Thank you so much for your quick response >> Regards >> Nyree >> >> >> On 19-Sep-15 2:20 PM, Abhishek Jain wrote: >> >> Please see att

Re: $$Excel-Macros$$ formula for compound interest

http://www.excel-easy.com/examples/compound-interest.html On Sat, Sep 19, 2015 at 11:29 AM, Rajesh Agarwal wrote: > Rs. 1/- > rate of interest 12% > compound half yearly, quartly, monthly for the period of > 1. 15 months > 2. 267 days > > -- > *Rajesh Kumar

Re: $$Excel-Macros$$ Error While Running Any Macro - Code execution has been interrupted

See if this helps - http://www.maheshsubramaniya.com/article/fix-for-code-execution-has-been-interrupted-in-excel-vba-macros.html On Sat, Sep 19, 2015 at 3:04 PM, Pravin Gunjal wrote: > Hi, Can anyone help me on this subject? > > On Saturday, September 19, 2015 at 1:45:12 PM

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

Please see attached HTH, Abhishek On Sat, Sep 19, 2015 at 5:31 PM, N .williams wrote: > Hello > I would like to know if its possible to use a macro or forumula to replace > every "0" with the header cell value and list each one by student > eg Student B: Q107, Q108,

Re: $$Excel-Macros$$ Company name based on maximum occurrence

Just to clear it up...1 "lakh" rows mean 100,000 rows. On Wed, Sep 16, 2015 at 5:16 PM, Suman wrote: > Dear Paul, > I can understand macro and modify too according to needs while > implementing in my workbook. You can make the module on the basis of my > previous

Re: $$Excel-Macros$$ Timing calculation

You can simply deduct the times - like (in F2): =E2-D2 You can then set the format of the result to as "[hh]:mm" - without quotes and drag / copy as required. PS: Have a look at your values showing as "0:00" - some of them might need to be changed to 12 PM so as to give correct results. HTH

Re: $$Excel-Macros$$ help required to assign number value

Assuming that your values are stored in column A from cell 1 to 50, you could use this formula in cell B1 and drag it down - =RANK(A1,$A$1:$A$50) HTH Abhishek On Wed, Sep 9, 2015 at 2:22 PM, Nasir Saikh wrote: > Hi Experts, > > I need a formula to assign number value

Re: $$Excel-Macros$$ Count If Cell Contains

Just one correction, if I may: Countif(A1:A100,"(IRE)") would only count the cells having exact text as "(IRE)" not those which *contain* "(IRE)". For that you would have to put an asterisk before and after the look up text so as to do wild card search. Here is what your formula would be:

Re: $$Excel-Macros$$ Sort Date on the Basis of Day

Is there any specific reason you want to use VBA? In the attached sheet, I used a helper column - please see if this serves your purpose. Regards, On Mon, Aug 31, 2015 at 11:25 AM, Soumyendu Paul wrote: > Hi, > Is there anyone to help? > > On Mon, Aug 31, 2015 at

Re: $$Excel-Macros$$ need macro to generate serial no

Your query is not clear...please elaborate. On Sat, Aug 29, 2015 at 9:24 AM, My Excel myxlg...@gmail.com wrote: any macro solution ? On Thu, Aug 27, 2015 at 10:18 PM, My Excel myxlg...@gmail.com wrote: Sir, need help on serial no generate (like attached file) using auto increment

Re: $$Excel-Macros$$ Formula needed

Hope this helps. Whenever you want to make any change in the formula, do it in the first resulting value, i.e, G2 and remember to press Ctrl+Shift+Enter (not just enter) before dragging it down. Regards, On Fri, Aug 28, 2015 at 12:06 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear

Re: $$Excel-Macros$$ need Excel formula

HTH On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com 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

Re: $$Excel-Macros$$ need Excel formula

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 pankaj123...@gmail.com wrote: Thank you Abhishek Jain On Thu

Re: $$Excel-Macros$$ Excel Qry.

PFA HTH On Thu, Aug 13, 2015 at 1:20 PM, sush.dav...@gmail.com wrote: Dear Champs Please Solve My Querry In Atteched File -- 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 @

Re: $$Excel-Macros$$ Remove Outlook Security Alert(Urgent!)

What worked for me on Outlook 2007 - Run Outlook as Administrator (right lick on icon, run as administrator) Go to Tools Trust Center Under Programmatic Access, select - Never warn me about suspicious activity HTH, Abhishek On Tue, Aug 4, 2015 at 2:12 PM, Soumyendu Paul soumyendu...@gmail.com

Re: $$Excel-Macros$$ update the current time when the status column updated as Closed.

Plz see attached On Mon, Jun 29, 2015 at 2:08 PM, Sundarvelan N nsund...@gmail.com wrote: Dear Friends, My attached excel should update the current time when the status column updated as Closed. 11 Please Help Thanks N.Sundarvelan 9600160150 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ reached at certain value Message shows

Not clear what exactly do you want but if you put this code in the Sheet 1 module then it will give a message whenever the value is A1 is 1000. *Private Sub Worksheet_Change(ByVal Target As Range)* *If Sheets(Sheet1).Range(A1) = 1000 Then* *MsgBox A1 value is now 1000* *Else* *End If* *End Sub*

Re: $$Excel-Macros$$ help on if formula

=IF(C50,0,IF(C5380,C5-B5,IF(AND(D50,D5=380),C5,NA))) Drag down... On Wed, May 20, 2015 at 11:22 AM, ankit sharma excel2...@gmail.com wrote: Dear Experts i want a formula that fulfill my both conditions pls solve this. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Send Mail from Outlook with attachment from file path

this for you. God is here working through me for you.* On Sat, Nov 29, 2014 at 3:31 PM, Abhishek Jain abhishek@gmail.com wrote: Dear Friends, I need to send files through outlook to some people along with the specific file as attachment picked from the path mentioned in next column. I have

$$Excel-Macros$$ Send Mail from Outlook with attachment from file path

Dear Friends, I need to send files through outlook to some people along with the specific file as attachment picked from the path mentioned in next column. I have attached a sample file with details. Request further help please. Thanks regards, Abhishek -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ plz solve my query sorting and unique data

Not sure if your output has anything to do with sorting. Remove Duplicates (under Data tab) will give you the same results. Regards, Abhishek On Sat, Jun 21, 2014 at 4:11 PM, Sourabh Salgotra rhtdmja...@gmail.com wrote: Dear Sir, plz solve my query related to getting the

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

Its a name range. See the range under Name Manager in the Formulas tab (Excel 2007). HTH/Abhishek On Thu, Jun 12, 2014 at 6:29 PM, Waqar Ahmed asif.waqar1...@gmail.com wrote: Hello everybody, I have a problem that I can't increase the list range , I can't find value (Range name List)

Re: $$Excel-Macros$$ last sunday of the month?

=INT((EOMONTH(A1,0)-1)/7)*7+1 Put any date of the month in question in A1 - does not matter what date. HTH/Abhishek On Thu, Jun 5, 2014 at 12:55 PM, 'Hanumant' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Hi Group, can you please let me know how can we find last

Re: $$Excel-Macros$$ Re: Creating macro for formatting all cells to accounting format

Try this: Private Sub test() Dim myrng As Range Set myrng = ActiveSheet.UsedRange For Each cell In myrng If IsDate(cell.Value) = True Then cell.NumberFormat = dd/mm/ Else cell.NumberFormat = _(* #,##0.00_);_(* (#,##0.00);_(* -??_);_(@_) End If Next cell End Sub HTH/Abhishek

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

Happy to help :) On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Abhishek Jee, It is really a very very helpful for me. Thanks a ton! Regards Pravin Gunjal. -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Tue, May

Re: $$Excel-Macros$$ Need Help

=IF(AND(C2=,D21),1,0) Drag down. HTH/Abhishek On Sat, May 24, 2014 at 1:04 AM, Imran Khan ikha...@gmail.com wrote: Dear Friends, Need your help in IF formula. I have attach the file for your input. Thanks Regards, *Imran Khan* *Lead Planner - OR/CSU* Ras Al-Khair Industrial City

Re: $$Excel-Macros$$ How to Drag get C,D,E,F post A,B...

After A, B, C.Y, Z and then AA, AB and so on - if you are looking for this, you can use below after putting A in A1 - =LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)26)+1) Regards, Abhishek On Fri, May 9, 2014 at 12:21 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends,

Re: $$Excel-Macros$$ Login password in excel

for help Regards Amar On Thu, Apr 17, 2014 at 1:07 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Abhishek Sir, Great. Regards, Prafull Jadhav 9920553518 On 17 April 2014 12:09, Abhishek Jain abhishek@gmail.com wrote: Dear Amar, Please see

Re: $$Excel-Macros$$ Need new Workbook create using Macros

Dear Kapil, Please see the attached. This will create workbooks, paste filtered data and save them as per the name column (Col G). *Keep in mind the following:* a) The new excel files will be created in the same folder* where you have saved this file*. So, when you download this, save it in a

$$Excel-Macros$$ Convert PDF to Excel - single file with 12000 pages

Hi Friends, I have a PDF file with some 11800+ pages in it (around 28 MB). Is there a way I can convert it in Excel format using a macro or a tool? Many thanks for help. Regards, Abhishek -- 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

Re: $$Excel-Macros$$ Convert PDF to Excel - single file with 12000 pages

I tried saving the PDF as Text and importing it in Excel, it didn't work. Do you have a sample macro or something that I can try? Thanks. On Tue, Apr 1, 2014 at 11:24 PM, Ricardo(R) ricardo...@gmail.com wrote: Hi Abhishek Jain, If the formatting of the PDF files is standardized, you can

Re: $$Excel-Macros$$ Need suggestion.

Please provide more info or screenshot of the screen where you have to input the date generating the report. Regards, Abhishek On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Yes abhi...it shld be in vba excel. Pls help On 26-Mar-2014 3:30 PM, Abhishek Jain

Re: $$Excel-Macros$$ Need suggestion.

You may please contact me via chat. Thanks On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky prabhupin...@gmail.comwrote: No abhi...since its official... Am unable to share... On 27-Mar-2014 6:00 PM, Abhishek Jain abhishek@gmail.com wrote: Please provide more info or screenshot

Re: $$Excel-Macros$$ How to match a combobox result with an textbox

A sample file would help understand better. Thanks. On Thu, Mar 27, 2014 at 8:28 PM, Tommy nunofilipene...@gmail.com wrote: Hi, i am stuck on my project, an i am still a noob on VBA :P i have a userform with 4 textboxes and a combobox with 5 options that link each one to 5 sheets.

Re: $$Excel-Macros$$ Need suggestion.

time to contact. On 27-Mar-2014 11:32 PM, Abhishek Jain abhishek@gmail.com wrote: You may please contact me via chat. Thanks On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky prabhupin...@gmail.comwrote: No abhi...since its official... Am unable to share... On 27-Mar-2014 6:00 PM, Abhishek

Re: $$Excel-Macros$$ Need suggestion.

Does it have to be Excel VBA? I am sure there are many FTP clients that support automated and scheduled transfers (upload or download). If you want that I can look into some. Regards, Abhishek On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi experts, i need

Re: $$Excel-Macros$$ Solution if Fill In Blanks Formula Leaves Blank Cells with Formula Only (i.e =A2)?

You sure you are pressing Ctrl+Enter after you have chose the reference cell? I personally used this many times, it never failed me. Here's how I do it: 1. Press F5, Go to Special Blanks. 2. Without losing the selection of blank cells, put *=* and select my reference cell (preferably with an

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

, Yes, I did see the formula. Never knew it would be that straight forward Will give it a try and keep you posted. Really appreciate the help ! Regards, Priyanka S On Sun, Mar 23, 2014 at 12:44 AM, Abhishek Jain abhishek@gmail.comwrote: Yes, it will. As long as the dates and times

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

Please see attached. HTH On Sat, Mar 22, 2014 at 7:16 PM, Priyanka Sachdeva priyanka.sachdeva...@gmail.com wrote: Hello All, Am looking to calculate the difference in minutes between 2 dates. ( Inception Date and Closure Date) Eg : Inception Date = 02-12-2014 10:26:12 (mm-dd-yyy

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

Date = 02-12-2014 10:29:00 PM i.e it has a AM and PM instead of a 24 hour clock (eg 10:29:00 PM instead of 22:29:00) Regards, Priyanka S On Sat, Mar 22, 2014 at 7:44 PM, Abhishek Jain abhishek@gmail.comwrote: Please see attached. HTH On Sat, Mar 22, 2014 at 7:16 PM, Priyanka

Re: $$Excel-Macros$$ Split Workbook into many sheets

).Range(cpyRng).Copy ThisWorkbook.Worksheets(shtName).Range(A8).PasteSpecial Application.Goto ThisWorkbook.Worksheets(shtName).Range(A1), True Application.CutCopyMode = False End Sub On Thu, Mar 20, 2014 at 2:27 PM, Abhishek Jain abhishek@gmail.comwrote: Dear Experts, Attached

Re: $$Excel-Macros$$ First time error

You probably have the calculation in Excel set to Manual. In Excel Options, change it to Automatic HTH/Abhishek On Wed, Mar 19, 2014 at 4:55 PM, Kush Shama kushleshsha...@gmail.comwrote: Dear team i am using multiple excel sheets. However i am facing a common problem with all files that when

Re: $$Excel-Macros$$ Average Graph

Does this make any sense? On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All , Day before Yesterday I had gone for Interview for Data Analyst. They asked me one question but i could not answer it . The Person who has taken my interview, asked me

Re: $$Excel-Macros$$ Average Graph

that daily Average cabs coming is 123...and that is wrong... It gives wrong Nos to Management. Regards, Prafull Jadhav 9920553518 On 15 March 2014 20:44, ravinder negi ravi_colw...@yahoo.com wrote: pls provide some example in excel with chart On Saturday, March 15, 2014 8:12 AM, Abhishek

Re: $$Excel-Macros$$ cell tooltip

Just to help me understand: Why do you want to reflect the value in tooltip when it is already visible in the Cell itself? Do you mean Cell Address instead of Cell Value? Example - Cell Value is Rupesh Cell Address is E2 What do you want to appear in the tool tip? On Fri, Mar 7, 2014 at

Re: $$Excel-Macros$$ Need micro

In B2 - =RIGHT(A2,6) and drag down. HTH On Fri, Mar 7, 2014 at 11:57 AM, Rupesh Patil patil.rupesh1...@gmail.comwrote: Hi Expert, Please find file in attachment -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's

Re: $$Excel-Macros$$ Need micro

Rupesh, then go with abhishek's formula. Thanks Ashish On 7 March 2014 12:19, Rupesh Patil patil.rupesh1...@gmail.com wrote: Thanks your quick reply, but I want cut last 6 characters from column 'A' and paste it to columnB On Fri, Mar 7, 2014 at 12:08 PM, Abhishek Jain abhishek

  1   2   3   4   >