$$Excel-Macros$$ Re: Custom Number Format - Help URGENT
Hello Ayush, Thank you very much for the macro which worked exactly as expected. The only problem was that I already had entries filled up, for which I used your macro as a separate module and it solved the issue. Although not related to this question - I am going to send this file to my managers and I want to set a drop-down list for input values, i.e., 0,1,2,3. Data Validation can simply do this. The problem is it will show 0 , 1 , 2 and 3 in the drop-down and when they change the value, say, from 2 to 3, the macro will change the display from Good to Excellent. Fairly confusing for Managers ;) I don't know, but can I somehow get an indication for display values (Excellent, Good, Average, Poor) in the drop-down ? Hope I am not bothering you too much. Thanks again for your suport. Jai Jinendra Abhishek Jain On Sat, Nov 14, 2009 at 8:15 PM, Ayush jainayus...@gmail.com wrote: Hi Abhishek, Unfortunately, The custom number format can take only up to two conditions and you have three conditions in your requirement. Also, Conditional formatting may not work as it displays colors,borders and patterns. I have written a macro for you which should fulfill your requirement. This macro should be used in Change event of excel sheet(or workbook) and you should specify your desired range in macro. So, whenever you will change value in the range, the macro will trigger and change the custom format. Private Sub Worksheet_Change(ByVal Target As Range) For Each cell In ActiveSheet.Range(A1:Z100) If cell.Value 2 Then cell.NumberFormat = [=0]Poor;[=1]Average End If If cell.Value 1 And cell.Value 4 Then cell.NumberFormat = [=2]Good;[=3]Excellent End If Next End Sub I hope this macro will help you. Let us know if it does not work or any further help is required. Best regards, Ayush Jain [Group Owner and Manager] On Nov 14, 1:52 pm, Abhishek Jain abhishek@gmail.com wrote: Hi folks, I have this cell where the values filled can be - 0 or 1 or 2 or 3. I want to set a custom format for excel to show - Poor for 0 Average for 1 Good for 2 Excellent for 3 Now, I've tried and figured out that I can set maximum 03 conditions in Custom Number format but in my case they are 4. I used this format - [=0]Poor;[=1]Average;Good It's working for 03 conditions but If I add one more condition in this, - error ! format can't be set. I tried this formula in Conditional Formatting, which is working in another cell but not in formatting - =IF(J2=0,Poor,IF(J2=1,Average,IF(J2=2,Good,Excellent))) Any help is greatly appreciated. Thanks, AJ -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Custom Number Format - Help URGENT
Hi Abhishek, Jai Jinendra ! You are most welcome ! Attached is the updated solution. Please see the file and let me know if this is the desired solution. I have added data validation in column E. Best regards, Ayush Jain [Group Manager Owner] --- On Sun, 15/11/09, Abhishek Jain abhishek@gmail.com wrote: From: Abhishek Jain abhishek@gmail.com Subject: $$Excel-Macros$$ Re: Custom Number Format - Help URGENT To: Ayush jainayus...@gmail.com Cc: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Date: Sunday, 15 November, 2009, 1:21 PM Hello Ayush, Thank you very much for the macro which worked exactly as expected. The only problem was that I already had entries filled up, for which I used your macro as a separate module and it solved the issue. Although not related to this question - I am going to send this file to my managers and I want to set a drop-down list for input values, i.e., 0,1,2,3. Data Validation can simply do this. The problem is it will show 0 , 1 , 2 and 3 in the drop-down and when they change the value, say, from 2 to 3, the macro will change the display from Good to Excellent. Fairly confusing for Managers ;) I don't know, but can I somehow get an indication for display values (Excellent, Good, Average, Poor) in the drop-down ? Hope I am not bothering you too much. Thanks again for your suport. Jai Jinendra Abhishek Jain On Sat, Nov 14, 2009 at 8:15 PM, Ayush jainayus...@gmail.com wrote: Hi Abhishek, Unfortunately, The custom number format can take only up to two conditions and you have three conditions in your requirement. Also, Conditional formatting may not work as it displays colors,borders and patterns. I have written a macro for you which should fulfill your requirement. This macro should be used in Change event of excel sheet(or workbook) and you should specify your desired range in macro. So, whenever you will change value in the range, the macro will trigger and change the custom format. Private Sub Worksheet_Change(ByVal Target As Range) For Each cell In ActiveSheet.Range(A1:Z100) If cell.Value 2 Then cell.NumberFormat = [=0]Poor;[=1]Average End If If cell.Value 1 And cell.Value 4 Then cell.NumberFormat = [=2]Good;[=3]Excellent End If Next End Sub I hope this macro will help you. Let us know if it does not work or any further help is required. Best regards, Ayush Jain [Group Owner and Manager] On Nov 14, 1:52 pm, Abhishek Jain abhishek@gmail.com wrote: Hi folks, I have this cell where the values filled can be - 0 or 1 or 2 or 3. I want to set a custom format for excel to show - Poor for 0 Average for 1 Good for 2 Excellent for 3 Now, I've tried and figured out that I can set maximum 03 conditions in Custom Number format but in my case they are 4. I used this format - [=0]Poor;[=1]Average;Good It's working for 03 conditions but If I add one more condition in this, - error ! format can't be set. I tried this formula in Conditional Formatting, which is working in another cell but not in formatting - =IF(J2=0,Poor,IF(J2=1,Average,IF(J2=2,Good,Excellent))) Any help is greatly appreciated. Thanks, AJ -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Keep up with people you care about with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/connectmore -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the
$$Excel-Macros$$ excel certificate course
Hi all, I am from chennai.If any body knows about online excel certificate course.Pls let me know. txs karthik -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ lenghty IF formula
I need to use the IF 53 times ! I have 53 rows which I am using filter and Subtotal (row70) I need to get one of the columns C to enter its text (names) into the subtotal row 70. However I can only use the brackets up to 9 times ( I think) can does anyone know how to reduce the formula size. I need to get A70 up to =53 and likewise with the C column. =IF(A70=3,C3,IF(A70=4,C4,IF(A70=5,C5,IF(A70=6,C6,IF(A70=6,C6,IF (A70=7,C7,IF(A70=8,C8, IF(A70=9,C9 Row 70 works like this if the subtotal in column A row 70 = 5 then in the subtotal column C (where the above formula is) it puts the name of the person, all the other subtotal columns are for data and they work fine. This does what I need but I need but only up to number 9, I need to get the equals up to number 53 and therefore the C part of the formula up to 53. thanks everyboy how reads these posts. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Custom Number Format - Help URGENT
Hello Ayush, This is exactly what I wanted. Thank you very much. Jai Jinendra ! Abhishek Jain On Sun, Nov 15, 2009 at 4:25 PM, Ayush Jain jain_ayus...@yahoo.com wrote: Hi Abhishek, Jai Jinendra ! You are most welcome ! Attached is the updated solution. Please see the file and let me know if this is the desired solution. I have added data validation in column E. Best regards, Ayush Jain [Group Manager Owner] --- On *Sun, 15/11/09, Abhishek Jain abhishek@gmail.com* wrote: From: Abhishek Jain abhishek@gmail.com Subject: $$Excel-Macros$$ Re: Custom Number Format - Help URGENT To: Ayush jainayus...@gmail.com Cc: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Date: Sunday, 15 November, 2009, 1:21 PM Hello Ayush, Thank you very much for the macro which worked exactly as expected. The only problem was that I already had entries filled up, for which I used your macro as a separate module and it solved the issue. Although not related to this question - I am going to send this file to my managers and I want to set a drop-down list for input values, i.e., 0,1,2,3. Data Validation can simply do this. The problem is it will show 0 , 1 , 2 and 3 in the drop-down and when they change the value, say, from 2 to 3, the macro will change the display from Good to Excellent. Fairly confusing for Managers ;) I don't know, but can I somehow get an indication for display values (Excellent, Good, Average, Poor) in the drop-down ? Hope I am not bothering you too much. Thanks again for your suport. Jai Jinendra Abhishek Jain On Sat, Nov 14, 2009 at 8:15 PM, Ayush jainayus...@gmail.comhttp://mc/compose?to=jainayus...@gmail.com wrote: Hi Abhishek, Unfortunately, The custom number format can take only up to two conditions and you have three conditions in your requirement. Also, Conditional formatting may not work as it displays colors,borders and patterns. I have written a macro for you which should fulfill your requirement. This macro should be used in Change event of excel sheet(or workbook) and you should specify your desired range in macro. So, whenever you will change value in the range, the macro will trigger and change the custom format. Private Sub Worksheet_Change(ByVal Target As Range) For Each cell In ActiveSheet.Range(A1:Z100) If cell.Value 2 Then cell.NumberFormat = [=0]Poor;[=1]Average End If If cell.Value 1 And cell.Value 4 Then cell.NumberFormat = [=2]Good;[=3]Excellent End If Next End Sub I hope this macro will help you. Let us know if it does not work or any further help is required. Best regards, Ayush Jain [Group Owner and Manager] On Nov 14, 1:52 pm, Abhishek Jain abhishek@gmail.comhttp://mc/compose?to=abhishek@gmail.com wrote: Hi folks, I have this cell where the values filled can be - 0 or 1 or 2 or 3. I want to set a custom format for excel to show - Poor for 0 Average for 1 Good for 2 Excellent for 3 Now, I've tried and figured out that I can set maximum 03 conditions in Custom Number format but in my case they are 4. I used this format - [=0]Poor;[=1]Average;Good It's working for 03 conditions but If I add one more condition in this, - error ! format can't be set. I tried this formula in Conditional Formatting, which is working in another cell but not in formatting - =IF(J2=0,Poor,IF(J2=1,Average,IF(J2=2,Good,Excellent))) Any help is greatly appreciated. Thanks, AJ -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Yahoo! India has a new look. Take a sneak peekhttp://in.rd.yahoo.com/tagline_metro_2/*http://in.yahoo.com/trynew . -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at
Re: $$Excel-Macros$$ lenghty IF formula
Dear Johnny, First you should try to identify important factors or key locators in your data and they you can try SUMPRODUCT formula or some other array functionality to achieve the desired result. For better explanation, attach a sample spreadsheet. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/15/09, Johnnyboy5 intermediatec...@googlemail.com wrote: I need to use the IF 53 times ! I have 53 rows which I am using filter and Subtotal (row70) I need to get one of the columns C to enter its text (names) into the subtotal row 70. However I can only use the brackets up to 9 times ( I think) can does anyone know how to reduce the formula size. I need to get A70 up to =53 and likewise with the C column. =IF(A70=3,C3,IF(A70=4,C4,IF(A70=5,C5,IF(A70=6,C6,IF(A70=6,C6,IF (A70=7,C7,IF(A70=8,C8, IF(A70=9,C9 Row 70 works like this if the subtotal in column A row 70 = 5 then in the subtotal column C (where the above formula is) it puts the name of the person, all the other subtotal columns are for data and they work fine. This does what I need but I need but only up to number 9, I need to get the equals up to number 53 and therefore the C part of the formula up to 53. thanks everyboy how reads these posts. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Flagging duplicate values with Countif and Search functions re partial matches
Dear Dan, I have tried to build up the data as mentioned by you and able to get the desired result. Same spreadsheet is attached herewith for your review. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/15/09, dsulliva dsh...@gmail.com wrote: Hi Everyone...I have a list of names (column A) and in column B I want a formula to flag all duplicate items in column A. I was using the formula =IF(COUNTIF($A$2:$A$10,A2)1,1,0) where 1 would flag me to a possible duplicte (i.e. I could filter on it). The data in column A is causing problems. Column A contains names. It could be in the format first name / last name or last name / first name. There also could be a comma or a semi-colon separating the 2. There almost always will be a space between the two. My solution was to use the last 4 or 5 charactes of the column A cell and use that as a condition in the count if. It looks something like this, but I can't get it to work. =IF(COUNTIF($A$2:$A$13,IF(ISERROR(SEARCH(RIGHT($A2,2),$A2,1))=TRUE, 0,1)), 1,0) Can someone give me some advice? I'm also open to other formulas / functions that would allow me to flag possible duplicate names based upon a partial match of the cell (e.g. a cell in column A containing Ron Smith would have to identify Smith, Ron; Smith Ron; Smith; Ron; Ron, Smith as a potential duplicate values). Then there's possible duplicate data that contains spelling errors (e.g. Smith vs. Smithh vs. Smyth). I don't think there's any help for that?? I'd prefer not to sort, subtotal, etc. the data and I'm using Excel 2003. I also don't want VBA solutions. Thanks Dan -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Flagging duplicate values - by DILipandey.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ excel certificate course
i took exams at brainbench.com. This is good. Regards, Sarfaraz Ahmed Microsoft Excel and VBA help http://findsarfaraz.blogspot.com/ On Sun, Nov 15, 2009 at 4:40 PM, karthikeyan karthikeyansankar...@gmail.com wrote: Hi all, I am from chennai.If any body knows about online excel certificate course.Pls let me know. txs karthik -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks with regards, Sarfaraz Ahmed a target=_blank href=http://feeds2.feedburner.com/~r/blogspot/rtws/~6/6;img src=http://feeds2.feedburner.com/blogspot/rtws.6.gif; alt=Free MS Excel help style=border:0/a -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ lenghty IF formula
Hi, got the answer I am using either of these, but the shorter one works just the same. Thanks for your reply. Johnnyboy ROW 70 in the MAIN sheet =IF(AND(A70=3,A70=53),INDIRECT (CA70)) ROW 70 in the MAIN sheet =INDIRECT(c A70) On 15 Nov, 12:37, Dilip Pandey dilipan...@gmail.com wrote: Dear Johnny, First you should try to identify important factors or key locators in your data and they you can try SUMPRODUCT formula or some other array functionality to achieve the desired result. For better explanation, attach a sample spreadsheet. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/15/09, Johnnyboy5 intermediatec...@googlemail.com wrote: I need to use the IF 53 times ! I have 53 rows which I am using filter and Subtotal (row70) I need to get one of the columns C to enter its text (names) into the subtotal row 70. However I can only use the brackets up to 9 times ( I think) can does anyone know how to reduce the formula size. I need to get A70 up to =53 and likewise with the C column. =IF(A70=3,C3,IF(A70=4,C4,IF(A70=5,C5,IF(A70=6,C6,IF(A70=6,C6,IF (A70=7,C7,IF(A70=8,C8, IF(A70=9,C9 Row 70 works like this if the subtotal in column A row 70 = 5 then in the subtotal column C (where the above formula is) it puts the name of the person, all the other subtotal columns are for data and they work fine. This does what I need but I need but only up to number 9, I need to get the equals up to number 53 and therefore the C part of the formula up to 53. thanks everyboy how reads these posts. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials athttp://www.excel-macros.blogspot.com 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Problem.Pls help
There is no explanation in your worksheet! -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file
Hello, I think i did some effort to solve your problem take a look at this post : http://groups.google.com/group/excel-macros/browse_thread/thread/29083fc9f3da2cdc Hope this helps you -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ hi
Your being troubled by array functions. those curly brackets cannot be entered manually. On Fri, Nov 13, 2009 at 3:45 AM, Shraddha Shah shraddh...@sbm-india.comwrote: Hi, We are using the attached file to prepare certain reports for the bank. We need to actually bucket the all the deposits as per the maturities given. One of colleague is using this formula (highlighted in yellow). Can u suggest any other method. If not please help me with the same formula as im unable to use the same. *Thanks Regards* *Shraddha Shah* *State Bank of **Mauritius* *Tel - 2 2846 560 Ext (115)* P* Please don't print this e-mail unless you really need to.* -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: text and date in one cell
You are always welcome..!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Nov 15, 2009 at 9:09 PM, Prashanth Banneni praba...@gmail.comwrote: Hi Dilip, Thanks a lot, You are a genius Thanks Prashanth On Sat, Nov 14, 2009 at 10:38 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Prashanth, You can use following formula to get the desired output. =C3TEXT(D3, MMM-YY) Solved workbook is also attached. Let me know if solves your query Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/12/09, Prashanth Banneni praba...@gmail.com wrote: Hi All, Can you help me how to get the desired output from the attached sheet. Many thanks in advance Best Prashanth -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: excel certificate course
Dear Karthikeyan There are numerous online institute providing the online teaching and conduct certificate examinations. I am sending u the one link for that. They must charge u in dollar somewhere near about $50. http://www.technologyed.com/teach.php Thanks Regards Shashi Ranjan On Nov 15, 4:10 pm, karthikeyan karthikeyansankar...@gmail.com wrote: Hi all, I am from chennai.If any body knows about online excel certificate course.Pls let me know. txs karthik -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe