Dear excel experts, Pls tell me how to use vlookup in backward series. Means data match with last colmn to first colmn. On Oct 29, 2013 11:32 PM, <excel-macros@googlegroups.com> wrote:
> Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > - data cleansing <#142068f3d9b7fee1_group_thread_0> [1 Update] > - Pivot Table Query <#142068f3d9b7fee1_group_thread_1> [3 Updates] > - Formula for Lookup Based on 3-Factors Rather than Helper > Columns<#142068f3d9b7fee1_group_thread_2>[1 Update] > - Excel Password Recovery <#142068f3d9b7fee1_group_thread_3> [1 Update] > - Validation Micro <#142068f3d9b7fee1_group_thread_4> [3 Updates] > - UDF convert to Macro <#142068f3d9b7fee1_group_thread_5> [5 Updates] > > data > cleansing<http://groups.google.com/group/excel-macros/t/c35a77c377401982> > > "Pehrson, Dave" <dpehr...@walbro.com> Oct 29 11:06PM > > I have a situation where I down load data and delineate results > leaving a name with blanks behind the number making a Vlookup difficult. > > ASIAN HONDA MOTOR CO.,LTD. > > The name above is an example. > ...more<http://groups.google.com/group/excel-macros/msg/77a9aa83ebe090b9> > > Back to top. <#142068f3d9b7fee1_digest_top> > > Pivot Table > Query<http://groups.google.com/group/excel-macros/t/1f4357048b21f6b9> > > Pravin Gunjal <isk1...@gmail.com> Oct 29 01:38PM +0530 > > *Hello,* > * > * > *I have created a pivot table for attached file as per column F, I & M > from > Data Sheet. * > * > * > *I want the total of return types “Expiry, Damage/Breakage, Near > Expiry” in > ...more<http://groups.google.com/group/excel-macros/msg/f8b7ac2ab7f7aa32> > > Back to top. <#142068f3d9b7fee1_digest_top> > > > xlstime <xlst...@gmail.com> Oct 29 01:58PM +0530 > > place "Return type" in column Labels > > ......................... > > Enjoy > Team XLS > > > > ...more<http://groups.google.com/group/excel-macros/msg/33a4cb6d344e2e36> > > Back to top. <#142068f3d9b7fee1_digest_top> > > > "Bé Trần Văn" <betnmtdongna...@gmail.com> Oct 29 11:50PM +0700 > > Use the PivotTable VBA Query, see Attachment > > 2013/10/29 xlstime <xlst...@gmail.com> > > ...more<http://groups.google.com/group/excel-macros/msg/e45653e97616b952> > > Back to top. <#142068f3d9b7fee1_digest_top> > > Formula for Lookup Based on 3-Factors Rather than Helper > Columns<http://groups.google.com/group/excel-macros/t/dcea953e126981b7> > > "John A. Smith" <johnasmit...@gmail.com> Oct 29 10:30AM -0400 > > I need help with a formula that will examine three factors and return > the > associated value. > DOWNLOAD: Indicator *Division* *Jan-13* *Feb-13* Indicator1-Sales > Division1 209 301 > ...more<http://groups.google.com/group/excel-macros/msg/1aaf64095b425e73> > > Back to top. <#142068f3d9b7fee1_digest_top> > > Excel Password > Recovery<http://groups.google.com/group/excel-macros/t/f203bd52ba990277> > > Advard Smith <advaedsm...@gmail.com> Oct 28 11:48PM -0700 > > hello debash > now you can unlock excel sheet with your original excel workbook. > Before > few days i have also face this problem then i found Excel password > recovery > software which is very fast > ...more<http://groups.google.com/group/excel-macros/msg/10d41e5f8e125624> > > Back to top. <#142068f3d9b7fee1_digest_top> > > Validation > Micro<http://groups.google.com/group/excel-macros/t/a4238303cf23e4b9> > > Rupesh Patil <patil.rupesh1...@gmail.com> Oct 29 10:43AM +0530 > > Hi exports > I have sheet with some columns name of the columns is Mis No, Mob No, > Student name, email id, others. what i need is take sheet from local > system > and validate the column such as Mis No > ...more<http://groups.google.com/group/excel-macros/msg/62118b5eff66cde1> > > Back to top. <#142068f3d9b7fee1_digest_top> > > > "Ravinder" <ravinderexcelgr...@gmail.com> Oct 29 11:12AM +0530 > > Pls give some example file so > > > > From: excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] > On Behalf Of Rupesh Patil > Sent: Tuesday, October 29, 2013 10:43 AM > ...more<http://groups.google.com/group/excel-macros/msg/613972369ab2946b> > > Back to top. <#142068f3d9b7fee1_digest_top> > > > Rupesh Patil <patil.rupesh1...@gmail.com> Oct 29 11:25AM +0530 > > Dear Ravinder, > > I am really thankful your interest on this thread. > > you were ask me sample file, so Please find in attachment. > > Thanks Ruepsh, > > > > -- > Thanks and Regards, Rp. > ...more<http://groups.google.com/group/excel-macros/msg/9c3d640a29980a5b> > > Back to top. <#142068f3d9b7fee1_digest_top> > > UDF convert to > Macro<http://groups.google.com/group/excel-macros/t/fc5b12e559dceaf9> > > Prafull Jadhav <prafulltjad...@gmail.com> Oct 29 10:11AM +0530 > > Dear All, > Very Good Morning ..and Have a Great Day Ahead! > > I got below Function from our group . I have modified it . We can put > Space > between word > for example > PrafullJadhav then output is > ...more<http://groups.google.com/group/excel-macros/msg/3e24b080c2231e73> > > Back to top. <#142068f3d9b7fee1_digest_top> > > > "Ravinder" <ravinderexcelgr...@gmail.com> Oct 29 10:24AM +0530 > > PFA OR BELOW CODE > > Sub putspace() > > Dim rng As Range > > Set rng = Application.InputBox("Please Select Range", Type:=8) > > For Each T In rng > > k = T > > For i = 1 To Len(T) > > j = Mid(T, i, 1) > ...more<http://groups.google.com/group/excel-macros/msg/3f0123b3b3fb1d09> > > Back to top. <#142068f3d9b7fee1_digest_top> > > > "Ravinder" <ravinderexcelgr...@gmail.com> Oct 29 10:26AM +0530 > > PFA OR BELOW CODE > > > > Sub putspace() > > Dim rng As Range > > Set rng = Application.InputBox("Please Select Range", Type:=8) > > For Each T In rng > > k = T > > For i = 1 To Len(T) > > j = Mid(T, i, 1) > ...more<http://groups.google.com/group/excel-macros/msg/c07bd47470a68559> > > Back to top. <#142068f3d9b7fee1_digest_top> > > > "Ravinder" <ravinderexcelgr...@gmail.com> Oct 29 10:29AM +0530 > > PFA OR BELOW CODE > > > > Sub putspace() > > Dim rng As Range > > Set rng = Application.InputBox("Please Select Range", Type:=8) > > For Each T In rng > > k = T > > For i = 1 To Len(T) > > j = Mid(T, i, 1) > ...more<http://groups.google.com/group/excel-macros/msg/b98550409b66c642> > > Back to top. <#142068f3d9b7fee1_digest_top> > > > Prafull Jadhav <prafulltjad...@gmail.com> Oct 29 10:58AM +0530 > > Dear All, > > Thanks to Everybody...It is really working fine... > > Regards, > Prafull Jadhav > 9920553518 > > > On Tue, Oct 29, 2013 at 10:11 AM, Prafull Jadhav > ...more<http://groups.google.com/group/excel-macros/msg/67544997f7a893d9> > > Back to top. <#142068f3d9b7fee1_digest_top> > > -- > 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. > -- 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.
