$$Excel-Macros$$ Re: formula required query
Hi , Please Check. I have attached excel. On Saturday, 6 October 2018 14:27:11 UTC+5:30, rajeyssh wrote: > > Dear Sir > Formula required as per the attachment in sheet "2". > Thanks in advance for your help. > > Regards > > -- > *Rajesh Kumar Agarwal* > *9811063001* > -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. formula required query.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: FORMULA REQUIRED
Thank you Mr Paul that's really great On Saturday, 24 October 2015 17:07:35 UTC+5, GENIUS wrote: > > Thanks for your reply, but let me clear as you may see if we put more data > in the rows we may have the sum of all the rows at one place, look at the > sheet, but i need only row wise sum not the sum of the different rows at > one place i.e. if we sum row three in J3 and K3, the sum must be of row 3 > only not the others. > > On Friday, 23 October 2015 20:38:38 UTC+5, GENIUS wrote: >> >> >> As you may see I have already used different cell reference for summing >> up the UNIT and COST but I need a formula from which when I type and take >> the reference of all the cell i.e. A3:H3 under the heading of UNIT and same >> under the heading of COST, there must be a sum of the respective field in >> the respective heading, not the whole I know about the subtotal but I >> think subtotal cannot be used over here, if yes then how can I used >> subtotal or some other formula. >> Thanks in advance >> -- >> *Izhar Ul Haq* >> >> >> >> Cell# 009203069072597 >> > -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: FORMULA REQUIRED
I think I see your issue.Your example has (4) products (Product A, B, C, D)Your formula "manually" adds the Unit volumes for eachand the costs for each. But if you have more Products, this calculation becomes harder to manage. You want a sum of the Unit volume of ALL products, not EACH product. In cell J3, I would use: =SUMIF($A$2:I$2,J$2,$A3:I3) Copy it to Column K and down. (see attached) Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: GENIUS To: MS EXCEL AND VBA MACROS Sent: Saturday, October 24, 2015 8:07 AM Subject: $$Excel-Macros$$ Re: FORMULA REQUIRED Thanks for your reply, but let me clear as you may see if we put more data in the rows we may have the sum of all the rows at one place, look at the sheet, but i need only row wise sum not the sum of the different rows at one place i.e. if we sum row three in J3 and K3, the sum must be of row 3 only not the others. On Friday, 23 October 2015 20:38:38 UTC+5, GENIUS wrote: As you may see I have already used different cell reference for summing up the UNIT and COST but I need a formula from which when I type and take the reference of all the cell i.e. A3:H3 under the heading of UNIT and same under the heading of COST, there must be a sum of the respective field in the respective heading, not the whole I know about the subtotal but I think subtotal cannot be used over here, if yes then how can I used subtotal or some other formula. Thanks in advance -- Izhar Ul Haq Cell# 009203069072597 -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: FORMULA REQUIRED
Thanks for your reply, but let me clear as you may see if we put more data in the rows we may have the sum of all the rows at one place, look at the sheet, but i need only row wise sum not the sum of the different rows at one place i.e. if we sum row three in J3 and K3, the sum must be of row 3 only not the others. On Friday, 23 October 2015 20:38:38 UTC+5, GENIUS wrote: > > > As you may see I have already used different cell reference for summing up > the UNIT and COST but I need a formula from which when I type and take the > reference of all the cell i.e. A3:H3 under the heading of UNIT and same > under the heading of COST, there must be a sum of the respective field in > the respective heading, not the whole I know about the subtotal but I > think subtotal cannot be used over here, if yes then how can I used > subtotal or some other formula. > Thanks in advance > -- > *Izhar Ul Haq* > > > > Cell# 009203069072597 > -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: formula required in column D & E
Did not understand your requirement. also, FYI, I can not see anything in this attachemnt. On Tuesday, April 21, 2015 at 11:03:22 PM UTC+5:30, rajeyssh wrote: > Hello Sir > formula required in both the column matching. > > -- > *Rajesh Kumar Agarwal* > *9811063001* > -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: formula required in column c excluding Zero
Hi i think your are looking for this..file also attached =IFERROR(SMALL($B$2:$B$375,COUNTIF($B$2:$B$375,"<=0")+ROW(A1)),"") Thankx & Rgds, Chandra Singh Bisht On Wed, Apr 22, 2015 at 10:11 AM, Rajesh Agarwal wrote: > Sorry. now find the attachment. > > On Tue, Apr 21, 2015 at 10:53 PM, Rajesh Agarwal > wrote: > >> Hello Sir >> formula required >> >> -- >> *Rajesh Kumar Agarwal* >> *9811063001* >> > > > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > 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 thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. low excluding 0.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: formula required in column c excluding Zero
Elaborate more!! Regards Ashish -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: formula required in column c excluding Zero
Sorry. now find the attachment. On Tue, Apr 21, 2015 at 10:53 PM, Rajesh Agarwal wrote: > Hello Sir > formula required > > -- > *Rajesh Kumar Agarwal* > *9811063001* > -- *Rajesh Kumar Agarwal* *9811063001* -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. low excluding 0.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: formula required to update values form one sheet to another sheet with date criteria
Not clear what you are trying to do but if your master sheet has different names and you are trying to sum for your report sheet try the following: =SUMIF(MASTER!$B$5:$B$35,"Raman Choudary",MASTER!C5:C35) That goes into B9 of your report sheet. You can then copy across. If B10 is a different name copy the above formula to B10 and change the "Raman Choudary" to that name. Hope this is of some help. Regards. On Friday, July 19, 2013 12:50:57 AM UTC-4, excel lerner wrote: > Hi Experts > > Good morning Every Body. > > I have Two sheets in excel 2003 file.One is master sheet and 2nd one > reprot sheet. > > daily i have to send report to HO.I enter values in master sheet date wise. > In report sheet if i select or enter date data to be update from master > sheet with name.only one name will be in master sheet. > Please help me any formula? > i am attaching. test file. > > Thanks in advance > -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: formula required
Hi Ganesh, PFA. Regards Prince On Sunday, February 10, 2013 8:50:17 AM UTC+5:30, GANESH wrote: > > Hi I want the J8 show me the total of rim of which I highilighted in > Green color all the user in Column E > Column B has user Name Column c has the total of amount > Please find the attached file. > > FORUM RULES > > 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 or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros...@googlegroups.com . > To post to this group, send email to excel-...@googlegroups.com > . > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. -- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Formula required.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: formula required
@ Prince, Do you think is it a quality answer? and Dont you think you are re-directing the OP in wrong approach? =SUM(($D$2:D5=D2)**1**(G2:M2))*with CSE*in Cell "O2" Could you please explain what is the need of **1* *and what is the need ofCSE here* *why not then one (Non Array Approach) which Manoj suggested before your post*? * On 14-01-2013 12:32 PM, Prince wrote: Hi Prashant, I hope it may help you: =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2" Regards Prince On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote: Dear Team, Need a formula to look up a filed & give sum of figure , sample file attached Regards, Prashant -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: formula required
Hi Vikas, Here is the macro than can combine data from multiple filse in to a single file Public Sub CombineDataFromFiles() Dim varArrFile As Variant Dim intCtr As Integer Dim strFilesAs String Dim wbk As Workbook Dim wbkFinalAs Workbook Dim rngData As Range Set wbkFinal = Workbooks.Add(1) varArrFile = Application.GetOpenFilename("*.xls,*.xlsx", , "Select Files", , True) If IsArray(varArrFile) = False Then MsgBox "Select File..." Exit Sub Else For intCtr = LBound(varArrFile) To UBound(varArrFile) Set wbk = Workbooks.Open(varArrFile(intCtr)) With wbk.Worksheets(1) Set rngData = .UsedRange End With With wbkFinal.Worksheets(1) rngData.Copy .Range("A" & .Range("A" & Rows.Count).End(xlUp).Row + 1).PasteSpecial Application.CutCopyMode = False End With wbk.Close Set wbk = Nothing Next End If MsgBox "All data combile into resultant file Please save!!!" End Sub Here you can select multple file by using CTRL key and selecting multiple files. regards Prince On Tuesday, January 15, 2013 1:45:48 PM UTC+5:30, vikas wrote: > > Hi prince > > > Will you please help me. > I have three different excel file and each excel file have three different > wrk sheet. I need to link or copy all data in one excel file from these > different wrk sheet. How do I do this. > > In advance thnks for help. > Sent from my BlackBerry® Smartphone on Loop Mobile. > -- > *From: * Prince > > *Sender: * excel-...@googlegroups.com > *Date: *Sun, 13 Jan 2013 23:02:48 -0800 (PST) > *To: *> > *ReplyTo: * excel-...@googlegroups.com > *Subject: *$$Excel-Macros$$ Re: formula required > > Hi Prashant, > > I hope it may help you: > > =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2" > > Regards > Prince > > On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote: >> >> Dear Team, >> >> Need a formula to look up a filed & give sum of figure , sample file >> attached >> >> Regards, >> >> Prashant >> > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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 or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-...@googlegroups.com > . > To unsubscribe from this group, send email to > excel-macros...@googlegroups.com . > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: formula required
pl share a worksheet with us On Tue, Jan 15, 2013 at 1:45 PM, wrote: > ** > Hi prince > > > Will you please help me. > I have three different excel file and each excel file have three different > wrk sheet. I need to link or copy all data in one excel file from these > different wrk sheet. How do I do this. > > In advance thnks for help. > Sent from my BlackBerry® Smartphone on Loop Mobile. > -- > *From: * Prince > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 13 Jan 2013 23:02:48 -0800 (PST) > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macros$$ Re: formula required > > Hi Prashant, > > I hope it may help you: > > =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2" > > Regards > Prince > > On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote: >> >> Dear Team, >> >> Need a formula to look up a filed & give sum of figure , sample file >> attached >> >> Regards, >> >> Prashant >> > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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 or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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 or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: formula required
Hi prince Will you please help me. I have three different excel file and each excel file have three different wrk sheet. I need to link or copy all data in one excel file from these different wrk sheet. How do I do this. In advance thnks for help. Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: Prince Sender: excel-macros@googlegroups.com Date: Sun, 13 Jan 2013 23:02:48 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: formula required Hi Prashant, I hope it may help you: =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2" Regards Prince On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote: > > Dear Team, > > Need a formula to look up a filed & give sum of figure , sample file > attached > > Regards, > > Prashant > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: formula required
Hi Prashant, I hope it may help you: =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2" Regards Prince On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote: > > Dear Team, > > Need a formula to look up a filed & give sum of figure , sample file > attached > > Regards, > > Prashant > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry
Dear Sir, If possible can you please send me the example of the formula. On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote: > Hi Ashish, > > Please use sumifs formula for getting total GROSS and TDS amount for each > vendor. > > Regards > Prince > > On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote: >> >> Dear All, >> >> I have an excel sheet wherein commission is generated for each >> business placed by our intermediary. I need to have a formula for >> monthly consolidated amount for Gross Amount (Column E) and TDS >> Deduction (Column I) of each intermediary without first sorting and >> subsequently adding each entry. >> >> I am enclosing the sample worksheet. >> >> Thanks in advance. >> >> -- >> Thanking you. >> >> With regards, >> >> Ashish Damor > > -- > 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, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > -- Thanking you. With regards, Ashish Damor -- 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, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry
Dear Sir, Thanks will try and get back to you. On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote: > Hi Ashish, > > Please use sumifs formula for getting total GROSS and TDS amount for each > vendor. > > Regards > Prince > > On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote: >> >> Dear All, >> >> I have an excel sheet wherein commission is generated for each >> business placed by our intermediary. I need to have a formula for >> monthly consolidated amount for Gross Amount (Column E) and TDS >> Deduction (Column I) of each intermediary without first sorting and >> subsequently adding each entry. >> >> I am enclosing the sample worksheet. >> >> Thanks in advance. >> >> -- >> Thanking you. >> >> With regards, >> >> Ashish Damor > > -- > 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, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > -- Thanking you. With regards, Ashish Damor -- 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, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry
Hi Ashish, Please use sumifs formula for getting total GROSS and TDS amount for each vendor. Regards Prince On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote: > > Dear All, > > I have an excel sheet wherein commission is generated for each > business placed by our intermediary. I need to have a formula for > monthly consolidated amount for Gross Amount (Column E) and TDS > Deduction (Column I) of each intermediary without first sorting and > subsequently adding each entry. > > I am enclosing the sample worksheet. > > Thanks in advance. > > -- > Thanking you. > > With regards, > > Ashish Damor > -- 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, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: formula required for count or count if
Hello Lee, This should work with just ENTER. in AC2, then drag down. =SUMPRODUCT((A$2:A$23=AB2)*(B$2:Z$23<>"")/COUNTIF(B$2:Z$23,B$2:Z$23&"")) Adjust the ranges. See the attached. Regards, Haseeb -- 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Count_Unique.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Re: formula required for count or count if
Hi Please find attached Sheet =SUM(1/COUNTIF(OFFSET(INDEX(Range,MATCH(A2,Range,0),1),,1,COUNTIF(Range,A2), COUNTA(D1:AC1)-1),OFFSET(INDEX(Range,MATCH(A2,Range,0),1),,1,COUNTIF(Range,A 2),COUNTA(D1:AC1)-1)))-1 Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of CoRe Sent: Apr/Fri/2012 12:58 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: formula required for count or count if Hello Lee, PFA! If you have any queries ,give a shout ... On Friday, April 27, 2012 7:30:32 AM UTC+3, lee wrote: hi i have data as in the attached data. i need count of unique values of column A i.e i need output as in column AB, AC... pls advise a formula thanks -- 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Copy of Book2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Formula required
Hi, If you had this "+" sign in every contact I would suggest Data>Text to Column wizard in Excel. But in this situation there is no automatic solution, i think. On Fri, Nov 14, 2008 at 2:51 PM, Ahmedhonest <[EMAIL PROTECTED]> wrote: > Dear All Chill out Greetings for the Day, > > Please see the attached file and provide me the solution as i want to > seperate Name and Contact Numbers > > Example: ahmed+919912204 then result should be like ahmed in column and > +919912204 in other column > > > > -- > Ahmed Bawazir > > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---