Search results

I have a VBA code on an Excel file which works absolutely fine on Office 2013 on Windows. However it does not work on MS Office on MAC. The Code extracts the list of excel files in in the folder in which the VBA file is kept. The code is as below. Sub List_Files() Dim MyFile As String Dim a As...

Sorry for inconvenience This is the full address: check the file "forecast chart" in this folder: https://skydrive.live.com/redir.aspx?cid=16d5e40738502388&resid=16D5E40738502388!103&authkey=xmIdtAa3YnU%24

The above formula works only for numbers. the formula below works for other content. =IFERROR(INDEX($A$2:$A$8,LARGE(IF($B$2:$B$8=$C2,ROW($A$2:$A$8),0),COLUMN()-3)-1) Also remember if there are more than 3 appearances, you will have to extend to more than 3 columns.

Dear Ahhhmed, In the sample sheet you have given, i think the following formula would work: Assuming: B2:B8 has the names, A2:A8 has the numbers you want, C2,C3 etc have the dropdowns. in cell D2 =LARGE(($B$2:$B$8=$C2)*$A$2:$A$8,COLUMN()-3) this is an array formula and require ctrl +...

Hi Kamarlon, I think this is what you want. check the file "forecast chart" in this folder: https://skydrive.live.com/?cid=16d5e40738502388&id=16D5E40738502388%21103

Hi F K Williams, I have done this once in an attendance record keeping sheet. But this will require at least 3 more columns in your work sheet. That too it generated a pseudo alphabetical order and hand many caveats. But there is an awesome way already put up by the hero. Here is the link...

Hi Rob, Have you tried evaluating if it is possible at all? Like it is not possible when you try with 4 teams, 2 rounds and 2 venues (i.e. 2 games). If we ignore the "7 rounds" constraint, then there is at least one solutions. If this is a real life problem, I think you may add another round...

I have used a similar feature in one of my older works. The following steps can help: For drop down, you can use Data Validation with list, and use Vlookup or Index+Match to show Sku#, price & quantity. Add buttons on each of price sheets to confirm an item and populate on the quotation...

Dear Jaefo, From what I understand of the problem, this would work. Assuming you have figures in different sheets of "sales" workbook and want reports in different sheets in "score" workbook. This code works when both the workbooks are open. Dim i As Integer For i = 1 To 3 Step 1...

It seems excel does not recognize the way you have input the ranges. Also In my system, this "Sheets(i)" thing is not working thus I have used "Sheets(1). Try the following code, this seems to work. workbooks("sales").Sheets(1).Range("L40").Value =...

This is what you have to do, 1.Select lower limit and Difference column. 2.In office 07+, Insert->Area->2D area->Stacked 3.Now select the lower area, most likely blue and Format->Shape fill->No Fill Your envelope is ready. 4.Now right click on chart->Select...

I have used a helper column, you can change the required months in the cell in yellow. I have made provision for up to 4 months. http://www.keepandshare.com/doc/3065791/conditional-averageif-xlsx-august-10-2011-10-44-am-10k?da=y Hope this helps.